Multiple IP Server Connection
I'm running Oracle Enterprise Edition Version 8.1.7.0.0 on a 2000 server. My server has 2 IP addresses one is local (for the lan) and the other is for a wireless connection (Internet IP).
I'm trying to connect to my server from the internet, but it keeps giving me the following in sqlnet.log:
***********************************************************************
Fatal OSN connect error 12203, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=oracle.world)(PROTOCOL=TCP)(Host=it does display the IP here)(Port=1521))(ADDRESS=(COMMUNITY=oracle.world)(PROTOCOL=TCP)(Host=My valid internet IP address)(Port=1526)))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=PLUS33W.EXE)(HOST=Mhamo)(USER=heltok))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 2.3.4.0.0 - Production
Time: 12-01-02 23:56:30
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS:unable to connect to destination
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0
=======================================================
Noting that I can use the same tnsnames.ora alias to connect successfully when I connect to the internet through the network, but the problem occurres when I use a dialup connection.
I've increased CONNECT_TIMEOUT_LISTENER=600 considering the problem is a timeout one, but it didn't work.
My listener is configured to listen on the local IP on the ports 1421 and 1526 and on the Internet IP on the ports 1522 and 1527.
My question is: Am I missing something or the whole thing is not even possible.
Thanks in advance your kind help.
Mohammad Al-Khalili