OraDirect.Net on Windows CE / Firewall problem / Oracle CMAN

OraDirect.Net on Windows CE / Firewall problem / Oracle CMAN

Postby Thomas » 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
Thomas
 

Postby Paul » Mon 26 Sep 2005 08:06

Try to connect to 192.168.223.15:1630:ABC
This problem can be resolved on server side. Try to configure MTS dispatcher on Oracle server to use single Port number during connection
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Well Done

Postby Guest » Wed 16 Nov 2005 22:14

Guest
 


Return to dotConnect for Oracle