sqlplus /as sysdba on Oracle 9.2.0.1.0/RedHat 8

[Quoted] I try to use the dbstart to start and stop the databases.

What I have trouble with is that this syntax in the dbstart script won't work:

sqlplus /nolog
connect /as sysdba

doesnt work because I get an ORA-1031: insufficient privileges.

I have placed:

remote_login_passwordfile = exclusive

in the $ORACLE_HOME/dbs/initMySid.ora
and in /etc/services/oratab I have:

MySid:path/path/oracle_home:Y

(which should not have anything to do with it I believe)

I have a orapwMySid.ora in $ORACLE_HOME/dbs

What I really feel is odd, is that I can start:

oemapp dbastudio

and shutdown/startup the database from there (with the same Unix user as when I attempt sqlplus)

As a sanity check I removed the orapw{SID}.ora in $ORACLE_HOME/dbs

and tried oemapp dbastudio again, and it gave me ORA-1031: insufficient privileges.

I placed the orapw{SID}.ora back there again and it works again :-)

Does anyone have a suggestion to why "sqlplus /as sysdba" doesnt work (and why oemapp dbastudio does)?

Help appreciated :-)
Frank Received on Thu Mar 27 2003 - 09:20:00 CET