Re: ORA-01017: invalid username/password; logon denied
From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Wed, 07 Jul 2004 06:42:59 +0200
Message-ID: <envme0tufup0qko0ko3lcf2r9v9v2sqckv_at_4ax.com>
Date: Wed, 07 Jul 2004 06:42:59 +0200
Message-ID: <envme0tufup0qko0ko3lcf2r9v9v2sqckv_at_4ax.com>
On 6 Jul 2004 12:57:07 -0700, ssashital_at_hotmail.com (Sheetal) wrote:
>I'm trying to connect to my Oracle 9.0. database, which is on the local machine.
>When i try to connect using system/manager
>or
>scott/tiger
>it gives me this error:
>
>ORA-01017: invalid username/password; logon denied
>
>What do I do???
>Any help would be appreciated.
>
>TIA
Get in with
sqlplus /nolog
connect / as sysdba
select username from dba_users where username = 'SCOTT'
to see whether SCOTT actually exists (isn't installed by default
anymore)
and
alter user system identified by <newpassword>
to change the password to something you can remember.
-- Sybrand Bakker, Senior Oracle DBAReceived on Wed Jul 07 2004 - 06:42:59 CEST