Some software I'm writing needs to query an oracle database - the DBA is away for a while, so all I have to go on is some source code from another application that connects to the same database (and I'm not even sure it's current). The java connect string looks like this:
jdbc:oracle:thin:@101.010.101.010:1521:srip
Which the jdbc documentation tells me means that the server address/port is 101.010.101.010:1521 and the 'service name' is srip. I've created a corresponding entry in tnsnames.ora that looks like this:
mydb=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 101.010.101.010)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = srip)
)
)
In the ODBC configuration dialog the oracle client finds the 'mydb' entry and lists it under 'TNS Service Name'. When I try to 'test connection', it returns instantly with error ORA-12514: TNS:listener does not currently know of service requested in connect decsriptor. I guess this means the SERVICE_NAME entry is wrong, maybe it has been changed. Is there any way to find out what service names are available on a remote server that I don't have any other access to?