Database Networking (MOSC)

MOSC Banner

ORA-12154 when doing SQLPLUS user/passw@database...

edited May 28, 2010 4:16AM in Database Networking (MOSC) 9 commentsAnswered
Hi!
Im getting the famous ORA-12154 when doing this:

SQLPLUS scott/tiger@test

This is my tnsnames.ora:

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.x.xxx)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test)
    )
  )

I can connect when setting the sid and then SQLPLUS

and then user/passw.

Regards

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center