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

[vnktummala]

Log in to Oracle as DBA user.

SQL> show parameter local_listener

should return LISTENER else

SQL> alter system set LOCAL_LISTENER='LISTENER' scope=both;
SQL> alter system register;

SQL> show parameter service_names

should return BORG else

SQL> alter system set SERVICE_NAMES='BORG' scope=both;

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = BORG)(PORT = 1521))
)
)

Also. cross check the host name. Is BORG resolving the host name? You can also try using IP address instead of host name.

Thanks,