Re: Can't connect to [new] 9i DB - SYSTEM & SYS accounts are locked

A slight misreading of the assistant's last screen, I think.

It says that a whole heap of accounts are created along with the database ("hr" and "scott" for example), and that all their accounts are locked, and may need to be unlocked. The only exception is SYS and SYSTEM, who are *not* locked (and quite clearly never should be).

You can probably still connect as a privileged user (ie, connect sys/chang_on_install AS SYSDBA), and then issue the 'alter user X account unlock command'.

Regards
HJR "Mark Nagel" <mnagel_at_powerhousetechnology.com> wrote in message news:51bfdb2c.0109070851.71e3b167_at_posting.google.com...
> I recently installed Oracle 9i server on a Solaris 8 box and am unable
> to login via sqlplus. I get the error "ORA-2800: the account is
> locked" when attempting to login using SYS or SYSTEM. I used dbca to
> create 3 diffrent databases (without example schemas), and at the end
> of the creation process it instructed me to change the passwords on
> SYS andSYSTEM and to lock these accounts. I am quite sure that I am
> entering the passwords correctly, but I believe that the "lock"-ing
> issue is the problem. I cannot login using the scott account either
> (I believe that this won't exist without the example schema?)
>
> Do I have to blow away these databases and start over again (and not
> lock the SYS and SYSTEM accounts)? Or is there something that I am
> overlooking?
>
> I am not an Oracle DBA, nor do I play one on TV. I have been thrust
> into getting something up quickly and am not afforded the time to read
> through and digest the reams of documentation :-(
>
> Thanks in advance,
> Mark Nagel
Received on Fri Sep 07 2001 - 19:12:32 CDT