1 2 Previous Next 15 Replies Latest reply: Feb 25, 2013 9:31 AM by EdStevens Go to original post RSS
      • 15. Re: unable to connect rman from target databse to catalog database
        EdStevens
        938946 wrote:
        I CREATED PASSWORD FILE IN TARGET DATABASE(TEST) AS SHOWN BELOW
        dbs]$orapwd file=orapwTEST password=system(password)

        is my password file correct ? i gave password of system,is this correct ? or do i have to give password of sys?

        and tnsping result and rman result while connecting

        ]$tnsping orman
        Used TNSNAMES adapter to resolve the alias
        Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.100)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=ORMAN) (INSTANCE_NAME=ORMAN)))
        OK (0 msec)
        ]$ rman target / catalog user_rman/user_rman@orman

        Recovery Manager: Release 10.2.0.3.0 - Production on Mon Feb 25 08:55:11 2013

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

        connected to target database: TEST (DBID=2104560695)
        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-12514: TNS:listener does not currently know of service requested in connect descriptor
        An ora-12514 means exactly the same thing when reported by rman as it does when reported by any other database client. see: [url http://edstevensdba.wordpress.com/2011/03/19/ora-12514/] ora-12514 
        1 2 Previous Next