VPN connection

[rich73]

I cannot establish a connection across a VPN. I get an ORA-12535: TNSperation timed out.

I can log on to the UNIX server and eastablish a session through sqlplus. Is there something I should be doing or looking for.

This was working two days ago.

Thanks.

 

[Marco Kalter]

Perhaps you can enable SQL*Net tracing by setting "trace_level_client = USER" in the sqlnet.ora configuration file? The trace file should allow us to determine what is happening.

1. Edit \Network\Admin\sqlnet.ora using notepad or wordpad
2. Change trace_level_client=OFF to trace_level_client=USER (or add this line)
3. Save the sqlnet.ora file
4. Run PL/SQL Developer and try to connect
5. Tracing file is located in PL/SQL Developer directory (sqlnet.log).
   Please send this file to me.
6. Change trace_level_client=USER to trace_level_client=OFF
7. Save the sqlnet.ora file

 

[rich73]

I figiured out what's going on. Our tech support decided to push a common host file to our machines and not tell us. So the the host file and the tnsnames file were not in sync.

Thanks for the help anyway.

 

[Marco Kalter]

Okay, thanks for letting me know.