6 Replies Latest reply: May 9, 2013 6:21 PM by hm360 RSS

    RMAN not connecting to catalog database

    malikdba
      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
          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
            Hello,

            Can you please post error you are getting?

            Thanks,
            Chirag
            • 3. Re: RMAN not connecting to catalog database
              EdStevens
              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
                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
                  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
                    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.