Forgot your password?    
+ Reply to Thread
Results 1 to 4 of 4

Thread: Rman-04004@ora-01017

  1. #1

    Rman-04004@ora-01017

    Hello ,

    I am trying backup with recovery catalog database.I have already built a recovery catalog database name "CATALOG" to store the recovery catalog.I have already cofigure listener.ora and tnsnames.ora file and created user name 'rman' password 'rman' in recovery catalog database name "CATALOG".

    I got following error ..

    [b13prave@dbaquest ~]$ rman catalog rman/rman@catalog
    RMAN-00571: ================================================== ====
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
    RMAN-00554: initialization of internal recovery manager package failed
    RMAN-04004: error from recovery catalog database: ORA-12170: TNS:Connect timeout occurred

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    It is not able to connect to the catalog database. try this :

    1) see if you have given rman the create session privilege and make sure that the rman account is not lecked
    2) restart the listener for the recovery catalog
    3) tnsping catalog - see is this works
    4) then try to connect (also see if you can connect using sqlplus - using - rman/rman@catalog)

  3. #3
    Thanks Hemant ,
    when i followed step 2nd ,then following errors appeared

    LSNRCTL> start listener.ora
    Starting /u01/accounts/b13prave/myora/11g/bin/tnslsnr: please wait...
    TNSLSNR for Linux: Version 11.2.0.1.0 - Production
    System parameter file is /u01/accounts/b13prave/myora/11g/network/admin/listener.ora
    TNS-01151: Missing listener name, listener.ora, in LISTENER.ORA
    Listener failed to start. See the error message(s) above...

  4. #4
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    You are not starting the listener properly. Use : lsnrctl start <listener name>
    the <listener name> would come from the listener.ora

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics