Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Connect / as sysdba = insufficient privileges

Connect / as sysdba = insufficient privileges

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 26 Feb 2005 13:24:20 -0800
Message-ID: <1109453060.818448.137070@l41g2000cwc.googlegroups.com>


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 Received on Sat Feb 26 2005 - 15:24:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US