-
Listener...kind of wierd.
Hello all..
Sun 5.8 and Oralce 9iR2
I have this Sun box that has 2 ipadresses ending with xxx.xx.xx.10 and xxx.xx.xx.53.
Server side:
------------
I looked up at my listener.ora file on the DB server and it is pointing to .53 address. I looked up at my tnsnames.ora on the server and it is pointing to .53 address.
client side:
========
I configured my tnsnames.ora on the client side to point to xxx.xx.xx.53
and i was able to connect.
Next when i change my tnsnames.ora on the client to point to xxx.xx.xx.10, i was still able to connect. ...
So my quesiton is;
How does Oracle know that the box has 2 ip addresses and how does it resolve it ?
thanks
Ron
-
Can you post listener.ora and tnsnames.ora (db server and client) files here?
-
# LISTENER.ORA Network Configuration File: /u10/app/ORACLE/product/9.2.0.1.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xx.53)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u10/app/ORACLE/product/9.2.0.1.0)
(PROGRAM = extproc)
)
(SID_DESC =
(SDU=1500)
(TDU=8760)
(GLOBAL_DBNAME = dss.osc.state.nc.us)
(ORACLE_HOME = /u10/app/ORACLE/product/9.2.0.1.0)
(SID_NAME = dss)
)
)
==============================
# TNSNAMES.ORA Network Configuration File: /u10/app/ORACLE/product/9.2.0.1.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
DSS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xx.53)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dss)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xx.53)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
==========================
-
Isn't that just auto-registration, since the listener is on default 1521
"False data can act only as a distraction. Therefore. I shall refuse to perceive you." - Bomb #20
-
I believe it is in a network level-TCP/IP Protocol(Network Adapter Device driver)
---------------
-
listener.ora defines where the listener listens (host and port) actually I belive as long as the request reaches the listener process, it does not mather how that happens. So even if the request comes to the listener via other IP address, the listener serves it
-
listener is configured thru static file called listener.ora. Either of the I.P. will always be valid because it is already resolved/binded from the Network Layer of the server system. So Oracle/SQLNet-*APPLICATION LAYER*-( always receive a valid I.P. as long as it was resolve from the NETWORK LAYER. If it's not a valid I.P-that's when sqlnet.log/listener.log generates error.
---------------
-
Exactly, that's what I ment, just reydp explained it better
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|