user5472855 wrote:In addition to the other responses addressing your immediate techincal question, I would point out that your use of a database named 'finance' as your rman catalog is a bit troubling. It suggests that you are having a database (finance) do dual duty, both as an operational business database AND as the home of the rman catalog. Not a good practice. The catalog should be in its own, dedicated, database.
Hi i am running oracle database 11.2.0 on windows xp at home pc
I have 2 databases ie. orcl and finance
I created a user and catalog on finance database and exited from RMAN
now each time when i want to connect to a specific database i have to set ORACLE_SID=orcl or finance
I want to register orcl as target database with recovery catalog which is on finance
What should i do?
I did try with following command and received the error
C:> rman target / catalog cat1@finance
it connect to orcl but not finance database while both are runnning. If i set oracle_sid=finance it connects to catalog database but not with orcl.
How can i connect to the both databases on the same machine to register my orcl database with recovery catalog on finance database???
malikdba wrote:see: [url http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/] ora-12154 TNS:could not resolve the connect identifier specified
Following s the error
C:>rman target / catalog cat1@finance
Recovery Manager: Release 18.104.22.168.0 - Production on Thu May 9 15:02:32 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database:: ORCL (DBID=1336397967)
recovery catalog database Password:
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not resolve the connect identifier specified