Re: Forgot password for user "sys"
Date: Fri, 18 Feb 1994 23:09:27 GMT
Message-ID: <RWESSMAN.94Feb18150927_at_rwessman.us.oracle.com>
In article <1994Feb17.183016.1_at_corp02.d51.lilly.com> jl34778_at_corp02.d51.lilly.com writes:
> In article AA29019_at_cs.utexas.edu, sinues_at_prcd.prc.mrms.navy.mil (John Sinues) writes:
> -->What do you do if you lost/forgot the password for the Oracle user "sys"?
> -->I do not have the password for this user and am unable to perform any
> -->system administrative type functions. Is there a way around this? Is there
> -->a way to get the password back or reset it?
>
>Run SQL*DBA and CONNECT INTERNAL. This logs you in as SYS.
>
>To be able to connect internal, you need:
>
>On VMS:
> to have the ORA_DBA rights identifier
>On UNIX:
> to be a member of the 'dba' group
>
>$ SQLDBA
>SQLDBA> connect internal
In 7.0 on UNIX, you can become internal by giving the correct password
if the orapasswd file was created by the orapasswd command.
BTW, this mechanism has been (mostly) integrated into sqldba for 7.1.
Rick
Rick Wessman
Network Products Division
Oracle Corporation
rwessman_at_us.oracle.com
Received on Sat Feb 19 1994 - 00:09:27 CET