This discussion is archived
6 Replies Latest reply: May 9, 2013 4:21 PM by hm360 RSS

RMAN not connecting to catalog database

malikdba Newbie
Currently Being Moderated
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
command

C:> rman target / catalog cat1@finance
Passward: ********

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???
  • 1. Re: RMAN not connecting to catalog database
    sybrand_b Guru
    Currently Being Moderated
    As there is no error message in your request, no one can help.

    Run the command (or both comnmands) again, and now COPY the output and PASTE it here.

    --------
    Sybrand Bakker
    Senior Oracle DBA
  • 2. Re: RMAN not connecting to catalog database
    1006363 Newbie
    Currently Being Moderated
    Hello,

    Can you please post error you are getting?

    Thanks,
    Chirag
  • 3. Re: RMAN not connecting to catalog database
    EdStevens Guru
    Currently Being Moderated
    user5472855 wrote:
    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
    command

    C:> rman target / catalog cat1@finance
    Passward: ********

    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???
    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.

    If you are concerned about licensing for the additional database, not to worry. See the [url http://docs.oracle.com/cd/E11882_01/license.112/e10594.pdf]Licensing Guide, page 1-9, "Infrastructure Repository Databases".

    Edited by: EdStevens on May 9, 2013 8:52 AM
  • 4. Re: RMAN not connecting to catalog database
    malikdba Newbie
    Currently Being Moderated
    Hi all

    Following s the error

    C:>rman target / catalog cat1@finance

    Recovery Manager: Release 11.2.0.1.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-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    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
  • 5. Re: RMAN not connecting to catalog database
    EdStevens Guru
    Currently Being Moderated
    malikdba wrote:
    Hi all

    Following s the error

    C:>rman target / catalog cat1@finance

    Recovery Manager: Release 11.2.0.1.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-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    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
    see: [url http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/] ora-12154 TNS:could not resolve the connect identifier specified
  • 6. Re: RMAN not connecting to catalog database
    hm360 Newbie
    Currently Being Moderated
    Hi,

    Please teach the practice result of the following command.

    C:> tnsping finance

    If a practice result is TNS-03505, please add a postscript to information of 'finance' in tnsnames.ora.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points