Abstract ORA-00955 WHILE CREATING THE 2ND CATALOG TABLESPACE USING THE 2ND USER | ||||||||||||||||||||||||||
Resolution History 04-APR-07 04:29:00 GMT This SR was saved as a Draft SR on: 03-APR-2007 21:24:14 ~!CRITICAL_PRODUCTION!~ ### Release info of target DB, catalog DB, catalog schema & RMAN executable: ### AIX 5.3 ML5,oracle 10.2.0.3 ### Specific details about the problem you encountered during RMAN session: ### [GXNX_APPB:/oracle]>rman catalog frman/frman Recovery Manager: Release 10.2.0.3.0 - Production on Wed Apr 4 11:51:18 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to recovery catalog database RMAN> create catalog tablespace 'RMAN02'; recovery catalog created RMAN> RMAN> quit Recovery Manager complete. [GXNX_APPB:/oracle]>rman catalog rman/rman Recovery Manager: Release 10.2.0.3.0 - Production on Wed Apr 4 11:51:52 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to recovery catalog database RMAN> create catalog tablespace 'RMAN01'; ORACLE error from recovery catalog database: ORA-00955: name is already used by an existing object RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-06433: error installing recovery catalog ### Target database alert.log: ### ### Third party Media Manager API: ### ### Can we use Oracle Collaborative Suite (OCS) to diagnose this issue? ### Can you easily recover from, bypass or work around the problem? No Does your system or application continue normally after the problem occurs? No Are the standard features of the system or application still available; is the loss of service minor? Yes Error : ORA-00955 Contact me via : MetaLink 04-APR-07 09:03:38 GMT UPDATE ======= Hi gan, Please do the below actions step by step . ACTION PLAN ============ 1. connect to catalog DB using SYSDBA 2.Execute SQL command: alter system set events '955 trace name errorstack level 3' 3.reproduce the error (you can re-execute the command 'create catalog tablespace 'RMAN01' ) 4.checking the user_dump_dest to find the corresponding trace file containing the ORA-00955 5. upload the trace file to SR. Thanks Sam Oracle Product Support 04-APR-07 09:03:49 GMT Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn. 04-APR-07 11:04:03 GMT The customer : quan_gan@vandagroup.com.cn : has uploaded the following file via MetaLink: H:gxrman_ora_950628.rar 04-APR-07 13:59:45 GMT . DATA COLLECTED =============== TRACE FILE ------------ gxrman_ora_950628.trc . ISSUE CLARIFICATION ==================== Gets "ORA-00955: name is already used by an existing object" when create catalog using RMAN . ISSUE VERIFICATION =================== Verified by the gxrman_ora_950628.trc Regards Sam Oracle Product Support 04-APR-07 14:06:55 GMT UPDATE ====== Hi gan, It seems that table BS had already been created in the RMAN schema. please do the following actions . ACTION PLAN ============ 1. sqlplus rman/rman 2. execute " select table_name from user_tables;" and update the result to SR. 3. have you ever created a catalog by user rman? Regards Sam Oracle Product Support. 04-APR-07 14:07:10 GMT Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn. 04-APR-07 14:27:10 GMT New info : quan_gan@vandagroup.com.cn At first,the catalog database is new database. I have create the two tablespaces of RMAN01 AND RMAN02, and to create the two users of rman and frman. then, do the following: rman catalog frman/frman Recovery Manager: Release 10.2.0.3.0 - Production on Wed Apr 4 11:51:18 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to recovery catalog database RMAN> create catalog tablespace 'RMAN02'; recovery catalog created RMAN> quit then, do the following: [GXNX_APPB:/oracle]>rman catalog rman/rman Recovery Manager: Release 10.2.0.3.0 - Production on Wed Apr 4 11:51:52 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to recovery catalog database RMAN> create catalog tablespace 'RMAN01'; ORACLE error from recovery catalog database: ORA-00955: name is already used by an existing object RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-06433: error installing recovery catalog so ,I can't have create the catalog info of rman!! Tomorrow ,I will send the information of dba_tables to you! 05-APR-07 01:19:04 GMT New info : quan_gan@vandagroup.com.cn My product system is the following now: the first,create the user rman and catalog RMAN01 tablespace, and complete it . the second , create the user frman and complete it ,but failed to create catalog RMAN02 tablespace. 05-APR-07 01:20:02 GMT The customer : quan_gan@vandagroup.com.cn : has uploaded the following file via MetaLink: H:dba_tables.rar 05-APR-07 02:08:29 GMT UPDATE ======= Call back to miss gan and she confirms that existing some table in frman in which the 955 occurs. I tell her to delete the tables first before cr eate the catalog. she agrees and will upload the result to sr. Regards Sam Oracle Product Support. 05-APR-07 02:16:10 GMT The customer : quan_gan@vandagroup.com.cn : has uploaded the following file via MetaLink: F:405.rar 05-APR-07 02:41:19 GMT . DATA COLLECTED =============== SCREEN SHOTS -------------- errorinfo.txt TRACE FILE INCLUDING ERROR STACK ---------------------------------------------------------- gxrman_ora_971084.trc All tables contained in the RMAN -------------------------------------------- rman_tables.txt All tables contained in FRMAN ------------------------------------------ frman_tables.txt . ISSUE CLARIFICATION ==================== Customer creates a new user RMAN then creates catalog by RMAN successfully. But when customer creates another new user FRMAN and encounters ORA-00955 during creating catalog in FRMAN. ERROR SQL IN TRACE -------------------------------- ksedmp: internal or fatal error ORA-00955: name is already used by an existing object Current SQL statement for this session: CREATE TABLE bs ( bs_key NUMBER NOT NULL, -- sequence generated primary key db_key NUMBER NOT NULL, -- database bs_recid NUMBER, -- backup set recid from control file bs_stamp NUMBER, -- backup set stamp from control file set_stamp NUMBER NOT NULL, -- set_stamp from control file set_count NUMBER NOT NULL, -- set_count from control file bck_type VARCHAR2(1), -- 'D' -> full datafile -- 'I' -> incremental datafile -- 'L' -> archivelog incr_level NUMBER, -- incremental backup level (0 - 4) -- null if this a FULL backupset or -- INCREMENTAL FROM SCN backup pieces NUMBER NOT NULL, -- number of backup pieces in the set start_time DATE, -- time when this backup started completion_time DATE, -- time when this backup completed status VARCHAR2(1), -- 'A' -> complete set of pieces avail -- 'D' -> no pieces or all deleted -- 'O' -> neither of above controlfile_included -- Indicates if this backup set has VARCHAR2(7), -- a controlfile in it -- 'NONE' -> it does not -- 'BACKUP' -> it includes a backup cf -- 'STANDBY' -> it includes a -- standby controlfile input_file_scan_only VARCHAR2(3), -- 'NO' -> this is a real backup -- 'YES' -> this was 'backup validate' keep_options NUMBER DEFAULT 0 NOT NULL,-- if backup is done with keep option -- then keep_options can be: -- KEEP_LOGS -- KEEP_NOLOGS -- KEEP_CONSIST keep_until DATE, -- valid only if keep_options != 0 -- NULL means forever block_size NUMBER DEFAULT NULL, -- block size for backup set -- Will be NULL when < 10gR2 rman exec -- creates. CONSTRAINT bs_p PRIMARY KEY (bs_key), CONSTRAINT bs_u2 UNIQUE (db_key, set_stamp, set_count), CONSTRAINT bs_f1 FOREIGN KEY(db_key) -- backup set belongs to a db REFERENCES db ON DELETE CASCADE, CONSTRAINT bs_c_bck_type CHECK (bck_type in ('D','I','L')), CONSTRAINT bs_c_incr_level CHECK (incr_level in (0,1,2,3,4)), -- note: incr_level can be null. CHECK constraints allow this. CONSTRAINT bs_c_controlfile_included CHECK (controlfile_included in ('NONE','BACKUP','STANDBY')) ) tablespace "RMAN02" . ISSUE VERIFICATION =================== Verfied by the screen shot and trace file Regards Sam Oracle Product Support. 05-APR-07 05:11:30 GMT . UPDATE ======= Hi , I have created a similar test in my database and here is the output. KIndly do the steps as per mine and send us the output . SQL> create tablespace rman ; Tablespace created. SQL> create tablespace rman1 ; Tablespace created. SQL> create user rman identified by rman 2 default tablespace rman; User created. SQL> alter user rman quota unlimited on rman; User altered. SQL> create user rman1 identified by rman1 2 default tablespace rman1; User created. SQL> alter user rman1 quota unlimited on rman1; User altered. SQL> grant recovery_catalog_owner to rman; Grant succeeded. SQL> grant recovery_catalog_owner to rman1; Grant succeeded. SQL> C:>rman catalog rman/rman Recovery Manager: Release 10.2.0.1.0 - Production on Thu Apr 5 10:15:27 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to recovery catalog database RMAN> create catalog; recovery catalog created RMAN> exit C:>rman catalog rman1/rman1 Recovery Manager: Release 10.2.0.1.0 - Production on Thu Apr 5 10:16:34 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to recovery catalog database RMAN> create catalog; recovery catalog created RMAN>exit eos(End of section) 05-APR-07 05:11:36 GMT Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn. 05-APR-07 06:45:09 GMT New info : quan_gan@vandagroup.com.cn when oracle version is 10.2.0.2, we can create the two user catalog , but we upgrade the oracle version to 10.2.0.3,we can't create the two user catalog. 05-APR-07 07:22:02 GMT The customer : quan_gan@vandagroup.com.cn : has uploaded the following file via MetaLink: H:40501.rar 05-APR-07 08:44:05 GMT . UPDATE ======= Hi, I have dont the test 10.2.0.3 database and its working fine for me . Kindly follow the steps below SQL> create tablespace rman ; Tablespace created. SQL> create tablespace rman1 ; Tablespace created. SQL> create user rman identified by rman 2 default tablespace rman; User created. SQL> alter user rman quota unlimited on rman; User altered. SQL> create user rman1 identified by rman1 2 default tablespace rman1; User created. SQL> alter user rman1 quota unlimited on rman1; User altered. SQL> grant recovery_catalog_owner to rman; Grant succeeded. SQL> grant recovery_catalog_owner to rman1; Grant succeeded. SQL> C:>rman catalog rman/rman Recovery Manager: Release 10.2.0.3.0 - Production on Thu Apr 5 14:13:04 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to recovery catalog database RMAN> create catalog; recovery catalog created RMAN> exit Recovery Manager complete. C:>rman catalog rman1/rman1 Recovery Manager: Release 10.2.0.3.0 - Production on Thu Apr 5 14:13:34 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to recovery catalog database RMAN> create catalog; recovery catalog created RMAN> eos(End of section) 05-APR-07 08:44:11 GMT Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn. 05-APR-07 08:51:03 GMT New info : quan_gan@vandagroup.com.cn AIX 5L ML5 ,oracle 10.2.0.3 I have sent all the results to you. but I get the failed result, pls you explain which step is not right? 05-APR-07 08:54:05 GMT New info : quan_gan@vandagroup.com.cn How can you test the problem on windows???? My Product system is AIX 5.3 ML5 ,It will very different between aix and windows? 05-APR-07 09:04:13 GMT . UPDATE ======= Hi , As per the creation of user and the catalog there is no differnece. CAn you please do it as per my steps and let us know the status. Do not give the tablespace name just create to different user and create the catalog . C:>rman catalog rman/rman Recovery Manager: Release 10.2.0.3.0 - Production on Thu Apr 5 14:13:04 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to recovery catalog database RMAN> create catalog; recovery catalog created RMAN> exit Recovery Manager complete. C:>rman catalog rman1/rman1 Recovery Manager: Release 10.2.0.3.0 - Production on Thu Apr 5 14:13:34 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to recovery catalog database RMAN> create catalog; recovery catalog created RMAN> 05-APR-07 09:04:19 GMT Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn. 05-APR-07 09:10:11 GMT New info : quan_gan@vandagroup.com.cn I have send the steps and results to you!!!! Pls you test your step in AIX 5.3 ML3 and oracle 10.2.0.3 !!! 05-APR-07 09:44:38 GMT . UPDATE ======= HI, Can you please try without the tablespace name and let u sknow the status. I mean connect to the respective user and RMAN> create catalog; eos(End of section) 05-APR-07 09:44:53 GMT Email Update button has been pressed: Sending email to quan_gan@vandagroup.com.cn. 05-APR-07 14:21:07 GMT The customer : quan_gan@vandagroup.com.cn : has uploaded the following file via MetaLink: F:rman0405new.txt 06-APR-07 07:05:07 GMT New info : quan_gan@vandagroup.com.cn Hi , I want to know how do you handle with the problem? My customer is waiting for the function on the product system! Best regards, ganquan 06-APR-07 15:06:56 GMT ***CTC Review*** ================= The owning engineer is currently off-shift. I will set the status of this issue to CTS (Customer To be Served) for your a nalyst`s attention upon your analyst`s return to work. If you require immediate assistance regarding this issue outside of the assigned engineer's business ho urs, please call us in order to reach a dispatcher in one of our global support centers. You must telephone support to get the issue reassigned. Simply updatin g this service request will not accomplish getting the issue reassigned. Please note that if you do call to get this SR transferred to a working analyst, in o rder to get this SR worked by analyst who has the same work hours you have, plea se phone Oracle Support Services during your work hours. Please call anytime if you are not concerned about when this SR is worked. If you do not know your Oracle Support phone number, refer to the following URL to find the number: http://www.oracle.com/support/contact.html Thank you ... Cliff S. Cluster Technical Coordinator Backup and Recovery STATUS ======== CTS (Customer To be Served) |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/67233/viewspace-909363/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/67233/viewspace-909363/