Re: Connect / as sysdba = insufficient privileges

On 26 Feb 2005 13:24:20 -0800, "G Quesnel" <dbaguy_ott_at_yahoo.com> wrote:

>I have ...
>Oracle 10.1.0.2.0 on Solaris 64bits
>sqlnet.ora > SQLNET.AUTHENTICATION_SERVICES= (NTS)
>sqlnet.ora > NAMES.DIRECTORY_PATH= (TNSNAMES)
>sqlnet.ora > NAMES.DEFAULT_DOMAIN = world
>id> uid=1100(oracle) gid=200(dba)
>init...ora > remote_login_passwordfile = exclusive
>
>orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=abcdef1
>
>I can connect with sqlplus /nolog ...
>connect sys/abcdef1 as sysdba
>But the following wont work
>SQL> connect / as sysdba
>ERROR:
>ORA-01031: insufficient privileges
>
>I've even rebuilt the password file by
>1.Shutdown immediate
>2.issue the orapwd to build a new password file
>3.startup the database (after connecting sys/abcdef1 as sysdba)
>4.issue alter user sys identified by abcdef1;
>5.issue grant sysdba to sys;
>and the connect / as sysdba still generates the ORA-1031
>
>How can I fix this problem ?
>(or determine that I must re-install the Oracle software)
>
>TIA
>
>Note: This is the information in $ORACLE_HOME/root.sh ...
>ORACLE_USER=oracle
>DBA_GROUP=dba
>CHGRP=/bin/chgrp
>ORACLE_HOME=/u01/app/oracle/product/10g

Likely causes:
- the protection of the various directories and files is incorrect - you haven't set the setuid bit on the Oracle executable

Bizarre causes
The uid and the gid of all files is not pointing to the correct oracle unix user, as you are using NIS and there is a mismatch between the uid and gid in NIS and in the /etc/passwd file.

--
Sybrand Bakker, Senior Oracle DBA