Re: ORA-28000: the account is locked
From: ilbmbo <ilbimbo_at_gmail.com>
Date: Thu, 1 Oct 2009 03:47:31 -0700 (PDT)
Message-ID: <535b078c-98a6-4ed3-9f5e-2163e29443ce_at_m38g2000yqd.googlegroups.com>
On 1 Ott, 12:39, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> On Oct 1, 6:12 am, ilbmbo <ilbi..._at_gmail.com> wrote:
>
> > the explanation is: Wait for PASSWORD_LOCK_TIME or contact DBA
>
> > but the problem born yesterday and i don't have a DBA....con you help
> > me?
>
> If you are able to connect as the SYS user with SQL*Plus (or another
> tool which allows executing SQL statements), execute the following:
> ALTER USER SYSTEM ACCOUNT UNLOCK;
>
> Charles Hooper
> IT Manager/Oracle DBA
> K&M Machine-Fabricating, Inc.
Date: Thu, 1 Oct 2009 03:47:31 -0700 (PDT)
Message-ID: <535b078c-98a6-4ed3-9f5e-2163e29443ce_at_m38g2000yqd.googlegroups.com>
On 1 Ott, 12:39, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> On Oct 1, 6:12 am, ilbmbo <ilbi..._at_gmail.com> wrote:
>
> > the explanation is: Wait for PASSWORD_LOCK_TIME or contact DBA
>
> > but the problem born yesterday and i don't have a DBA....con you help
> > me?
>
> If you are able to connect as the SYS user with SQL*Plus (or another
> tool which allows executing SQL statements), execute the following:
> ALTER USER SYSTEM ACCOUNT UNLOCK;
>
> Charles Hooper
> IT Manager/Oracle DBA
> K&M Machine-Fabricating, Inc.
With ALTER USER SYSTEM ACCOUNT UNLOCK; in sqlplus
i have this error:
ORA-01034: ORACLE not available Received on Thu Oct 01 2009 - 05:47:31 CDT