Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't connect to [new] 9i DB - SYSTEM & SYS accounts are locked

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

From: Anurag Varma <avdbi_at_nospam.hotmail.com>
Date: Fri, 07 Sep 2001 17:31:26 GMT
Message-ID: <Ov7m7.15346$tb.2406496@news02.optonline.net>


Mark,

Connect to your oracle account and type:

sqlplus /nolog

connect / as sysdba
  .... or connect /@SID as sysdba

alter user sys account unlock;
alter user system account unlock;
alter user scott account unlock;

Anurag
BTW: Remember to get your keys when you get out of your apartment :))

"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.
> Thanks in advance,
> Mark Nagel
Received on Fri Sep 07 2001 - 12:31:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US