Haximus wrote:
> "Thomas Kyte" <tkyte_at_oracle.com> wrote in message
> news:119453490.0000d577.094_at_drn.newsguy.com...
>
>>In article <1109453060.818448.137070_at_l41g2000cwc.googlegroups.com>, G
>>Quesnel
>>says...
>>
>>>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
>>>
>>
>>
>>In order to use the OS authentication:
>>
>>connect / as sysdba
>>
>>you must belong to the correct OS group, looks like the default dba is in
>>place
>>here.
>>
>>So, are you in the DBA group?
>
>
> He rebuilt the password file... if I'm correct this means the INTERNAL
> account. If the password file is not successfully reset he's SOL! Try
> re-create the password file with the utlity is the best bet, or copy a
> working one...
Better go back to being an OO expert. Your comment is irrelevant to
the problem at hand. "/ AS SYSDBA" does not use the password file.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sun Feb 27 2005 - 11:46:12 CST
