First of all, Thanks
alot ... it did directed me towards the right approach
Somehow, I was able to achieve my connection part of application server to Oracle 10g... by configuring the data source part in application server to connect to my remote db, i.e., oracle 10g (say on a machine - harry002)
Application server is on machine : harry001
Now having successfully established the connection by giving static IPs to both the machines within same subnetwork... harry001 =>192.168.1.2 and harry002=>192.168.1.3 ( I'm using these only for demonstration purposes so that i can achieve what i want)
After my application has launched, when query the DB through my application for a simple Login page i get the following exception...
java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: localhost:1521 : orcl
Now i have no idea how to get rid of this exception... please help me out
Thanks ..