This content has been marked as final. Show 4 replies
user13254781 wrote:Please show us your attempt including results.
I tried to log in using the 'connect' command within the 'Run SQL Command Line' window using first my SYSTEM username/password config and my test environment login credentials. All received the ORA-12154 error.
Post a copy-paste of sql command line session when trying to connect.
You don't happen to have a @ sign in the password?
Example from successful 'connect':
SQL*Plus: Release 220.127.116.11.0 Production on MÕ Mar 26 21:41:59 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. SQL> connect test Enter password: Connected. SQL>
I actually do have an '@' sign. Is this my error?
Enter user-name: J@son
Enter password: <password with '@' symbol>
In Oracle, there are non-quoted and quoted identifers.
Same goes for username... I would remove the @ to avoid future problems.
SQL> conn / as sysdba Connected. SQL> alter user test2 identified by "x@x"; User altered. SQL> conn test2/x@x ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Warning: You are no longer connected to ORACLE. SQL> conn test2/"x@x" Connected.
Edited by: orafad on Mar 27, 2012 1:15 AM
Thank you orafad, removing the '@' worked great.