Database Administration (MOSC)

MOSC Banner

invalid username / pasword even if I change the password at server level

edited Dec 12, 2013 10:26AM in Database Administration (MOSC) 18 commentsAnswered
Hi experts.Database version 9.2.0.7.
invalid username / pasword even if I change the password at server level
All users even Sys is happening this.  I cannot enter with any password.
System description, taken inside the server connecting /as sysdba:
How to solve this?
SQL> select username,account_status,ex
piry_date,profile,created,external_name from dba_users where username='SYSTEM';

USERNAME                       ACCOUNT_STATUS                   EXPIRY_DA
------------------------------ -------------------------------- ---------
PROFILE                        CREATED
------------------------------ ---------
EXTERNAL_NAME
--------------------------------------------------------------------------------
SYSTEM                         OPEN
DEFAULT                        20-JUN-07




SQL> desc dba_profiles
Name                                      Null?    Type
----------------------------------------- -------- --------------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center