Error Rman-04006: Error From Auxiliary Database: ORA-12514: TN

[edmilson]

Environment information: PROD
* Oracle version: 11.2.0.
* Operating system: Solaris

Good morning I am in project with deadlines very cost and I am trying to clone two base with 'duplicate target database to hhispn1 from active database; "
And I have a problem with Listener.
My listener is configured thus

Select all

LISTENER = 
  (ADDRESS_LIST = 
        (ADDRESS= (PROTOCOL= TCP)(Host=5.17.8.208)(Port= 1521)(QUEUESIZE=60))) 
 
LISTENER2= 
  (ADDRESS_LIST = 
        (ADDRESS= (PROTOCOL= TCP)(Host=5.17.8.208)(Port=1523)(QUEUESIZE=60))) 
 
 
SID_LIST_LISTENER= 
    (SID_LIST = 
      (SID_DESC = 
         (SID_NAME = HHISPN1) 
         (ORACLE_HOME = /u01/app/oracle11/product/11.2.0.2) 
      ) 
   )

My TNSName:

Select all

hhispn1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=5.17.8.208)(PORT=1523)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=hhispn1)(UR=A))) 

] When I try to write normally both internally and extent.

Select all

 tnsping HHISPN1 
 
TNS Ping Utility for Solaris: Version 11.2.0.2.0 - Production on 27-JUL-2011 11:52:11 
 
Copyright (c) 1997, 2010, Oracle.  All rights reserved. 
 
Used parameter files: 
 
 
Used TNSNAMES adapter to resolve the alias 
Attempting to contact (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=5.17.8.208)(PORT=1523)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=hhispn1)(UR=A))) 
OK (10 msec) 
You have new mail in /var/mail//oracle11

externally:

Select all

 tnsping HHISPN1 
 
TNS Ping Utility for Solaris: Version 11.2.0.2.0 - Production on 27-JUL-2011 11:52:11 
 
Copyright (c) 1997, 2010, Oracle.  All rights reserved. 
 
Used parameter files: 
 
 
Used TNSNAMES adapter to resolve the alias 
Attempting to contact (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=5.17.8.208)(PORT=1523)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=hhispn1)(UR=A))) 
OK (10 msec) 
You have new mail in /var/mail//oracle11

When I will try to connect to RMAN this error appears:

Select all

 rman target sys/manager@isp999 auxiliary sys/manager@hhispn1 
 
 
Recovery Manager: Release 11.2.0.2.0 - Production on Wed Jul 27 11:53:58 2011 
 
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. 
 
connected to target database: ISP999 (DBID=2210902308) 
RMAN-00571: =========================================================== 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== 
RMAN-00571: =========================================================== 
RMAN-00554: initialization of internal recovery manager package failed 
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 
You have new mail in /var/mail//oracle11

[elidias7]

Good Morning.

The bases will be on the same server? Instead of placing user@auxiliary_database export the SID and connect with /

Hugs,

[diegopedrao]

ELIDIAS,


Connecta with Target and after a startup. Probably the server is not started.

ATT,

Diego Monteiro