Hi !
Need help :
Can't connect with RMAN to the auxiliary database, which is in nomount
mode. Connecting like $ sqlplus "sys/****@AUXDB as sysdba".
There is some notes in ML (see below) , but it not helped :(
DB version is 9.2.0.6 and getting error :
RROR:
ORA-12523: TNS:listener could not find instance appropriate for the client
connection
But still can connect withount connect descriptor - like this wokr fine ,
from server console : $ sqlplus "sys/***** as sysdba" !
In manuals there is mentioned , that it should work fine with connect
descriptor also :
1. Modify both the listener.ora and tnsnames.ora file to be able
to connect to the auxiliary database. After making changes to
the networking files, test the connection keeping in mind that
you must be able to connect to the auxiliary instance with
SYSDBA privileges, so a valid password file must exist.
$ sqlplus "sys/change_on_install@TESTDB as sysdba"
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Nov 3 17:43:22
2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights
reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
SQL>
ML note :
Edit the tnsnames.ora
file alias that RMAN
references to connect to
the
auxiliary database.
Change the CONNECT_DATA
section so that it uses
the
SERVICE_NAME parameter
and NOT the SID
parameter.
e.g.
Standby.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = )
(PROTOCOL =
TCP)
(Host =
hostname)
(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME =
standby.world)
)
)
Explanation
-----------
This appears to happen
only when an instance is
in "startup no mount"
mode.
A check of lsnrctl
services in verbose mode
shows that the service
is "blocked".
Service "Standby.world"
has 1 instances.
Instance "Standby"
Status: BLOCKED
Total handlers: 1
Relevant handlers: 1
This may be expected
behavior for a database
that is in "startup no
mount" mode.
In any case, the dynamic
handler for this
instance is refusing
connections using the
CONNECT_DATA=(SID=XXX)
syntax in the address
descriptor. See
BUG1377901 for
more detailed
explanation of this
behavior.
BR ,
Andrejs
