ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Solution :
Try changing your ORA properties.
your SERVICE_NAME = ORA11gR23 should match the name you have given before description.
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.