Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlplus /@SID throws ORA-01017: invalid username/password; logon denied

2932053Apr 28 2016 — edited Apr 29 2016

Hi ,

I am having 2 databases in a same server. i have both the db entries added in tnsnames.ora . I am not able to connect to a database by using sqlplus /@SID (where SID is name of db which is same as that of in tnsnames.ora) . The OS user is Oracle. I am able to login normally sqlplus / , but i am not able to login as oracle that is sqlplus /@SID. I am able to do this in almost all the dbs mentioned in tnsnames.ora, but only for one db i am getting this error.

DB version is 11.2.0.4

OS : Red Hat Enterprise Linux Server release 6.7 (Santiago)

Below is the error log:

$ sqlplus /@EUQAUX

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 28 11:43:56 2016

ERROR:

ORA-01017: invalid username/password; logon denied

This post has been answered by 3223386 on Apr 28 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 27 2016

Added on Apr 28 2016

#general-database-discussions, #sqlplus

18 comments

16,211 views