erro RMAN-04006: error from auxiliary database: ORA-12514:TN

Backup, Recover, Import, Export, Datapump, etc
  

Mensagemem Qua, 27 Jul 2011 11:58 am

Informações do Ambiente: Prod
* Versão do Oracle:11.2.0.
* Sistema Operacional:Solaris

Bom dia estou em projeto com prazos muito custo e estou tentando clonar duas base com 'duplicate target database to HHISPN1 from active database;"
e estou com problema com listener .
meu listener esta configurado assim
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)
)
)

meu tnsname:

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

quando tento pingar responde normalmente tanto internamente quanto exteranamente.


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

externamente:
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


Quando vou tentar conectar no rman aparece este erro :

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
edmilson
Localização: sp

Mensagemem Qui, 28 Jul 2011 11:18 am

Bom dia.

As bases ficarão no mesmo servidor? Ao invés de colocor user@auxiliary_database exporte o sid e conecte com /

Abraços,
elidias7
Localização: Osasco

Eli Dias
Oracle Certified Professional

Mensagemem Sex, 29 Jul 2011 11:44 am

elidias,


Connecta com target e depois da um startup. Provavelmente o servidor não está iniciado.

Att,

Diego Monteiro
diegopedrao
Localização: SP



Voltar para DBA Backup / Recover

Quem está online

Usuários navegando neste fórum: Nenhum usuário registrado e 3 visitantes