Hello all,
When I connect to oracle I get the message
Listener was not given the service name in connectdata
Which file should I add the service name?
Thx,
LR
Hi,
In order to connect to Oracle, you need to write the full connect description to the database server location. for example:(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 25.1.1.161) (PORT = 1541)) (CONNECT_DATA = (SID = PROD)))
(The connect descriptor can be found in the tnsnames.ora file. for more info:
http://download.oracle.com/docs/cd/B28359_01/network.111/b28317/tnsnames.htm )
Or you can try also the EZ Name convention:host:port/service_name
(for more info about the EZ name convention : http://download.oracle.com/docs/html/B10131_02/glossary.htm )
Aviad.