2 Replies Latest reply: Nov 15, 2012 5:17 AM by User470870-OC RSS

    RMAN connect target and catalog db

    User470870-OC
      Hello Everyone,

      Database : 11.1.0.7
      Applications R12
      OS : RHEL 5

      We have 2 servers TEST and PROD on which catalog & prod database are running respetcively.
      Put TNS entries in tnsnames.ora of both the servers.
      Now i can able to connect catalog database from PROD server(target)
      as - rman target / catalog rman/rman@RMAN

      But got below errors when i tried to connect target db(PROD) from test server as
      [orarman@devtest ~]$ rman target /@OBAPROD catalog rman/rman@RMAN

      Recovery Manager: Release 11.1.0.7.0 - Production on Thu Nov 15 16:25:00 2012

      Copyright (c) 1982, 2007, Oracle. All rights reserved.

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00554: initialization of internal recovery manager package failed
      RMAN-04005: error from target database:
      ORA-01031: insufficient privileges
      [orarman@devtest ~]$

      Since created password file in the test server and granted sysdba privileges to user rman in catalod database and tried the below

      [orarman@devtest ~]$ rman target rman/rman@OBAPROD catalog rman/rman@RMAN

      Recovery Manager: Release 11.1.0.7.0 - Production on Thu Nov 15 16:33:04 2012

      Copyright (c) 1982, 2007, Oracle. All rights reserved.

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00554: initialization of internal recovery manager package failed
      RMAN-04005: error from target database:
      ORA-01031: insufficient privileges
      [orarman@devtest ~]$

      Have a doubt that, is it only sys user should perform rman backup..? and where password file must be created(whether it on test or prod server)
      and how to connect target db(PROD) running on other server from the server where catalog db is running

      Rgrds,
        • 1. Re: RMAN connect target and catalog db
          Shivananda Rao
          [orarman@devtest ~]$ rman target rman/rman@OBAPROD catalog rman/rman@RMAN
          Hello,

          When you are connecting to the TARGET database from the catalog database, you need to provide the username & password of sys user of TARGET database to perform backup operations. Ofcourse, you can connect with any other user existing in TARGET database but you'll not be permitted to perform backup operations.

          Try as below:
          rman target sys/<pwd-of-sys-user-of-target-db>@obaprod catalog rman/rman@rman
          Password file of TARGET database must be created on the TARGET (PROD) server.
          • 2. Re: RMAN connect target and catalog db
            User470870-OC
            Hi
            By default sys user password is change_on_install
            So i tried the below from test server

            [orarman@devtest ~]$ rman target sys/change_on_install@OBAPROD catalog rman/rman@RMAN

            Recovery Manager: Release 11.1.0.7.0 - Production on Thu Nov 15 17:12:30 2012

            Copyright (c) 1982, 2007, Oracle. All rights reserved.

            RMAN-00571: ===========================================================
            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
            RMAN-00571: ===========================================================
            RMAN-00554: initialization of internal recovery manager package failed
            RMAN-04005: error from target database:
            ORA-01031: insufficient privileges
            [orarman@devtest ~]$


            Rgrds,