in TNSNAMES.ORA change

ORACLE.SKYCABLE.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = database))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle)
)
)



to


ORACLE.SKYCABLE.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = database))
)
(CONNECT_DATA =
(SID = oracle)
)
)