Skip to Main Content

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!

Not able to connect using sqlplus username/password@dbname

rajivmSep 16 2013 — edited Sep 17 2013

Hi,

I am new to Oracle, so request you to help me fix this issue.

I am trying to login to the database using schema name and password like:

sqlplus username/password@dbname

But it gives me the following error:

ERROR:

ORA-01017: invalid username/password; logon denied

But I am able to login with the same username and password when I just pass it as:

$sqlplus

Enter user-name: username

Enter password: password

SQL>


I have checked tnsnames.ora and sqlnet.ora file and the values inside these files are perfect.

I just have only one database on this machine.

Machine OS: linux

Please help me is resolving this.

Thanks,

-Rajiv

This post has been answered by EdStevens on Sep 16 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2013
Added on Sep 16 2013
5 comments
2,772 views