Re: sqlplus /as sysdba on Oracle 9.2.0.1.0/RedHat 8

Frank wrote:

> Hi!
>
> 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

[Quoted] What privs does the UNIX user account have from which you are running this script? Is it the Oracle account or a member of the dba group?

Daniel Morgan Received on Thu Mar 27 2003 - 15:34:11 CET