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

Mark

No need to blat the database. It appears you said lock the accounts when you created the database, but here's how to get around it:

SQL> connect / as sysdba

Connected.

SQL> show user

USER is "SYS"

SQL> alter user sys account lock;

User altered.

SQL> connect sys/change_on_install

ERROR: ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.

SQL> connect sys/change_on_install as sysdba

Connected.

SQL>

--
HTH.  Additions and corrections welcome.

Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Now got a life back again that the book is released!

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

"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