amendments

Single-instance and RAC to create the ORACLE STREAM (2)

kods.net — Tue, 19 Jan 2010 16:50:10+0000

After completion of parameter settings, the following to start the master and backup database is set to archive mode. The reason why this part of the single opening is due to single-instance database is set to archive mode and ORACLE RAC is set to archive mode is slightly different, the following were described as follows:

Single-instance, the revised database archiving mode only requires the following four steps:

1, shutdown immediate

2, startup mount

3, alter database archivelog

4, alter database open

You can also set the archive man-made path, do not use the system default archive path, mainly to avoid year after year in archive log files generated by the database where the file system Chengbao, where a separate log will be archived into a single file system "/ arch" the following:

SQL> alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION = / arch';

Amendments adopted after the completion of the command "archive log list" to confirm:

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination / arch
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2

ORACLE RAC, modify the database archiving mode is slightly more complicated, the steps are as follows:

1, create pfile = '/ arch / pfilestorm.ora' from spfile;

2, shutdown immediate (storm1 and storm2 examples should close)

3, using the vi editor generated pfile (pfilestorm.ora), and modify the following parameters:

cluster_database = false

4, to modify the parameter file for the full-length after a separate database in a node starts to nomount Status:

startup nomount pfile = '/ arch / pfilestorm.ora';

5, so that the database to exclusive (exclusive) mode starts to mount status:

alter database mount exclusive

6, to change the archive mode and archive path:

alter database archivelog
alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION = / arch'; (this step can also write directly Parameter File)

7, shutdown immediate (storm1)

8, using the vi editor generated pfile (pfilestorm.ora), and modify the following parameters:
cluster_database = true

9, startup pfile = '/ arch / pfilestorm.ora'; (At this point the database has been out of archive mode)

10, create spfile from pfile;

11, shutdown immediate (storm1)

12, startup (At this point the database to a server parameter file starts)

13, startup (in the storm2 start)

RAC corresponding two nodes are started, through the command test to see whether the entry into force set up:

storm1:

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination / arch
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2

storm2:

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination / arch
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2

To this, the main library and prepared by the library archive mode is completed, the following into the other steps.

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
High Availability Oracle Flashback 2009-02-26 17:23:02
An example of the use of TKPROF 2009-02-26 01:38:19
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

After the resumption of different machines to solve ORA-01152 error

kods.net — Sat, 05 Sep 2009 20:50:04+0000

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

rn
RMAN-03002: failure of backup command at 09/02/2009 02:21:47

rn
ORA-19625: error identifying file / u03/oracle / archivelog/2009_08_31/1_3783_634497921.dbf

rn
==== Ended in error on Wed Sep 2 02:21:48 CST 2009 ====

rn
At this time the need for the following amendments:

rn
Log normal operation of the host:

rn
rn
$ Rman target / catalog rman / rman @ catalog

rn
RMAN> crosscheck archivelog all;

rn

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
High Availability Oracle Flashback 2009-02-26 17:23:02
An example of the use of TKPROF 2009-02-26 01:38:19
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

oracle user profile is used

kods.net — Wed, 05 Aug 2009 23:45:04+0000

rn
Profile file by using the user defined attributes, such as for product users to establish a profile document
rn
create profile product_profile limit SESSIONS_PER_USER 1; --- set the user can establish a session of the profile
rn
alter user product profile product_profile; - so that product users product_profile
rn

rn
Restrictions to the entry into force of the above, initialization parameters need to be amended resource_limit
rn
show parameter resource;
rn
NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
resource_limit boolean FALSE
resource_manager_plan string
rn
Can be seen resource_limit parameter is false, be amended as true
rn
alter system set resource_limit = true;
rn

rn
View dba_profiles can view to see the user's default properties
rn

rn
When modified the following method can be used, such as amendments to the failure of landing the number of users, the default is 10, is amended as unlimited
rn
alter profile PRODUCT_PROFILE limit FAILED_LOGIN_ATTEMPTS unlimited; --- modify the number of failed login method

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
High Availability Oracle Flashback 2009-02-26 17:23:02
An example of the use of TKPROF 2009-02-26 01:38:19
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

RHEL5 Oracle10g (10.2.0.1) x86_64 installation steps

kods.net — Fri, 10 Jul 2009 05:31:49+0000

RHEL5 Oracle10g (10.2.0.1) x86_64 installation steps

1. To ensure that there is no problem with the network, especially the network card settings, set the network adapter on the host name.

Modify / etc / hosts file to 127.0.0.1 modify settings for the card (actually straight) ip address, then the host name to remove the excess, leaving only a true host name.

2. If you install 32-bit machine, just Check i386 packages. Verification of the following package is installed. (Note: If the 64-bit machine, some packets need to i386 and x86_64 installed the rpm package.)

# From RedHat AS5 Disk 1

rpm-Uvh setarch-2.0-1.1.x86_64.rpm # rpm-Uvh setarch-2 *

rpm-Uvh make-3.81-1.1.x86_64.rpm # rpm-Uvh make-3 *

rpm-Uvh glibc-2.5-12.x86_64.rpm # rpm-Uvh glibc-2 *

rpm-Uvh libaio-0.3.106-3.2.x86_64.rpm # rpm-Uvh libaio-0 *

rpm-Uvh libaio-0.3.106-3.2.i386.rpm # rpm-Uvh libaio-0 *

# From RedHat AS5 Disk 2

rpm-Uvh gcc-4.1.1-52.el5.x86_64.rpm # rpm-Uvh gcc-4 *

# From RedHat AS5 Disk 3

rpm-Uvh compat-libstdc + +-33-3.2.3-61.x86_64.rpm # rpm-Uvh compat-libstdc + + -33-3 *

rpm-Uvh compat-gcc-34-3.4.6-4.x86_64.rpm # rpm-Uvh compat-gcc-34-3 *

rpm-Uvh compat-gcc-34-c + +-3.4.6-4.x86_64.rpm # rpm-Uvh compat-gcc-34-c + + -3 *

rpm-Uvh libXp-1.0.0-8.x86_64.rpm # rpm-Uvh libXp-1 *

rpm-Uvh libXp-1.0.0-8.i386.rpm # rpm-Uvh libXp-1 *

rpm-Uvh openmotif-2.3.0-0.3.el5.x86_64.rpm # rpm-Uvh openmotif-2 *

rpm-Uvh compat-db-4.2.52-5.1.x86_64.rpm # rpm-Uvh compat-db-4 *

3. The following amendments to the kernel parameters and other documents

vi / etc / sysctl.conf add the following line at the end of

# 20071212 add content for oracle install

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

# Semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 262144

net.core.rmem_max = 262144

net.core.wmem_default = 262144

net.core.wmem_max = 262144

By executing the command. Just write the parameters into. Non-implementation, oracle before installation in the back of the testing will report to the police.

# sysctl-p

vi / etc / security / limits.conf add the following line at the end of

# 20071212 add content for oracle install

* Soft nproc 2047

* Hard nproc 16384

* Soft nofile 1024

* Hard nofile 65536

vi / etc / pam.d / login add the following line at the end of

# 20071212 add content for oracle install

session required pam_limits.so

Modify the parameters / etc / profile at the end of add

if [$ USER = "oracle"]; then

if [$ SHELL = "/ bin / ksh"]; then

ulimit-p 16384

ulimit-n 65536

else

ulimit-u 16384-n 65536

fi

fi

vi / etc / selinux / config to ensure that the following

SELINUX = disabled

Check it here again.

4. Create oracle user, and a number of installation directory

groupadd dba

groupadd oinstall

useradd-g oinstall-G dba-m oracle

passwd oracle

mkdir-p / opt / oracle

chown-R oracle.oinstall / opt / oracle

5 .. add the environment variables, such as the definition of SID

su - oracle

vi. bash_profile

#--------------------------------------

# Set for Oracle10g Install;

#--------------------------------------

export TMP = / tmp

export TMPDIR = $ TMP

export ORACLE_BASE = / opt / oracle

export ORACLE_HOME = $ ORACLE_BASE/product/10.2.0/db_1

export ORACLE_SID = oracle

export ORACLE_TERM = xterm

export PATH = / usr / sbin: $ PATH

export PATH = $ ORACLE_HOME / bin: $ PATH

# export LD_LIBRARY_PATH = $ LD_LIBRARY_PATH: $ ORACLE_HOME / lib: / usr / lib: / usr / local / lib

export LD_LIBRARY_PATH = $ ORACLE_HOME / lib: / lib64: / usr/lib64: / usr/local/lib64: / usr/X11R6/lib64 /

export CLASSPATH = $ ORACLE_HOME / JRE: $ ORACLE_HOME / jlib: $ ORACLE_HOME / rdbms / jlib

export NLS_LANG = "American_america.utf8"

umask 022

Implementation of environmental settings

source ~ /. bash_profile

(Note: NLS_LANG and LANG settings to choose according to the actual situation, the best character set to use English, Chinese character set problem sometimes, NLS_LANG = AMERICAN_AMERICA.ZHS16GBK LANG = en_US)

6. Because oracle only supports the official date to RHEL4, so a modified version of that document to edit / etc / redhat-release to Red Hat Enterprise Linux Server release 5 (Tikanga) changed to version 4, of course, after the oracle installation is complete, it is necessary to amend the return:

vim / etc / redhat-release

Deletion of Red Hat Enterprise Linux Server release 5 (Tikanga)

Add Red Hat Enterprise Linux AS release 4 (Nahant Update 4)

7. The establishment of the installation directory:

mkdir-p / opt/oracle/product/10.2.0/db_1

chown-R oracle.oinstall / opt

8. To start the installation extract the installation files

cd / tmp

gunzip 10201_database_linux_x86_64.cpio.gz

cpio-idmv <10201_database_linux_x86_64.cpio

chown-R oracle: oinstall / tmp / database

chmod 755 / tmp / database

9. Or write-off after the restart to oracle user login system, step-by-step in the implementation of extracting installation file path command

#. / RunInstaller

10. Related to the solution to the problem:

Question 1:

libXp.so.6: cannot open shared object file: No such file or directory

Solution: libXp need to install packages in x86_64 need the following two packages are loaded.

rpm-Uvh libXp-1.0.0-8.x86_64.rpm

rpm-Uvh libXp-1.0.0-8.i386.rpm

Question 2:

Xlib: connection to ": 0.0" refused by server appears this warning, and can not start. / RunInstaller

Solution: under the root user # xhost local: oracle, and then # su - oracle

Question 3:

If users log in using the oracle desktop failed, suggesting that "may be the lack of space, session terminated" and can not log on the desktop.

Solution: Please check under the oracle user. Bash_profile the environment variable in writing whether there is any error.

11. Some of the services were introduced and added

a: $ ORACLE_HOME / bin / dbstart | dbshut

b: $ ORACLE_HOME / bin / lsnrctl start | stop listening device is switched on | turn off.

c: $ ORACLE_HOME / bin / emctl start | stop dbconsole

Visit http://yourIP:1158/em

d: $ ORACLE_HOME / bin / isqlplusctl start | stop

Visit http://yourIP:5560/isqlplus

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
High Availability Oracle Flashback 2009-02-26 17:23:02
An example of the use of TKPROF 2009-02-26 01:38:19
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

Oracle Database initialization parameter changes to note

kods.net — Fri, 26 Jun 2009 06:38:13+0000

Generally only in large-scale application or performance data, according to the Treasury decreased only need to change the initialization parameters. So from this perspective, the adjustment of parameters to initialize Oracle database is a high-level applications. But this is also an Oracle database administrators need to master the content. In order to better adjust the database initialization parameters, I believe that administrators in understanding the use of all initialization parameters and adjust the rules, need to be aware of some initialization parameters to adjust the content of a number of similarities. Specifically, in the following areas.
First, do not need to know what parameters to restart to take effect.

In the Oracle database, according to the time the entry into force of different parameters can be roughly divided into two categories. One is to be able to restart after the entry into force of amendments to, or parameters; another type of modification is not required to re-start after the entry into force of that parameter. Generally speaking, database administrators prefer the second type of parameters, that is, do not need to restart the revised parameters take effect immediately. Why? Because the use of the database server into production after the restart can not be arbitrary. If modifications need to restart in order to take effect, or need to modify the parameters before we can start, then adjust the parameters in the course of a clear need to interrupt the user's visit will increase downtime. This database deployment, the combat will be very large. Because, from the stability and availability, the database administrator is to minimize downtime for the goal. At this point the increase in man-made and downtime, it is clear there is a conflict with this goal. Therefore, the database administrator will need to know which parameter is not required to re-start can be modified with the entry into force; and what parameters must be before they can restart. This is a database administrator for further adjustment of parameters need to know before the first content. On the one hand, according to the characteristics of administrators to assess the loss of downtime and adjustment parameters of the potential benefits. If losses exceed gains, then there is still need to adjust the initialization parameters. The second is to determine the parameters of the adjustment time. Which do not need to restart, that is, adjust the parameters would not result in the case of downtime, then the adjustment of parameters is relatively flexible, few restrictions. However, if the need to adjust the entry into force will be able to restart or modify the parameters, then need to select an appropriate time to. If you need to choose after the 0:00 time, this time using the database is often not a lot of users. Of course, all this time may be different for each Qiye . The use of a word is to select a database when the user as little as possible. If so will it be possible to the maximum extent possible to reduce the losses caused by database downtime.

What are the parameters then restart not required for the purposes can be amended? In fact, database administrators only need to query the dynamic view, that is, to know which parameters can not shut down or restart you can change. Such as dynamic as in the v $ parameter, the stored value of the initialization parameters. In general, you can add query conditions issys_modifiable <> 'FALSE' or isses_modifiable <> 'FALSE' (note that they are or the relationship between, rather than and relations), and finally out the parameters of inquiry is not to close or re - can start the database initialization parameter settings. At the same time, these parameters also can be used with the ALTER SYSTEM command ALTER SESSION to change some initialization parameters. In other words, do not shut down or restart the database on the parameters can modify the above two commands can be used to re-set. But not to say that the use of these two orders can not restart or shut down the database initialization parameters to change the situation. Simply put, is that we can use these two commands to change the parameters, and some need to restart or shut down the database, while others do not.

Second, under the 20/80 principle to determine the need to change the parameters.

Oracle database initialization parameters are more than a hundred. No matter what the purpose of adjustment to each of these parameters are often unrealistic. A good database administrators only need a few parameters which can be modified. Often have several parameters modification method, in principle, to pay attention to matters to be completed on most of the database maintenance tasks. This is the law of 20/80 in his role. In other words, only 20% of the required parameters (in fact, is far less than the ratio), you can complete 80% of the task (in fact much higher than the ratio). In other words, the 10/90 rule of the initialization parameters for Oracle, may be more applicable. In short I want to say is that only need to master the large number of initialization parameters can be few. If required, by adjusting the initialization parameter to increase database performance, or other purposes, that is, a small number of these initialization parameters. For other parameters, database administrators only need to be aware of its use, without the need to understand how to adjust these parameters. Because the probability of experiencing little can be said.

These important parameters which in the end it? Mainly in the following parameters. One of the most important parameter is the DB_CACHE_SIZE. This is a database used to adjust the parameters of the cache size. When necessary, adjust the size of this parameter, you can improve data cache hit rate, thus substantially improved the performance of the database. The second parameter is DB_BLOCK_SIZE. This parameter is used to specify the database by default when in the establishment of the block size. If the block set is relatively small, there may occur the phenomenon of chain line, thereby reducing the performance of the database; also may increase the database of debris, waste table space, storage space and reduce the performance of database queries and so on. Sometimes there needs to be adjusted in accordance with the block size to improve the performance of the database. The third parameter is SHARED_POOL_SIZE parameters. This parameter is mainly for those data dictionary cache and shared SQL statement specified in the SGA allocated in memory. Simple, the rational distribution of the parameters, can share the same SQL statement. Adjust the parameters to optimize database performance is also a common means. SGA_MAX_SIZE parameters for the fourth parameter, this parameter specifies the dynamic growth of the SGA may be the biggest memory. SQLServer database in a similar parameters. Generally speaking, in the same database server is deployed in a number of applications will often need to configure the parameters of a reasonable number of applications to avoid contention between the memory. If the inappropriate parameter settings, then sometimes will lead to another kind of applications do not have enough memory as a result of the cessation of services. The fifth parameter is LOG_CHECKPOINT_INTERVAL. This parameter is mainly used to set the frequency of checkpoints. Each checkpoint, the database system for the implementation of data to write all dirty block (has been modified not saved to your hard disk of the data) to the database to write the corresponding data file. By default, if the database cache in the 1 / 4 of the data buffer is a dirty buffer, then the database system will automatically check points. In addition the principle of a mandatory switch is in the log, it will also implement the checkpoint. In some specific circumstances, such as the creation of data warehouse, the parameters need to be adjusted to meet the needs of specific occasions. Parameters of the five writers in recent years over the work of the most frequently encountered initialization parameter. Basically, the database maintenance and performance tuning is surrounded by a few parameters to the. To this end I suggested that a database administrator that the database initialization parameters in the learning skills of the adjustment, you can start from a number of parameters. In other words, these parameters are the database administrator must be available. Understanding of not only simple, but the need to thoroughly understand it. Only then, faced with the situation, we can then judge whether there is a need to make changes, as well as respond to changes in the course of the problems that may arise. For other parameters, I believe that a database administrator needs only to understand their basic use. In conclusion, perhaps the author of these parameters, some miss the place, welcome you to supplement. After a chance, I would like all details of the circumstances under which the adjustment of any parameter; as well as in the adjustment process may be trouble. If you interested in this topic may be concerned about the author behind the article.

Third, the use of SPFILE to dynamically modify the parameters.

In a future version Oracle10G, also allows the database administrator to store the SPFILE using the example of a dynamic parameter modification. In previous versions of 10G, unless the parameters manually added to the initial parameters of the document, or dynamic changes to parameters in the database will be lost after restart. This environment variable is somewhat similar to the set. However, in subsequent versions of 10G, in this respect a great improvement. SPFILE mechanisms such as open, then the system will enable a server parameter file, the dynamic changes in memory some of the parameters at the same time these changes will be recorded in the server parameter file. Wait until the next restart, the server will read like a server parameter file value, used to initialize the database system. In other words, from now on a number of dynamic parameters can be modified a permanent effect. This is a database administrator is no doubt a good news.

From the above analysis we can see that the database parameters of the adjustment is a relatively complex task. I believe that administrators in learning how to adjust the parameters until the need to understand the general content of the above. That is, modify the parameters of the time constraints, most likely need to adjust the parameters and how to make the entry into force of the dynamic parameters and so on forever. These are good parameters to optimize the basis of the work.

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
High Availability Oracle Flashback 2009-02-26 17:23:02
An example of the use of TKPROF 2009-02-26 01:38:19
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

RMAN conducted through the bare equipment and file system data file transfer between

kods.net — Wed, 08 Apr 2009 09:52:23+0000

Easy to be an example to introduce how to use data files Rman bare equipment and file system conversion.

1. EYGLE set up equipment used to test bare table space

[oracle@danaly ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 30 14:41:53 2005

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

SQL> create tablespace eygle
  2  datafile '/dev/cciss/c0d0p11' size 10M;

Tablespace created.

SQL> create table eygle tablespace eygle as select * from dba_objects;

Table created.


SQL> select count(*) from eygle;

  COUNT(*)
----------
     50420

SQL> alter tablespace eygle offline;

Tablespace altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

2. Use RMAN to back up the COPY function of the bare device file for the file system file

[oracle@danaly ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Nov 30 16:00:42 2005

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: DANALY (DBID=3965153484)

RMAN> copy datafile '/dev/cciss/c0d0p11' to '/opt/oracle/eygle01.dbf'; 

Starting backup at 30-NOV-05
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=137 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/dev/cciss/c0d0p11
output filename=/opt/oracle/eygle01.dbf tag=TAG20051130T160137 recid=2 stamp=575740898
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:02
Finished backup at 30-NOV-05

RMAN> exit


Recovery Manager complete.

3. The adoption of amendments to rename file location

[oracle@danaly ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 30 16:01:54 2005

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

SQL> alter database rename file '/dev/cciss/c0d0p11' to '/opt/oracle/eygle01.dbf'; 

Database altered.

SQL> alter tablespace eygle online;

Tablespace altered.

SQL> select file_name from dba_data_files where tablespace_name='EYGLE';

FILE_NAME
--------------------------------------------------------------------------------
/opt/oracle/eygle01.dbf

4. To carry out data modifications

SQL> insert into eygle as select * from eygle;
insert into eygle as select * from eygle
                  *
ERROR at line 1:
ORA-00926: missing VALUES keyword


SQL> insert into eygle select * from eygle;
insert into eygle select * from eygle
            *
ERROR at line 1:
ORA-01653: unable to extend table SYS.EYGLE by 128 in tablespace EYGLE

SQL> alter database datafile '/opt/oracle/eygle01.dbf' resize 20m;

Database altered.

SQL> insert into eygle select * from eygle;

50420 rows created.

SQL> commit;

Commit complete.

SQL> alter tablespace eygle offline;

Tablespace altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

5. Transfer files from the file system to the bare equipment

[oracle@danaly ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Nov 30 16:08:51 2005

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: DANALY (DBID=3965153484)

RMAN> copy datafile '/opt/oracle/eygle01.dbf' to '/dev/cciss/c0d0p11';

Starting backup at 30-NOV-05
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=135 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/opt/oracle/eygle01.dbf
output filename=/dev/cciss/c0d0p11 tag=TAG20051130T160935 recid=3 stamp=575741376
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 30-NOV-05

RMAN> exit


Recovery Manager complete.
[oracle@danaly ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 30 16:09:48 2005

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

SQL> alter database rename file '/opt/oracle/eygle01.dbf' to '/dev/cciss/c0d0p11';

Database altered.

SQL> alter tablespace eygle online;

Tablespace altered.

SQL> select count(*) from eygle; 

  COUNT(*)
----------
    100840

SQL>

rman allows for the bare equipment greatly simplifies the operation.

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
An example of the use of TKPROF 2009-02-26 01:38:19
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

RMAN to bare through the file system equipment and data files between the migration

kods.net — Wed, 08 Apr 2009 06:41:37+0000

To be a brief example of how to use data files for Rman bare equipment and file system conversion.

1. EYGLE the establishment of the use of test equipment bare table space

[oracle@danaly ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 30 14:41:53 2005

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

SQL> create tablespace eygle
  2  datafile '/dev/cciss/c0d0p11' size 10M;

Tablespace created.

SQL> create table eygle tablespace eygle as select * from dba_objects;

Table created.


SQL> select count(*) from eygle;

  COUNT(*)
----------
     50420

SQL> alter tablespace eygle offline;

Tablespace altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

2. Use RMAN to back up the COPY function of the bare device file for the file system file

[oracle@danaly ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Nov 30 16:00:42 2005

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: DANALY (DBID=3965153484)

RMAN> copy datafile '/dev/cciss/c0d0p11' to '/opt/oracle/eygle01.dbf'; 

Starting backup at 30-NOV-05
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=137 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/dev/cciss/c0d0p11
output filename=/opt/oracle/eygle01.dbf tag=TAG20051130T160137 recid=2 stamp=575740898
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:02
Finished backup at 30-NOV-05

RMAN> exit


Recovery Manager complete.

3. The adoption of amendments to rename file location

[oracle@danaly ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 30 16:01:54 2005

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

SQL> alter database rename file '/dev/cciss/c0d0p11' to '/opt/oracle/eygle01.dbf'; 

Database altered.

SQL> alter tablespace eygle online;

Tablespace altered.

SQL> select file_name from dba_data_files where tablespace_name='EYGLE';

FILE_NAME
--------------------------------------------------------------------------------
/opt/oracle/eygle01.dbf

4. To carry out data modifications

SQL> insert into eygle as select * from eygle;
insert into eygle as select * from eygle
                  *
ERROR at line 1:
ORA-00926: missing VALUES keyword


SQL> insert into eygle select * from eygle;
insert into eygle select * from eygle
            *
ERROR at line 1:
ORA-01653: unable to extend table SYS.EYGLE by 128 in tablespace EYGLE

SQL> alter database datafile '/opt/oracle/eygle01.dbf' resize 20m;

Database altered.

SQL> insert into eygle select * from eygle;

50420 rows created.

SQL> commit;

Commit complete.

SQL> alter tablespace eygle offline;

Tablespace altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

5. Transfer files from the file system to the bare equipment

[oracle@danaly ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Nov 30 16:08:51 2005

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: DANALY (DBID=3965153484)

RMAN> copy datafile '/opt/oracle/eygle01.dbf' to '/dev/cciss/c0d0p11';

Starting backup at 30-NOV-05
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=135 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/opt/oracle/eygle01.dbf
output filename=/dev/cciss/c0d0p11 tag=TAG20051130T160935 recid=3 stamp=575741376
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 30-NOV-05

RMAN> exit


Recovery Manager complete.
[oracle@danaly ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 30 16:09:48 2005

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

SQL> alter database rename file '/opt/oracle/eygle01.dbf' to '/dev/cciss/c0d0p11';

Database altered.

SQL> alter tablespace eygle online;

Tablespace altered.

SQL> select count(*) from eygle; 

  COUNT(*)
----------
    100840

SQL>

rman allows for the bare equipment greatly simplifies the operation.

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
An example of the use of TKPROF 2009-02-26 01:38:19
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

Oracle XDB relax resolve port conflict of 8080

kods.net — Fri, 13 Mar 2009 16:47:42+0000

In this paper, carried: http://www.enet.com.cn/article/2008/0306/A20080306175452.shtml
Oracle 9i from the start, Oracle includes the installation of the default XDB. After starting the database, Oracle XDB's http service will automatically take up a 8080 port, which give use or JBoss, Tomcat for java web development a lot of people cause unnecessary troubles.

This article will introduce amendments to the XDB port http and ftp services to the three kinds of methods.

1. Dbms_xdb package using the modified port settings

Sys log in using sqlplus

sqlplus sys / syspassword as sysdba

The implementation of the script is as follows:

============================

- Change the HTTP / WEBDAV port from 8080 to 8081

call dbms_xdb.cfg_update (updateXML (

dbms_xdb.cfg_get ()

, '/ Xdbconfig / sysconfig / protocolconfig / httpconfig / http-port / text ()'

, 8081))

/

- Change the FTP port from 2100 to 2111

call dbms_xdb.cfg_update (updateXML (

dbms_xdb.cfg_get ()

, '/ Xdbconfig / sysconfig / protocolconfig / ftpconfig / ftp-port / text ()'

, 2111))

/

COMMIT;

EXEC dbms_xdb.cfg_refresh;

2. The use of OEM console

Choose a database, XML Database, Configuration. Change the settings of the XDB.

3. Modify SPFILE [SID name]. ORA file, remove the database initialization parameters:

This document is Oracle startup configuration file dispatchers = '(PROTOCOL = TCP) (SERVICE = XDB)', will be prohibited XDB Service of http and ftp.

Now we come to restart the computer, or restart services at OracleService [SID] of this service. After the restart may not be able to use Enterprise Manager Console and other clients to connect, then please use Oracle's Configuration and Migration Tools / Net Configuration Assistant tool to delete the listener, and then create a new listener, and finally restart the listener.

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
An example of the use of TKPROF 2009-02-26 01:38:19
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

[To] Oracle stored procedure to send mail, and to support user authentication. The Chinese title and content - to amend By-laws

kods.net — Tue, 10 Mar 2009 22:26:48+0000

Oracle stored procedure to send mail, and supports user authentication, the Chinese title and content

Oracle stored procedure in the implementation, we may hope that its own e-mail to complete the implementation of the results, especially in the capture to the abnormal. Can not always rely on stored procedure calls an external procedure - After the call, according to the export parameters, send the results of the implementation. This need more pressing in the Oracle Job involvement Non-manual call the case of stored procedure.

Fortunately, Oracle provides us with a tool kit to send mail UTL_SMTP, it first appeared in the Oracle 8.1.7 version. Here are my search from a network-related information, consolidate, a number of amendments to a number of debugging, against all odds and to write a stored procedure to send mail. To support the need to mail server user authentication, the Chinese title and content of non-English characters, not only support sending attachments, I believe this is the application of less need for Google, then click again, and after the reference in the text of the link.

CREATE OR REPLACE PROCEDURE send_mail (
p_recipient VARCHAR2, - e-mail recipient
Related Posts
- SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
- An example of the use of TKPROF 2009-02-26 01:38:19
- Diagnosis and principles of order 2009-02-25 20:27:28
- ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

Parameter file on the oracle

kods.net — Sat, 07 Jun 2008 13:22:01+0000

rn
Parameter file on the oracle

rn

rn
In general, the default init.ora parameter file in the following directory:

rn
Unix platform: $ (ORACLE_HOME) / dbs

rn
Windows platform: $ ORACLE_HOMEdatabase

rn

rn
Oralce start the process to read parameter file, the default order is:

rn
spfile . ora - oracle database is created automatically create the spfile file

rn
spflie.ora - oracle default spfile file

rn
init . ora - oracle database is created automatically create the pfile file

rn
init.ora - oracle default pfile file

rn

rn
pfile is a text file, spfile is a binary file

rn
For the parameter configuration, pfile in a text editor can open the manual configuration, and spfile not, must be activated in the database by sql command line changes, pfile configuration changes, to use its entry into force, you must restart the database, spfile of configuration to take effect duration and scope to modify the parameters in the sql can be specified in the order, effective immediately, it may not take effect immediately. Of course, some parameters need to restart the database before the changes take effect; can create a sql command from the pfile spfile, you can create the spfile pfile; If it is to manually create the database, rather than through DBCA, then start creating the database, you can only define pfile, because it is a text format; oracle database using only one parameter file, either pfile, either spfile.

rn
How to determine which database is currently using a parameter document?

rn
One way is to create pfile had to identify, if not currently using spfile, then the appropriate format create pfile will produce an error. Another method is to show parameter spfile command to display the location of spfile, if the display is empty, then use the pfile

rn

rn
Parameter file was modified method

rn
Changes and amendments divided into manual online.

rn
Manually modified to modify the pfile, pfile directly modified with a text editor to open. To use the changes to take effect, to restart the database. Online change is in the database is running, use the alter system command to modify the command as follows

rn
sql> alter system set job_queue_processed = 50 scope = MEMORY

rn
Note, scope = MEMORY said application, values are as follows:

rn
SPFILE: modify the SPFILE only effective, does not affect the current instance, need to restart the database to take effect;

rn
MEMORY: changes effective only memory, or only the current examples of effective and immediate effect, but not saved to the SPFILE, this configuration is lost after restarting the database; BOTH: As the name suggests, contains the above two, effective immediately, and permanent.

rn
Modify the parameters for the ALTER SYSTEM command, please note the following:

rn
First, if the current instance using the pfile instead of spfile, then scope = spfile or scope = both will generate an error;

rn
Second, if the instance with pfile start, the scope of the default value of MEMORY, if spfile is triggered, the default is BOTH;

rn
Third, you can use the DEFERRED that the changes apply only to future sessions, you can also use the COMMENT written comments, such as: ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 50 SCOPE = BOTH DEFERRED COMMENT = "comment"

rn
Fourth, remove the parameters as follows: ALTER SYSTEM SET PARAMETER ='';

rn
Create parameter file

rn
For pfile, you can use a text editor to edit a direct hand, you can also use the command create pfile from spfile created, such as: CREATE PFILE = 'C: \ PFILE \ MYPFILE.ORA' FROM SPFILE = 'D: \ SPFILE \ MYSPFILE. ORA ', or from the current instance is created using the spfile: create pfile =' c: \ pfile \ mypfile.ora 'from spfile.
Create spfile command is as follows: CREATE SPFILE FROM PFILE = 'C: \ PFILE \ MYPFILE'.

rn

rn

rn

rn

rn

SGA extended the principle of 32bit oracle 2009-03-31 09:48:01
An example of the use of TKPROF 2009-02-26 01:38:19
Diagnosis and principles of order 2009-02-25 20:27:28
ORACLE 10G dataguard configuration Step by Step 2009-02-16 01:13:55

amendments

Single-instance and RAC to create the ORACLE STREAM (2)

Related Posts

After the resumption of different machines to solve ORA-01152 error

Related Posts

oracle user profile is used

Related Posts

RHEL5 Oracle10g (10.2.0.1) x86_64 installation steps

Related Posts

Oracle Database initialization parameter changes to note

Related Posts

RMAN conducted through the bare equipment and file system data file transfer between

Related Posts

RMAN to bare through the file system equipment and data files between the migration

Related Posts

Oracle XDB relax resolve port conflict of 8080

Related Posts

[To] Oracle stored procedure to send mail, and to support user authentication. The Chinese title and content - to amend By-laws

Related Posts

Parameter file on the oracle

Related Posts