ORA-01017: invalid username/password; logon denied

    Either the username does not exist in the database or the password is invalid.


    To check which users exist in the database, use following select:


    select username from all_users

    If you want to have logging of all invalid attempts, enable database auditing by setting the value of the database parameter audit_trail to DB.

    Also enable auditing for invalid connections by using following statement:


    audit create session

    After that, you can find useful information by querying the dba_audit_session data dictionary view:


    select * from dba_audit_session where username='MYUSER' and returncode != 0;

    You can use our free tool Oracle Password Changer to change the password of an Oracle database user.

    Adverteren bij Daisycon
    Forum Messages
    20-FEB-2008 07:01:10Account lockedchakri Reply
    when i entered sql prompt using scott/tiger@oracle and trying to connect to system/manager i am getting account locked message.

    ORA-28000: the account is locked oracle

    how to resolve that.. can u help me.....
    : ->  14-MAR-2008 11:51:57Unlock the accountDbMotive Reply
    You have to unlock the account.

    You can do that with following command:
    alter user system account unlock

    Since Oracle 9, some default accounts are locked by default.
    You have to connect with an account with the correct privileges (eg / AS SYSDBA)
    18-MAR-2008 02:52:21Oracle database creationAvijit Sinha Reply
    how i create a database in oracle 10g
    : ->  18-MAR-2008 03:38:21Read the Oracle documentationDbMotive Reply
    Read the Oracle documentation on tahiti.oracle.com.

    There you can read all the necessary steps to create a new Oracle database, wether it is via the command line or via the database creation assistant.
    14-APR-2008 16:27:35dbasyarif Reply
    i forget my password to connect to my database.
    can you tell me for the solution?
    : ->  14-APR-2008 16:36:40Change itDbMotive Reply
    You have to connect using "/ as sysdba" or any other dba account to the database and reset the password for the account you are trying to connect with.
    Add your message for ORA-01017
    Name:email:
    Validation Code:qx304su2o55ojmrvd
    Enter Code above:
    Title:
    State your problem: