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.
A Full Stack developer who is facing problems in development cycle and here you find solution of errors of those problems.This includes all exception and configuration issues. Solutions which i have written in blog are the one which worked for me after killing my time :) .