Oracle Thin connectio fails from outside the network

Re: Oracle Thin connectio fails from outside the network

>>Can you tnsping the listener?

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

$ORACLE_HOME/bin/tnsping <oracle-tnsname>

Re: Oracle Thin connectio fails from outside the network

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.l og", i get the follwoing:

01-JUL-2003 01:07:25 *
(CONNECT_DATA=( SID=orcl1)(CID= (PROGRAM=)(HOST =__jdbc__)(USER =))) *
(ADDRESS=(PROTO COL=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.SQLExc eption: Io exception: The Network Adapter could not establish
the connection
at oracle.jdbc.dba ccess.DBError.t hrowSqlExceptio n(DBError.java)
at oracle.jdbc.dba ccess.DBError.t hrowSqlExceptio n(DBError.java)
at oracle.jdbc.dri ver.OracleConne ction.<init>(Or acleConnection. java)
at oracle.jdbc.dri ver.OracleDrive r.getConnection Instance(Oracle Driver.java)
at oracle.jdbc.dri ver.OracleDrive r.connect(Oracl eDriver.java)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:171)
at testjdbc.<init> (testjdbc.java: 18)
at testjdbc.main(t estjdbc.java:7)



Any help is greatly appreciated.

Re: Oracle Thin connectio fails from outside the network

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_arwar@hotma il.comwrote in message
news:92eeeff0.0 306291828.6f5c6 bfc@posting.goo gle.com...

"hilz" <hs_74@hotmail. comwrote in message

news:<Pe-dnaCKWLoLHWOjRT vU2Q@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

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.