* 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)
)
)
hhispn1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=5.17.8.208)(PORT=1523)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=hhispn1)(UR=A)))
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
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