ORA:01017 Invalid username and password

Posted on 2007-10-17
Last Modified: 2013-12-19
I have installed Oracle 9i (Server). I can get into the system using Scott/tiger@boa but when i try system/manager@boa. it gives me error saying  ORA-01017 Invalid user name and password. Here boa is my sisid
Question by:smrit_simti
    LVL 12

    Accepted Solution

    first check if user SYSTEM exists:

    SQL> select count(*)
     from all_users
     where username = 'SYSTEM'


    log in as user with dba permissions and change the password with

    SQL> ALTER USER system IDENTIEFIED BY manager;
    LVL 11

    Assisted Solution

    Additional tip to log in as DBA without needing a password: sqlplus "/ as sysdba" while connected with an OS user which belongs to the group "dba" (*nix) or "ORA_DBA" (Win*).

    In Windows you may have to put this in your sqlnet.ora:

    If you cannot get a DBA connection with all this, you can try a password file, but that's a long story...

    Friendly warning: there's a typo on jwahl's SQL, should be "IDENTIFIED". Also, after you reset the password you might have to execute this to get the connection:
    LVL 8

    Assisted Solution

    First of all, someone change the password.  If so , ask your dba before trying to change it to manager to avoid possible problems.  The Dba may have cange it for secuity purposes.
    Ask your Dba to provide you a user, maybe with the last 4 numbers of your social security number or your employee number with dba role.  In this way the dba if has some auditing triggers of some kind he/she will be able to monitor what you are doing inside the database.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    This video shows how to recover a database from a user managed backup

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now