Hi all,
I was wondering if it's possible to connect to a remote database that is shut down (idle instance) as sys user with sysdba privileges? In the book Oracle - All in One on page 210 in the section - Operating System and Password File Authentication it says:
Connection with operating system or password file authentication is always possible, no matter what state the instance and database are in, and is necessary to issue STARTUP or SHUTDOWN commands.
Above indicates that it's possible but I'm unable to do so.
I managed to connect to remote database that was in nomount mode (see below for details).
When I first tried to connect to a remote database (idle instance) using password file authentication it was giving following error:
sqlplus sys@ORCL as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 21 13:59:28 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
After starting the database to nomount mode I was getting following error:
sqlplus sys@ORCL as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 21 13:48:36 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Enter user-name:
So I added the clause (UR=A) to my listener.ora file and after that it work and I was able to connect:
sqlplus sys@ORCL as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 21 14:04:49 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
I have all necessairly entries in tnsnames.ora on my local host.
Also I have no problems when connecting as sys user with sysdba when the DB is open but can't get it work on an idle instance.
I know that I can use operating system authentication but want to know if there is a mistake in the book or I'm doing something wrong.
Regards,
Dawid
Edited by: 978239 on 2012-12-21 06:24