Listener...kind of wierd.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Listener...kind of wierd.

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    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

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Can you post listener.ora and tnsnames.ora (db server and client) files here?

  3. #3
    Join Date
    Oct 2002
    Posts
    284
    # 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)
    )
    )
    ==========================

  4. #4
    Join Date
    Oct 2005
    Location
    Indianapolis
    Posts
    100
    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

  5. #5
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    I believe it is in a network level-TCP/IP Protocol(Network Adapter Device driver)
    ---------------

  6. #6
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    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

  7. #7
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    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.
    ---------------

  8. #8
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    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
  •  



Click Here to Expand Forum to Full Width