I am using Oracle Thin Driver in my Desktop Application (java). Application successfully connect to database server when Firewall is off. when ever i turn On the firewall and add port 1521 in allowed list then the client desktop application did not connect. when i check the firewall log the the request from client is on random port generated by application that is different from 1521 . but the connection string i am using for connection is
String connString =
"jdbc:oracle:thin:@(description=(address_list=
(address=(protocol=tcp)(port=1521)(host=fireWallHost))
(address=(protocol=tcp)(port=1521)(host=oraHost)))
(connect_data=(INSTANCE_NAME=orcl))
(source_route=yes))";
OracleDataSource ods = new OracleDataSource();
ods.setURL(connString);
ods.setUser("scott");
ods.setPassword("tiger");
Connection conn = ods.getConnection();
classes12.jar file is used for oracle Driver in Java Programme.
here local firewall is there in windows server.
when i add other firewall in between the clients and server. then i allow 1521 port in firewall. and turn off the server local firewall. then also same situation occurs.
but when both firewall is removed or turned off then application connect successfully..
I am Using Oracle 10g on Windows Server 2003
Kindly Suggest what to do