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

Mark,

Can you post your listener.ora?
I'm suspecting that you either have no static configuration for your database 
in the listener or the name in the static configuration is not the 
instance_name.

regards,

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer


From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf 
Of Bobak, Mark [Mark.Bobak@xxxxxxxxxxxx]
Sent: 05 November 2009 19:51
To: oracle-l@xxxxxxxxxxxxx
Subject: Ok...what am I missing here....? (Password file and remote login as 
sysdba)


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@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@msdb302 dbs]$ ps -ef|grep pmon|grep mstartst
oracle   10880     1  0 13:43 ?        00:00:00 ora_pmon_mstartst
[oracle@msdb302 dbs]$ sqlplus sys@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@msdb302 dbs]$ sqlplus sys@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@msdb302 dbs]$
[oracle@msdb302 dbs]$
[oracle@msdb302 dbs]$ sqlplus sys@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

Other related posts: