Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connect / as sysdba = insufficient privileges
In article <1109466467.879849.188260_at_o13g2000cwo.googlegroups.com>,
fitzjarrell_at_cox.net says...
>
>
>G Quesnel 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
>
>If this is truly 64-bit Solaris WHY on earth are you using NTS
>authentication? Such authentication service is reserved for the
>Windows operating system, certainly NOT Solaris.
>
>I'd change that immediately and reap the benefits.
>
>
>David Fitzjarrell
>
good eye, that would do it.....
-- Thomas Kyte Oracle Public Sector http://asktom.oracle.com/ opinions are my own and may not reflect those of Oracle CorporationReceived on Sun Feb 27 2005 - 08:43:22 CST