OraFAQ Forum: Security » ORA-01017: invalid username/password; logon denied

Home » RDBMS Server » Security » ORA-01017: invalid username/password; logon denied

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01017: invalid username/password; logon denied [message #146417]

Thu, 10 November 2005 05:23

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

Report message to a moderator

Re: ORA-01017: invalid username/password; logon denied [message #146586 is a reply to message #146417]

Fri, 11 November 2005 05:12

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.

Report message to a moderator

Re: ORA-01017: invalid username/password; logon denied [message #146589 is a reply to message #146586]

Fri, 11 November 2005 05:43

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

Report message to a moderator

Re: ORA-01017: invalid username/password; logon denied [message #146591 is a reply to message #146589]

Fri, 11 November 2005 05:50

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"

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 01:00:46 CST 2025