Oracle Database Discussions

Hello,

I am working on a Senior Project for school and I need myself and my class mates t be able to access an Oracle database on my server. I have Oracle Database 10g installed on the machine with the database on it and the Oracle 10g client installed on the laptop. I first setup the connection in the tnsnames.ora file to the local IP address 192.169.1.12 of the database server computer. This worked fine and I was able to access the database on the server from my laptop. But, I want to use Hamachi VPN http://hamachi.cc/ in order to allow my class mates to access the server without forwarding any ports etc.

The problem is that when I use the Hamachi VPN address instead of 192.168.1.12 I get an error "The Network Adapter could not establish the connection" The Hamachi address of the server is 5.9.167.211. The server and the laptop can ping each other through Hamachi, and other protocols seem to work fine and I can access the web server via the Hamachi address of the server as well.

What I used to connect from the laptop is SQL Developer and used the TNS method for the connection and selected "ORCL".




Here are the .ora file contents for the laptop Note: These work with the IP addresses as 192.168.1.12, but not the Hamachi address, so I suspect the problem is with Hamachi. I did NOT disable vulnerable services over Hamachi and I am using version 1.0.2.2

TNSNAMES.ORA

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 5.9.167.211)(PORT = 1522))


ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 5.9.167.211)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

SQLNET.ORA
SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

LISTENER.ORA

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\product\10.2.0\client_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 5.9.167.211)(PORT = 1522))
)
)

Edited by: user10673487 on Dec 5, 2009 2:37 PM