Home » RDBMS Server » Security » ORA-01017: invalid username/password; logon denied
ORA-01017: invalid username/password; logon denied [message #146417] Thu, 10 November 2005 05:23 Go to next message
kvjai
Messages: 6
Registered: October 2005
Location: Chennai
Junior Member

Hi,

Need your help, I am able to login into db using all logins including (sys,system), but not able to connect to DB as sysdba.

Getting error
Mesg::ORA-01017: invalid username/password; logon denied

But with sys as normal permission i am able to login to DB. Totally confused and suffering need your help.

Regards

Vijai K
Re: ORA-01017: invalid username/password; logon denied [message #146586 is a reply to message #146417] Fri, 11 November 2005 05:12 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

can you post the specific command that you entered.

You wrote that you are able to login as "sys,system" etc. but not as sysdba. so what was the command that you used to login as "sys".

Please do mention the OS details and the Oracle version in the next post.
Re: ORA-01017: invalid username/password; logon denied [message #146589 is a reply to message #146586] Fri, 11 November 2005 05:43 Go to previous messageGo to next message
kvjai
Messages: 6
Registered: October 2005
Location: Chennai
Junior Member

Sorry for that

OS : Windows 2000

I tried thru SQLPLUS, ENTERPRISE MANAGER

>CONNECT SYS/PASSWORD@TEST
IT IS GETTING CONNECTED

>CONNECT SYS/PASSWORD@TEST AS SYSDBA
IT IS THROUGHT ME AS ERROR MESG I ALSO TRIED

>CONNECT SYS@TEST AS SYSDBA
THEN ALSO IT IS THROUGHING ERROR MESG

AND ALSO NOT ABLE TO CHANGE THE SYS PASSWORD.

REGARDS

VIJAI K
Re: ORA-01017: invalid username/password; logon denied [message #146591 is a reply to message #146589] Fri, 11 November 2005 05:50 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


try from sqlplus first and if successful then login from enterprise manager.

you wrote
Quote:

>CONNECT SYS/PASSWORD@TEST
IT IS GETTING CONNECTED


what is the output of the following command in this session
 show user


Are you using Password file authentication to login as sys?
Do you have one or more database on this machine?

can you copy/paste something like this from your session
SQL> conn sys/tarun as sysdba;
Connected.
SQL> show user
USER is "SYS"
SQL> conn system/manager 
Connected.
SQL> show user
USER is "SYSTEM"

Previous Topic: Oracle 7.3.4 and https-connections
Next Topic: how do I set connect / as sysdba?
Goto Forum:
  


Current Time: Fri Mar 29 08:36:12 CDT 2024