Who can say anything:
I've got an SCO OpenServer 5.0 with Oracle 7.1.6.2.0.
OS has NIC interface, loopback inteface and some dynamic ppp interfaces.
Server is placed behind DSL-modem from corporative network, and this modem hangs from time-to-time.
All network clients and ppp-users must have access to Oracle throu Sqlnet V2, as I understood must be the following:
# netstat -an | grep 1521
tcp 0 0 *.1521 *.* LISTEN
i.e. port 1521 is opened on all network interfaces.
The problem is that if it's no connection to DNS-servers of outer network, when starting Oracle listener in order with string (Host = sco15) begins to resolve sco15 by DNS query and 'cause there'are no DNS available script is terminated after 2 minutes of timeout.
If I edit listener.ora as (Host = 10.30.70.15), then listener starts anyway but port 1521 is opened only on NIC interface like this:
tcp 0 0 10.30.70.15:1521 *.* LISTEN
and ppp-users couldn't connect to listener.
What should I do to start listener on all network interfaces when it's no connection to DNS servers?
Files on server sco15:
---=== listener.ora ===---
SQLNET.AUTHENTICATION_SERVICES = (NONE)
USE_PLUG_AND_PLAY_LISTENER = OFF
USE_CKPFILE_LISTENER = OFF
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sco15)
(Port = 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = A71.world)
(SID_NAME = A716)
(ORACLE_HOME = /U03/product/7.1.6)
(PRESPAWN_MAX = 10)
)
)
---=== listener.ora ===---
---=== sqlnet.ora ===---
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = ADMIN
TRACE_LEVEL_SERVER = ADMIN
TRACE_FILE_SERVER = $ORACLE_HOME/network/log/sqlnet.trc
SQLNET.EXPIRE_TIME = 0
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world
---=== sqlnet.ora ===---
---=== /etc/hosts ===---
...
10.30.70.15 sco15.asctp.azov.stal sco15
...
---=== /etc/hosts ===---
---=== /etc/resolv.conf ===---
domain asctp.azov.stal
nameserver 10.2.1.201
nameserver 10.20.34.2
hostresorder local / bind
---=== /etc/resolv.conf ===---
thus I actually points to get IP from local hosts SCO 5.0 sends DNS query anyway! maybe there's some patch to solve this?
Thanks to all!
I've got an SCO OpenServer 5.0 with Oracle 7.1.6.2.0.
OS has NIC interface, loopback inteface and some dynamic ppp interfaces.
Server is placed behind DSL-modem from corporative network, and this modem hangs from time-to-time.
All network clients and ppp-users must have access to Oracle throu Sqlnet V2, as I understood must be the following:
# netstat -an | grep 1521
tcp 0 0 *.1521 *.* LISTEN
i.e. port 1521 is opened on all network interfaces.
The problem is that if it's no connection to DNS-servers of outer network, when starting Oracle listener in order with string (Host = sco15) begins to resolve sco15 by DNS query and 'cause there'are no DNS available script is terminated after 2 minutes of timeout.
If I edit listener.ora as (Host = 10.30.70.15), then listener starts anyway but port 1521 is opened only on NIC interface like this:
tcp 0 0 10.30.70.15:1521 *.* LISTEN
and ppp-users couldn't connect to listener.
What should I do to start listener on all network interfaces when it's no connection to DNS servers?
Files on server sco15:
---=== listener.ora ===---
SQLNET.AUTHENTICATION_SERVICES = (NONE)
USE_PLUG_AND_PLAY_LISTENER = OFF
USE_CKPFILE_LISTENER = OFF
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sco15)
(Port = 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = A71.world)
(SID_NAME = A716)
(ORACLE_HOME = /U03/product/7.1.6)
(PRESPAWN_MAX = 10)
)
)
---=== listener.ora ===---
---=== sqlnet.ora ===---
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = ADMIN
TRACE_LEVEL_SERVER = ADMIN
TRACE_FILE_SERVER = $ORACLE_HOME/network/log/sqlnet.trc
SQLNET.EXPIRE_TIME = 0
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world
---=== sqlnet.ora ===---
---=== /etc/hosts ===---
...
10.30.70.15 sco15.asctp.azov.stal sco15
...
---=== /etc/hosts ===---
---=== /etc/resolv.conf ===---
domain asctp.azov.stal
nameserver 10.2.1.201
nameserver 10.20.34.2
hostresorder local / bind
---=== /etc/resolv.conf ===---
thus I actually points to get IP from local hosts SCO 5.0 sends DNS query anyway! maybe there's some patch to solve this?
Thanks to all!