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.