13 Replies Latest reply: Apr 18, 2013 1:41 AM by User478743-OC RSS

    RMAN-04006: error from auxiliary database while creating standby Database

    User478743-OC
      Hi ,

      On windows 7,Oracle 11gr2 ,I am creating standby db(teststand) from active db(test) on same machine for testing purpose .

      When i try to run for duplicating active DB

      rman target / nocatalog auxiliary sys/oracle@teststand

      It give following error .

      **RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor**

      I have tried (SERVICE_NAME = teststand)(UR = A) in tnsnames.ora as well as in Global_database_name parameter in listener.ora .

      Following is status of listener status.

      C:\Users\kamdarvg>lsnrctl

      LSNRCTL for 32-bit Windows: Version 11.2.0.3.0 - Production on 16-APR-2013 1
      :55

      Copyright (c) 1991, 2011, Oracle. All rights reserved.

      Welcome to LSNRCTL, type "help" for information.

      LSNRCTL> status
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IN40000363)(PORT=1521)

      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for 32-bit Windows: Version 11.2.0.3.0 - P
      ction
      Start Date 16-APR-2013 15:45:44
      Uptime 0 days 0 hr. 11 min. 13 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Log File D:\app\kamdarvg\diag\tnslsnr\IN40000363-0\listenerrt\log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=IN40000363-0.nhg.local)(PORT=1521)

      Services Summary...
      Service "test" has 1 instance(s).
      Instance "teststand", status BLOCKED, has 1 handler(s) for this service...
      Service "test" has 1 instance(s).
      Instance "test", status READY, has 1 handler(s) for this service...
      Service "testXDB" has 1 instance(s).
      Instance "test", status READY, has 1 handler(s) for this service...


      Please suggest how to resolve above error.

      Thanks.