Re: Oracle password problem
From: gazzag <gareth_at_jamms.org>
Date: Fri, 30 Oct 2009 05:39:22 -0700 (PDT)
Message-ID: <d2d9dc29-be1e-479a-8600-fafae656ef55_at_y23g2000yqd.googlegroups.com>
On 30 Oct, 10:58, neilsolent <n..._at_solenttechnology.co.uk> wrote:
> Hi Gazzag
>
> > > Also - I could not change the sys or system password (it's almost as
> > > if those accounts have been deleted! Could they have been?)
>
> > What did you try and what happened?
>
> alter user 'system' identified by 'password1';
>
> I can't remember the error - sorry should have clocked it (been in a
> bit of a panic with this).
> Is there a simple command a normal user can run to just check these
> user accounts are there perhaps?
>
> thanks,
> Neil
Date: Fri, 30 Oct 2009 05:39:22 -0700 (PDT)
Message-ID: <d2d9dc29-be1e-479a-8600-fafae656ef55_at_y23g2000yqd.googlegroups.com>
On 30 Oct, 10:58, neilsolent <n..._at_solenttechnology.co.uk> wrote:
> Hi Gazzag
>
> > > Also - I could not change the sys or system password (it's almost as
> > > if those accounts have been deleted! Could they have been?)
>
> > What did you try and what happened?
>
> alter user 'system' identified by 'password1';
>
> I can't remember the error - sorry should have clocked it (been in a
> bit of a panic with this).
> Is there a simple command a normal user can run to just check these
> user accounts are there perhaps?
>
> thanks,
> Neil
SELECT USERNAME, ACCOUNT_STATUS
FROM DBA_USERS
WHERE USERNAME LIKE 'SYS%';
Additionally, you don't want the quotes in your ALTER USER command.
ie.
ALTER USER SYSTEM IDENTIFIED BY <new_password>;
HTH -g Received on Fri Oct 30 2009 - 07:39:22 CDT