Remote access

[MuLtAnI]

Good afternoon people!
I have a problem in remote access to the Oracle 9i server.

Maybe this fits more into the network part, and since it is not my strong I decided to ask here.
The scenario is as follows, has a real IP, which arrives in a D-Link 500g (Generation 4) modem, in this same network, has plus 2 IP computers 10.1.1.5 (machine 5) and 10.1. 1.3 (machine 3) NA 5 is Oracle. Intalated, configured. So, I need to get to access externally by the actual IP, the call by Port 1521 is sent to the machine 5. Because now, what is containing is that when accessing the BD by the machine 3, in the internal network, it works perfectly, , when the service points directly to 10.1.1.5. Now, when I access an external network, direct by the real IP port 1521, 'there is a NAT rule in the modem that redirects the call. However, there is no communication and the operation suffers timeout.

Does anyone have any tips ???

Thanks and [] 's

[dr_gori]

Maybe it's some problem in configuring your NAT.
At first, it should work in a good ...: - /

I know there are some providers who block doors below 2000. That is, you would have to set the client To use a door above that and NAT convert to 1521. But this in common adsl - residential. In your case, you said fixed IP, you do not have these restrictions.

I do not know man ...

[thiagomz]

I believe this is not going to work .... even creating a redirect of 1521, when the bank sends a return it comes from another door ....

When I need to do this, access the base of the client remotely through a valid IP I use Cman (Connection Manager) is simple to set up .. in metalink has a legal note ...

qualquer doubt shouts me .... I give you some tips ...

Just remember that the CMAN is part of the Enterprise.

[MuLtAnI]

Hello tiago!

Do you have any reference about Connection Manager?

I will enjoy the weekend to do this, since the server is Windows 2003 and the person in charge of the servers, and I will have to end up re-installing everything, so (try) Configure correctly from the beginning already!

Thanks and [] 's

[thiagomz]

I have a mania to create howto's when I can do something new ... follow my cyma annotacoes

doubts ... postem ai

Select all

 
# 
# Como configurar o CMAN atraz de um Firewall 
# Por Thiago M. Zerbinato - 06.05.2005 
# 
 
1.Criar um redirect no Firewall da porta 1630 para a 1630 do servidor oracle. 
 
2. Editar os Arquivos 
 
# sqlnet.ora 
 
use_cman = true 
 
# cman.ora 
 
cman = (ADDRESS_LIST= 
           (ADDRESS=(PROTOCOL=tcp)(HOST=srvora)(PORT=1630)(QUEUESIZE=32)) 
       ) 
 
cman_profile = (parameter_list= 
                   (MAXIMUM_RELAYS=1024) 
                   (LOG_LEVEL=1) 
                   (TRACING=no) 
                   (RELAY_STATISTICS=yes) 
                   (SHOW_TNS_INFO=yes) 
                   (USE_ASYNC_CALL=yes) 
                   (AUTHENTICATION_LEVEL=0) 
                   (REMOTE_ADMIN=FALSE) 
               ) 
cman_rules = (rule_list= 
                 (rule= 
	 	 (src=200.187.173.86) 
		 (dst=192.168.10.4) 
		 (srv=inter) 
		 (act=accept)) 
             ) 
OBS: quando cman_rules é declarado, ele bloqueia tudo exceto a propria rule, quando comentado cman_rules ele libera tudo. 
 
# tnsnames.ora 
 
INTER_CMAN = 
        (DESCRIPTION = 
                (ADDRESS_LIST = 
                (ADDRESS = (PROTOCOL = TCP)(HOST = 200.245.109.135)(PORT = 1630)) 
                (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.4)(PORT = 1521))   
        ) 
        (CONNECT_DATA = 
                (SID = INTER) 
        ) 
        (SOURCE_ROUTE = YES) 
        ) 
 
3. Iniciar o Cman 
 
cmctl start 
 
# 
# Fim. 
#