Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12526: TNS:listener: all appropriate instances are in restricted mode

784227Jul 29 2012 — edited Jul 31 2012
db 10.2.0.4

I am trying to create duplicate database using rman.

There are two seprate server A and B where oracle 10g database is installed.I want to create duplicate database on B of A database.

I tried to create duplicate database on B got below error.

On B:

C:\>rman target sys/oracle@orcl auxiliary sys/oracle@orcldup

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jul 30 03:13:01 2012

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

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12526: TNS:listener: all appropriate instances are in restricted mode

C:\>

On A listener status:

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.4.0 - Produ
ction
Start Date 24-JUL-2012 01:08:39
Uptime 5 days 0 hr. 38 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File D:\oracle\product\10.2.0\db_1\network\log\listener.log

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=D-IT-SAJIDQ.alhokair.com)(PORT=1521)
))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status RESTRICTED, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status RESTRICTED, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status RESTRICTED, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>

--I have already added UR=A with listener ora file but the error is not resolved.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2012
Added on Jul 29 2012
7 comments
10,244 views