Re: Lost oracle passwords on 9i database on windows xp

hpuxrac wrote:
> sqlplus /nolog
> connect / as sysdba
> alter user xxx identified by yyyy
>
> Do this as an admin

This works only if %ORACLE_HOME%\network\admin sqlnet.ora contains:

SQLNET.AUTHENTICATION_SERVICES=(NTS) This allows Oracle to permit "connect / as sysdba" on Windows. Simply being a member of the ORA_DBA group on Windows does not guarantee "passwordless" access to the Oracle database, something the 'dba' group on Linux/UNIX provides.

Another option you haven't mentioned is using orapwd to generate a new "sys as sysdba" password for the database (I'm presuming if passwords are lost, this is one of them:

C:|> orapwd file=%ORACLE_HOME%\dbs\orapd<sid> password=<your new password here> entries=15

This presumes the old orapw<sid> file, if it existed, has been deleted or renamed. Now it's a simple matter of:

sqlplus "sys/<your new password> as sysdba"

You now have access, as SYS, to change any other passwords:

alter user xxxxxx identified by yyyyyyy; Hopefully this better answers the OP's question.

David Fitzjarrell Received on Tue Jan 04 2005 - 08:37:14 CST