-
We are trying to use our second NIC card to allow external access to our database. We are experiencing "listener not found" errors. We tried several things. When we do not restrict by port number we are able to connect to the database. However if we only open port 1521 we can not. The database is created in "dedicated server mode". We have tried adding different port numbers that we thought that maybe we needed but we still end up with the error. Any suggestions.
-
Did you allow this in your firewall.please check ur firewall configuration
cheese
anandkl
-
Presumptively, the second NIC is on the same IP segment as your firewall/external comm server?
Also, you modified the listener.ora to include the second NIC>
(End of 'is it turned on' questions.)
You also may be facing a NAT translation issue. You may need CMAN to control the traffic.
-
1. try to create address_list in listener.ora
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=1_ip_address)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=2_ip_address)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
then restart listener and check services
lsnrctl
> stop
> start
> services
and check services and instanses.
Try to check ESTABLISH net. connection using netstat utility.