Re: A newbie question concerning changing users in Oracle8

Sys and internal are the same account (when you connect internal, you are logging in as sys). Therefore if you changed the password for sys, this would also be the same password for internal.

i.e. if the SYS password were "BOAT"

CONNECT INTERNAL/BOAT and

CONNECT SYS/BOAT AS SYSDBA would do the same thing.

If you can still get into your system account, you can change SYS's password back to whatever you want.

"ena" <billie5xxREMOVE_at_yahoo.com> wrote in message news:<b0odsa$df3c$1_at_as201.hinet.hr>...
> Following the ALTER USER command I tried changing SYS schema password. Now I
> can't log into Oracle8 with INTERNAL/ ORACLE. I'm not sure if this problem
> is related to SYS schema password changing but it started happening then.
> Later I turned back the old password (CHANGE_ON_INSTALL) and I've also tried
> uninstalling Oracle Client on my machine but it still won't work.
> Does anyone know what to do in this situation? Is there some file where I
> can fix this manually?
> Any suggestion would be of real help.
>
> Thank you, Billie.
Received on Thu Jan 23 2003 - 22:05:04 CET