Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> TNS Connection timed out

TNS Connection timed out

From: Sreenivas Veerapaneni <sveera_at_frmt1.sfba.home.com>
Date: Thu, 28 Oct 1999 21:05:49 GMT
Message-ID: <Pine.LNX.4.10.9910281356140.14910-100000@veerapaneni.penguinpowered.com>


Hi i have a Oracle 8.0.5 Server running on a Linux Machine. When i try to tnsping to this server from my work place i get an error saying TNS-12535: TNS: Operation Timed out

But i can connect to the server throug my laptop when my laptop is connected to internet through dialup. Quite a while back i was able to connect to the server from my work place. But after that i reinstalled Oracle and unable to connect. I am giving my listener.ora and tnsnames.ora files. any help is appreciated.

thx
Srini

listener.ora



LISTENER =
    (ADDRESS=
      (PROTOCOL = TCP)
      (Host = my.machine.com)
      (Port = 1521)

    )
  )
SID_LIST_LISTENER =
(SID_LIST =
  (SID_DESC =
(SID_NAME =appdev01)
(GLOBAL_DBNAME = appdev01.world)
(ORACLE_HOME = /u01/app/oracle/product/8.0.5)
  )
  (SID_DESC =
(SID_NAME =appdev02)
(GLOBAL_DBNAME = appdev02.world)
(ORACLE_HOME = /u01/app/oracle/product/8.0.5)
  )
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 1000
TRACE_LEVEL_LISTENER = ON
USE_OTRACE=TRUE tnsnames.ora

appdev01.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS = 
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = my.machine.com)
          (Port = 1521)
        
        (ADDRESS = 
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = my.machine.com)
          (Port = 1526)
        )

    )
    (CONNECT_DATA = (SID = appdev01)
    )
  ) Received on Thu Oct 28 1999 - 16:05:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US