Category Archives: ora-12504

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

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


Solution :

Try changing your ORA properties.

from this :
ORA11gR23 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = TCP)

(HOST = orasrv-alanb-lx06)

(PORT = 1521)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ORA11gR23)

)

)

)

  

To this:
ORA11gR23 =

(DESCRIPTION =

(ADDRESS =

(PROTOCOL = TCP)

(HOST = orasrv-alanb-lx06)

(PORT = 1521)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ORA11gR23)

)

)

  
your SERVICE_NAME = ORA11gR23 should match the name you have given before description.



71 total views, no views today