All,
I want to connect my java application to the oracle 10g database
hosted on different server. I am using following.
jdbc-uri="jdbc:oracle:oci:@(DESCRIPTION = (ADDRESS =
(PROTOCOL = TCP)(HOST=192.168.2.19)(PORT = 1521))(CONNECT_DATA = (SERVER
= SHARED)(SERVICE_NAME = sa2radb.in2m.com)))"
I am getting the following error from application :
ORA-12514: TNS:listener does not currently know of service
requested in connect descriptor
I have tried to read about how to configure tnsnames.ora,
listner.ora but ended up with same status. Please provide me step by
step guidance to configure all the required files on my box and on the
database server.
Any kind of help will be appreciated.
Regards,
Rajesh
Oracle LazyDBA home page