Home » RDBMS Server » Backup & Recovery » Listener error
Listener error [message #271099] Sat, 29 September 2007 06:04 Go to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
when am creating duplicate database,am facing this listener error
when i try to connect rman to both my target database and my duplicate database,

[oracle@infra ~]$ rman target sys/hcl@newdb catalog rman/rman@dbsib auxiliary sys/hcl@AUX

Recovery Manager: Release 10.2.0.1.0 - Production on Sat Sep 29 20:08:19 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: NEWDB (DBID=2873463223)
connected to recovery catalog database
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-12528: TNS:listener: all appropriate instances are blocking new connections




this is listener file in auxillary instance


# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /new/oracle/product/db/database)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = infra.isc.hom)(PORT = 1521))
)
)

Re: Listener error [message #271102 is a reply to message #271099] Sat, 29 September 2007 07:47 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
i too encountered this problem some time back....just stop and start the listener again...if this doesnt help...u should also try to shut down the aux instance and start it again.
Re: Listener error [message #271114 is a reply to message #271099] Sat, 29 September 2007 10:00 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Make an entry in the listener file for the AUX database.
Re: Listener error [message #271238 is a reply to message #271099] Mon, 01 October 2007 00:10 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
thanks ebrain but i had put an entry in listener file and am facing this error.

[oracle@infra ~]$ rman target sys/hcl@newdb catalog rman/rman@dbsib auxiliary sys/hcl@AUX

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Oct 1 14:25:15 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: NEWDB (DBID=2873463223)
connected to recovery catalog database
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-01031: insufficient privileges
[oracle@infra ~]$
Re: Listener error [message #271324 is a reply to message #271238] Mon, 01 October 2007 05:21 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Did you create a password file for the AUX instance?
Re: Listener error [message #271325 is a reply to message #271099] Mon, 01 October 2007 05:23 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
i had created the password file,see below

orapwdAUX is my password file.



[root@infra ~]# su - oracle
[oracle@infra ~]$
[oracle@infra ~]$
[oracle@infra ~]$ cd /new/oracle/product/db/database/dbs/
[oracle@infra dbs]$ ls
hc_AUX.dat initAUX.ora.29092007 init.ora orapwdAUX
hc_newdb.dat initAUX.ora.org init.ora.org spfileAUX.ora
initAUX.ora initdw.ora lkDUMMY
[oracle@infra dbs]$ cat orapwdAUX
]\[ZORACLE Remote Password fileNTERNAB7650EA01E05C178SYS07DEF2C5BFF39BB7[oracle@infra dbs]$
[oracle@infra dbs]$
Re: Listener error [message #271332 is a reply to message #271325] Mon, 01 October 2007 05:41 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I would suggest removing the AUX password file then setting the ORACLE_SID & ORACLE_HOME for the AUX database and then recreating the password file. Also ensure that you have set remote_login_passwordfile = exclusive.
Re: Listener error [message #271337 is a reply to message #271099] Mon, 01 October 2007 06:15 Go to previous message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
i had done what you hv said but still am facing the same error.
Previous Topic: any one explain rman levels
Next Topic: Datafile missing
Goto Forum:
  


Current Time: Tue Dec 06 16:33:09 CST 2016

Total time taken to generate the page: 0.09186 seconds