yan wang wrote:
> I tried sqlplus "/ as sydba"
> get an invalid option error.
>
> I reset the password to 'oracle'.
> which user have I reset it?
>
> Dennis Bieling <dennis.bieling_at_epigenomics.com> wrote in message news:<bpco9p$q13$1_at_broglie.epigenomics.epi>...
>
>>>How Can I log back in ?
>>>
>>
>>Hi!
>>
>>sqlplus "/ as sydba"
>>
>>will give you a log in as sys. Make sure the environment is set
>>correctly before issuing the command.
>>Then do an
>>
>>alter user xxxx identified by yyyy;
>>
>>To set the correct password (yyyy) for the user (xxxx).
>>
>>
>>Best regards
>>Dennis
probably the sys user, try sqlplus "sys/<your new password> as sysdba"
Has the same rights as "/ as sysdba" - is actually the same oracle user.
You do mean you changed the password with oradim - right?
--
Regards, Frank van Bortel
Received on Tue Nov 18 2003 - 15:57:42 CST
