VPN - oracle errors

From: Catherine Sylvester <csylvester_at_bbo.on.ca>
Date: Thu, 30 Mar 2000 10:54:10 -0500
Message-ID: <38E378A2.D55D52@bbo.on.ca>

I am running an oracle application on a Novell 5.0 server. The database is up and running and can be accessed from within the network. I am connecting to the server from a remote site using Novell a VPN tunnel. I cannot get my oracle application to run connecting this way. The error I receive:

TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out

I understand TNS-12560 means that the correct protocol adapter may not be installed in the listener.ora. However, I think it is. I have included the listener.ora below.

does anyone have experience in this area? I would appreciate your help.

My listerner.ora file says:

     (ADDRESS =


       (PROTOCOL = TCP)


       (HOST = 192.168.9.3)


       (PORT = 1521)


     )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = ORCL)
      (ORACLE_HOME = SYS:ORANW732)

    )
  )
#EZCFG_VER=1.1.0.0.0 Cathy Sylvester Received on Thu Mar 30 2000 - 09:54:10 CST