OraDirect.Net on Windows CE / Firewall problem / Oracle CMAN
Posted: Wed 21 Sep 2005 16:43
Hi,
I'm trying to connect to an oracle database from a mobile device. The target database is accessible via internet through a firewall using oracle connection manager (CMAN). With a regular oracle client installation, the necessary information is provided in the TNSNAMES.ORA configuration file:
MY_DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.223.15)(PORT = 1630))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.222.205)(PORT = 1521))
(SOURCE_ROUTE = yes)
(FAILOVER = false)
)
(CONNECT_DATA =
(SERVICE_NAME = ABC)
)
)
In this example, the connection manager is on 192.168.223.15:1630, while the target database listener is on 192.168.222.205:1521.
In OraDirect.Net, the Connection object has “Servername” and “Port” properties, but because one CMAN can connect to multiple databases, providing only the CMAN IP-ADRESS and Port is insufficient.
So here comes the question: how do I make a connection from a mobile device, over an internet connection, through a firewall, to a database in my local network, WITHOUT opening all the ports and talking to the listener directly?
Hoping, there is a solution….
Thomas
I'm trying to connect to an oracle database from a mobile device. The target database is accessible via internet through a firewall using oracle connection manager (CMAN). With a regular oracle client installation, the necessary information is provided in the TNSNAMES.ORA configuration file:
MY_DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.223.15)(PORT = 1630))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.222.205)(PORT = 1521))
(SOURCE_ROUTE = yes)
(FAILOVER = false)
)
(CONNECT_DATA =
(SERVICE_NAME = ABC)
)
)
In this example, the connection manager is on 192.168.223.15:1630, while the target database listener is on 192.168.222.205:1521.
In OraDirect.Net, the Connection object has “Servername” and “Port” properties, but because one CMAN can connect to multiple databases, providing only the CMAN IP-ADRESS and Port is insufficient.
So here comes the question: how do I make a connection from a mobile device, over an internet connection, through a firewall, to a database in my local network, WITHOUT opening all the ports and talking to the listener directly?
Hoping, there is a solution….
Thomas
! nice 
)