By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,190 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

Oracle Thin connectio fails from outside the network

P: n/a
Hi all:
I have an oracle 9i server running behind a firewall.
i set up the machine that has the oracle server as a DMZ zone.

i can connect to the oracle server from the local network but not from
outside (using the oracle THIN driver)

can anyone tell me what is the problem and how to solve it?

thanks
hilz.
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
It sounds like your firewall is blocking TCP conversations initiated from
the outside into the DMZ, but allowing traffic initiated from your internal
network. I would start by looking at your firewall config.
"Rauf Sarwar" <rs******@hotmail.com> wrote in message
news:92**************************@posting.google.c om...
"hilz" <hs***@hotmail.com> wrote in message

news:<Pe********************@speakeasy.net>...
Hi all:
I have an oracle 9i server running behind a firewall.
i set up the machine that has the oracle server as a DMZ zone.

i can connect to the oracle server from the local network but not from
outside (using the oracle THIN driver)

can anyone tell me what is the problem and how to solve it?

thanks
hilz.

Can you ping the server?
Can you tnsping the listener?
What is the error message?

Regards
/Rauf Sarwar

Jul 19 '05 #2

P: n/a
> Can you ping the server?
yes
Can you tnsping the listener? i don't know. how do i do that?

What is the error message?

in the "listener.log", i get the follwoing:

01-JUL-2003 01:07:25 *
(CONNECT_DATA=(SID=orcl1)(CID=(PROGRAM=)(HOST=__jd bc__)(USER=))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=4.31.67.91)(PORT=1248 )) * establish * orcl1 * 0

and in the java program (on the client, from outside the network), i get the
following exception:
Io exception: The Network Adapter could not establish the connection
java.sql.SQLException: Io exception: The Network Adapter could not establish
the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java)
at oracle.jdbc.driver.OracleConnection.<init>(OracleC onnection.java)
at oracle.jdbc.driver.OracleDriver.getConnectionInsta nce(OracleDriver.java)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java)
at java.sql.DriverManager.getConnection(DriverManager .java:512)
at java.sql.DriverManager.getConnection(DriverManager .java:171)
at testjdbc.<init>(testjdbc.java:18)
at testjdbc.main(testjdbc.java:7)

Any help is greatly appreciated.
Jul 19 '05 #3

P: n/a
>>Can you tnsping the listener?

i don't know. how do i do that?

$ORACLE_HOME/bin/tnsping <oracle-tnsname>

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.