Oracle Thin connectio fails from outside the network

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • hilz
    #1

    Oracle Thin connectio fails from outside the network

    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.


    Tags: None
    • Austin Durbin
      #2
      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

        Comment

        • hilz
          #3
          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.


            Comment

            • Michael Willer
              #4
              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>

                Comment

                Previous template Next
                Working...