Ok...what am I missing here....? (Password file and remote login as sysdba)

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Thu, 5 Nov 2009 13:51:57 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F25436BC9_at_AAPQMAILBX02V.proque.st>

Ok, I'm about ready to start bouncing off the walls here.

I have a database, Oracle 11.2.0.1.0 running on RHEL 5.2. If the instance is up, remote login as sysdba works fine. If the instance is down, I get ORA-01031.

Database name: mstartst

Password file exists:

[oracle_at_msdb302 dbs]$ ls -l $ORACLE_HOME/dbs/orapwmstartst
-rw-r----- 1 oracle dba 2048 Nov 5 13:42 /oracle/product/11.2.0/db/dbs/orapwmstartst

If database is up, remote login as sysdba works fine:

[oracle_at_msdb302 dbs]$ ps -ef|grep pmon|grep mstartst
oracle 10880 1 0 13:43 ? 00:00:00 ora_pmon_mstartst
[oracle_at_msdb302 dbs]$ sqlplus sys_at_mstartst as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 5 13:44:44 2009

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

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options

SQL> show parameter password

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE

but, if the instance is down, remote sysdba authentication fails..... SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options
[oracle_at_msdb302 dbs]$ sqlplus sys_at_mstartst as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 5 13:45:56 2009

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

Enter password:
ERROR:
ORA-01031: insufficient privileges

But, I can still connect as '/ as sysdba' and restart the instance, and when I do, remote sysdba authentication starts working again.... Enter user-name: / as sysdba
Connected to an idle instance.

SQL> startup
exiORACLE instance started.

Total System Global Area 217157632 bytes

Fixed Size                  2211928 bytes
Variable Size             159387560 bytes
Database Buffers           50331648 bytes
Redo Buffers                5226496 bytes

t
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options
[oracle_at_msdb302 dbs]$
[oracle_at_msdb302 dbs]$
[oracle_at_msdb302 dbs]$ sqlplus sys_at_mstartst as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 5 13:47:17 2009

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

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options

Help!! I know I've got to be overlooking something simple here.....

Why would remote sysdba login work if the instance is already up, but fail if it's down??

AdvThanksance,

-Mark

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 05 2009 - 12:51:57 CST