Re: Cannot connect as SYS/CHANGE_ON_INSTALL

Vincent

Not sure what the cause of your problem is, but as a workaround, if you can connect as system, you can use that connection with the alter user command to reset the password for sys, or any other user, to anything you like.

Why are you connecting as sys anyway ? Normally DBA work is done as system. You should hardly ever need to connect as sys, whose job is to simple host the database descriptor tables and views.

Best regards

Mark

On Mon, 05 Jul 1999 20:22:50 GMT, "Vincent GRENET" <vincent.grenet_at_free.fr> wrote:

>Hello all.
>
>I cannot connect as SYS, using the password CHANGE_ON_INSTALL as it is
>supposed to be after installation. I'm sure I did not change the password.
>The problem is still there after 3 installations (due to other problems).
>The passwords for the two other users existing after installation
>(system/manager & scott/tiger) are correct.
>
>I use Oracle8 Standard Edition on Linux (a Red Hat 5.2).
>
>Any ideas ?
>
>Thanks.
>
>
>
>
>
Received on Tue Jul 06 1999 - 05:47:08 CDT