ORA-19550 problem and ORA-00106 problem
ORA-19550 cannot use backup / restore functions while using dispatcher
Cause: An attempt was made to use backup / restore functions while connected to the dispatcher in a shared server. This is not allowed because the device that is used for backup and restore must remain allocated to a single process.
Action: Connect directly to the instance then re-execute the backup or restore function.
Experiment Environment: win2000 advanced server, oracle920
RMAN experiment description:
1. Has established two databases practice and rcat, respectively, as the target database and RMAN catalog database. Building a database when both are based on the shared server mode. Built and after the database is to start two instances, respectively.
2. Rcat to establish a cattbs table space and rman920 users, and grant the user permission to connect and recovery_catalog_owner.
3. Create Recovery Catalog Manager. RMAN> connect target sys / sys @ practice; RMAN> connect catalog rman920/rman @ rcat; RMAN> create catalog tablespace cattbs; (The following operation is normal)
4. Registration database. RMAN> register database; this time the error occurred, and in the final RMAN prompt ORA-19550 error.
Solution:
Check the registry entries at this time the value of ORACLE_SID is rcat. It into practice.
Then run the rman target sys / sys; RMAN> connect catalog rman rman920/rman @ rcat; RMAN> register database; to normal.
Summary:
1. This problem occurs in the same machine on the construction of two libraries and start two instances of the case. In the windows this problem would occur, it may also have similar problems under unix (on-line to see people ask the same question, the environment is unix) .
2. The way to solve the problem ora-00106 (unable to connect to the scheduler when the startup / shutdown database) is similar. Both are likely to start two instances at the same time when there (not confirmed).
3. Whether from the server-side or from the client connection has this problem.
Question:
Canada without the network connection name in the end What's the difference? (The local registry of the circumstances)
Note:
Off from the directory of a database approach:
1. To delete the database all the backup sets.
2. RMAN> list incarnation; be db_key and db_id.
3. Sqlplus execute execute dbms_rcvcat.unregisterdatabase (db_key, db_id);
Related Posts of ORA-19550 problem and ORA-00106 problem
-
ORACLE10G full version centos5 installed (the installation has passed)
ORACLE10G full version centos5 installed (the installation has passed) 1. Centos 5.0 install rn GUI must be installed, it is best not to start selinux rn rn rn 2. . Ready to install the software: (this is very important, is the first installation fai ...
-
SGA extended the principle of 32bit oracle
SGA extended the principle of 32bit oracle From: http://www.itpub.net/247048.html Because the median 32bitrnoracle restrictions can only visit the oracle process 4g (2 of 32 power) following virtual memory address, the time at a lot of people this is ...
-
Dbms_obfuscation_toolkit use of Oracle's encryption and decryption of data (to)
In order to protect sensitive data, oracle start from 8i to provide a data encryption package: dbms_obfuscation_toolkit. Take advantage of this package, our data can be DES, Triple DES or MD5 encryption. This article on the use of this and the use of ...
-
Oracle XDB relax resolve port conflict of 8080
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 u ...
-
Oracle in the relationship between User and Schema
If we want to know the database and the User What is the relationship between Schema, we must first know about User and Schema database What is the concept in the end. In SQL Server2000 in architecture because of the reason, User and Schema there is ...
-
High Availability Oracle Flashback
Brief introduction Flashback Database is a point in time (PIT) restore the database approach. This incomplete recovery strategy can be used to restore the logic because of human error cause damage to the database. At the introduction of 10g, it is de ...
-
An example of the use of TKPROF
First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE
-
Diagnosis and principles of order
SQL> select disk.value "Disk", mem.value "Mem", 2 (disk.value / mem.value) * 100 "Ratio" 3 from v $ sysstat mem, v $ sysstat disk 4 where mem.name = 'sorts (memory)' 5 and disk.name = 'sorts (disk)'; D ...
-
ORACLE 10G dataguard configuration Step by Step
oracle dataguard
Leave a Reply