Home » RDBMS Server » Security » ORA-01017: invalid username/password; logon denied
icon5.gif  ORA-01017: invalid username/password; logon denied [message #136826] Sun, 11 September 2005 06:02 Go to next message
dinakar5008
Messages: 19
Registered: August 2005
Location: india
Junior Member

I had installed Oracle 9i Enterprise Edition Rel 2 on windows 2003 server .and created default database while installation .
after installation i am able to connect to database as system/admin@orcl as sysdba and normal , but when i changed the databse to archivelog mode , i am not able to connect the databse as normal user and when i am trying to connect as sysdba its connecting , i am getting the following error ORA-01017: invalid username/password; logon denied while i am trying to connect as normal user , but when i tried to connect as sysdba its connecting , plz help me ...
Re: ORA-01017: invalid username/password; logon denied [message #136920 is a reply to message #136826] Mon, 12 September 2005 05:03 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
You might have another problem. Switching to archivelog mode will not suddenly cause ORA-1017 problems. To confirm, disable archivelog mode and see if you can connect again.

Best regards.

Frank
Re: ORA-01017: invalid username/password; logon denied [message #149262 is a reply to message #136826] Wed, 30 November 2005 21:30 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
I have always been able to do:
1) sqlplus
2) username>sys / as sysdba
3) password> anything
4) alter user <user> identified by <yourpassword>;
5) exit
6) sqlplus
7) username> <the user you changed the password for>
Cool password> <the value in <yourpassword> from above

HTH
Neil.
Previous Topic: database auditing
Next Topic: Password Policy
Goto Forum:
  


Current Time: Thu Mar 28 03:56:36 CDT 2024