Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Connect / as sysdba = insufficient privileges
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 = worldid> uid=1100(oracle) gid=200(dba)
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;
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