failed to easy connect:ORA-12504: TNS:listener was not given

[kytemaniac]

Hi,

my oracle version is Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

my platform is as follow:

Code: Select all

SYS@orcl>select platform_id, platform_name from v$database;

PLATFORM_ID
-----------
PLATFORM_NAME
--------------------------------------------------------------------------------
    13
Linux x86 64-bit




tnsname.ora is as follow:

Code: Select all

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.localdomain)
    )
  )


when I do the following

Code: Select all

[oracle@localhost ~]$ sqlplus scott@"localhost/orcl"

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 1 02:10:46 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

ERROR:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA


Enter user-name:




I get the above error, is there any way I can resolve the error?

thanks

[Tim...]

Hi.

Why would you expect this to work? I've never seen anyone trying to connect like this. Do you perhaps mean the EZ Connect URL, like this:

Code: Select all

//localhost:1521/orcl.localdomain

Cheers

Tim...

[kytemaniac]

No I did not have a url host, what should I replace localhost? the above set up is set up locally in a linux box

I try replacing with 127.0.0.1

Code: Select all

[oracle@localhost ~]$ sqlplus scott@"127.0.0.1:1521/orcl"

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 1 02:26:15 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

ERROR:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA


Enter user-name:




still fail

thanks

[Tim...]

Hi.

No. The EZ Connect URL is a way of connecting without needing to define a full TNS alias. for example.

Code: Select all

sqlplus scott@//localhost:1521/orcl.localdomain

If you have a regular TNS alias defined in the tnsnames.ora file, then you can use that.

Code: Select all

sqlplus scott@orcl

This has nothing to do with any specific OS. This is the same way Oracle works on all platforms.

Cheers

Tim...