• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1556
  • Last Modified:

ORA:01017 Invalid username and password

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
0
smrit_simti
Asked:
smrit_simti
3 Solutions
 
jwahlCommented:
first check if user SYSTEM exists:

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

 COUNT(*)
---------
        1

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

SQL> ALTER USER system IDENTIEFIED BY manager;
0
 
AkenathonCommented:
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:
SQLNET.AUTHENTICATION_SERVICES = (NTS)

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:
ALTER USER SYSTEM ACCOUNT UNLOCK;
0
 
LindaCCommented:
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.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now