| Listener error [message #271099] |
Sat, 29 September 2007 06:04  |
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  |
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 #271238 is a reply to message #271099] |
Mon, 01 October 2007 00:10 |
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 #271325 is a reply to message #271099] |
Mon, 01 October 2007 05:23 |
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]$
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
