The service name u have mentioned is not in correct manner

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)))"

It should be like

jdbc-uri="jdbc:oracle:oci:@(DESCRIPTION = (ADDRESS =
(PROTOCOL = TCP)(HOST=192.168.2.19)(PORT = 1521))(CONNECT_DATA = (SERVER

= SHARED)(SERVICE_NAME = sa2radb)))"

Try this I think it will work


Regards
Manpreet Singh
Oracle Dba
Rsystems international Ltd


-----Original Message-----
From: Rajesh kalaria
[mailto:oracledba-ezmlmshield-x8347866.[Email address protected]
Sent: Tuesday, January 29, 2008 3:43 PM
To: LazyDBA Discussion
Subject: HELP - how to configure tnsnames.ora, listener.ora etc.....

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


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


Oracle LazyDBA home page