Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Location
    Champaign, Illinois USA
    Posts
    8

    Question Unanswered: Need help understanding Oracle Network Activity

    Hi,

    We are running Oracle 8.0.5 (I know...) on Sun Solaris using Oracle Net 8.1.7. I noticed recently some strange network activity involving oracle processes. Namely that there are many processes listening on strange ports. I issued a "lsof" command and found the following:

    --------------------------------------------------------------------
    > lsof -i tcp:32773
    COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
    oracle 601 oracle 16u IPv4 0x300059a2b90 0t0 TCP *:32773 (LISTEN)

    > ps -fp 601
    UID PID PPID C STIME TTY TIME CMD
    oracle 601 1 0 May 08 ? 0:06 ora_dbw0_LIBR
    --------------------------------------------------------------------

    So I'm confused. In our listener.ora we are using the default port 1521, so Why would the DBwriter be listing on a port like 32773 ???

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Port 1521 is the port on which the Oracle listener listens for requests to the DB.
    After getting the request the listener passes it onto Oracle itself which decides which unique port sebsequent communications will occur with the client which initiated the request. In other words each client "talk" to the DB server via its own unique port# (assuming MTS is not involved).
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2004
    Location
    Champaign, Illinois USA
    Posts
    8
    Thanks for the reply... I can understand that situation for a server process, but isn't there something wrong if the DBW0 process is listening on a port?
    Why would the DB Writer need to talk to an oracle client?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Why would the DB Writer need to talk to an oracle client?
    I contend that you are leaping to a conclusion, without any real supporting fact(s).
    Rhetorical questions.....
    1) Is there any actual network traffic going in/out of this port?
    2) EXACTLY what is the other entity (client, server process, etc.?) that is actually exchanging packets with this DB writer process?
    All you have actually observed is an open port.
    Then you started speculating and reaching conclusions which have no factual basis; rather than trying to obtain answers to your own questions which are based upon observable and measurable envidence.
    Simply running snoop should provide you with some answers;
    which may or may not match what you initially thought is/was happening.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Mar 2004
    Location
    Champaign, Illinois USA
    Posts
    8
    Well, here is what makes me wonder:


    Take a look at this ( second column is process ID):
    -------------------------------------------------------
    eistestuc => lsof -i|grep oracle
    tnslsnr 544 oracle 6u IPv4 0x30005a2ab98 0t0 TCP *:* (IDLE)
    tnslsnr 544 oracle 8u IPv4 0x300051d4b80 0t0 TCP *listen (LISTEN)
    oracle 599 oracle 5u IPv4 0x30005a2b098 0t0 TCP *:* (IDLE)
    oracle 599 oracle 7u IPv4 0x30005a20560 0t0 TCP *:* (IDLE)
    oracle 599 oracle 12u IPv4 0x30005a20060 0t0 TCP *:32771 (LISTEN)
    oracle 599 oracle 16u IPv4 0x300059a2e10 0t0 TCP *:32772 (LISTEN)
    oracle 599 oracle 18u IPv4 0x30005a61e68 0t0 TCP *:* (IDLE)
    oracle 601 oracle 5u IPv4 0x30005a2b098 0t0 TCP *:* (IDLE)
    oracle 601 oracle 7u IPv4 0x30005a20560 0t0 TCP *:* (IDLE)
    oracle 601 oracle 12u IPv4 0x30005a20060 0t0 TCP *:32771 (LISTEN)
    oracle 601 oracle 16u IPv4 0x300059a2b90 0t0 TCP *:32773 (LISTEN)
    oracle 603 oracle 5u IPv4 0x30005a2b098 0t0 TCP *:* (IDLE)
    oracle 603 oracle 7u IPv4 0x30005a20560 0t0 TCP *:* (IDLE)
    oracle 603 oracle 12u IPv4 0x30005a20060 0t0 TCP *:32771 (LISTEN)
    oracle 603 oracle 16u IPv4 0x30005a202e0 0t0 TCP *:32774 (LISTEN)
    oracle 605 oracle 5u IPv4 0x30005a2b098 0t0 TCP *:* (IDLE)
    oracle 605 oracle 7u IPv4 0x30005a20560 0t0 TCP *:* (IDLE)
    oracle 605 oracle 12u IPv4 0x30005a20060 0t0 TCP *:32771 (LISTEN)
    oracle 605 oracle 16u IPv4 0x300059a2910 0t0 TCP *:32775 (LISTEN)
    oracle 607 oracle 5u IPv4 0x30005a2b098 0t0 TCP *:* (IDLE)
    oracle 607 oracle 7u IPv4 0x30005a20560 0t0 TCP *:* (IDLE)
    oracle 607 oracle 12u IPv4 0x30005a20060 0t0 TCP *:32771 (LISTEN)
    oracle 607 oracle 16u IPv4 0x30005a206a0 0t0 TCP *:32776 (LISTEN)
    oracle 609 oracle 5u IPv4 0x30005a2b098 0t0 TCP *:* (IDLE)
    oracle 609 oracle 7u IPv4 0x30005a20560 0t0 TCP *:* (IDLE)
    oracle 609 oracle 12u IPv4 0x30005a20060 0t0 TCP *:32771 (LISTEN)
    oracle 609 oracle 16u IPv4 0x30005a61828 0t0 TCP *:32777 (LISTEN)
    oracle 611 oracle 5u IPv4 0x30005a2b098 0t0 TCP *:* (IDLE)
    oracle 611 oracle 7u IPv4 0x30005a20560 0t0 TCP *:* (IDLE)
    oracle 611 oracle 12u IPv4 0x30005a20060 0t0 TCP *:32771 (LISTEN)
    oracle 611 oracle 16u IPv4 0x30005a20a60 0t0 TCP *:32778 (LISTEN)
    oracle 613 oracle 5u IPv4 0x30005a2b098 0t0 TCP *:* (IDLE)
    oracle 613 oracle 7u IPv4 0x30005a20560 0t0 TCP *:* (IDLE)
    oracle 613 oracle 12u IPv4 0x30005a20060 0t0 TCP *:32771 (LISTEN)
    oracle 613 oracle 16u IPv4 0x30005a615a8 0t0 TCP *:32779 (LISTEN)
    oracle 615 oracle 5u IPv4 0x30005a2b098 0t0 TCP *:* (IDLE)
    oracle 615 oracle 7u IPv4 0x30005a20560 0t0 TCP *:* (IDLE)
    oracle 615 oracle 12u IPv4 0x30005a20060 0t0 TCP *:32771 (LISTEN)
    oracle 615 oracle 16u IPv4 0x30005a610a8 0t0 TCP *:32780 (LISTEN)
    oracle 617 oracle 5u IPv4 0x30005a2b098 0t0 TCP *:* (IDLE)
    oracle 617 oracle 7u IPv4 0x30005a20560 0t0 TCP *:* (IDLE)
    oracle 617 oracle 12u IPv4 0x30005a20060 0t0 TCP *:32771 (LISTEN)
    oracle 617 oracle 16u IPv4 0x30005a60e28 0t0 TCP *:32781 (LISTEN)
    oracle 619 oracle 5u IPv4 0x30005a2b098 0t0 TCP *:* (IDLE)
    oracle 619 oracle 7u IPv4 0x30005a20560 0t0 TCP *:* (IDLE)
    oracle 619 oracle 12u IPv4 0x30005a20060 0t0 TCP *:32771 (LISTEN)
    oracle 619 oracle 16u IPv4 0x30005a60ba8 0t0 TCP *:32782 (LISTEN)
    oracle 621 oracle 5u IPv4 0x30005a2b098 0t0 TCP *:* (IDLE)
    oracle 621 oracle 7u IPv4 0x30005a20560 0t0 TCP *:* (IDLE)
    oracle 621 oracle 12u IPv4 0x30005a20060 0t0 TCP *:32771 (LISTEN)
    oracle 621 oracle 16u IPv4 0x30005a606a8 0t0 TCP *:32783 (LISTEN)




    -------------------------------------------------

    now look at the oracle system processes:


    ---------------------------------------------
    eistestuc => ps -ef |grep ora_
    oracle 599 1 0 May 08 ? 0:00 ora_pmon_LIBR
    oracle 601 1 0 May 08 ? 0:07 ora_dbw0_LIBR
    oracle 603 1 0 May 08 ? 0:08 ora_dbw1_LIBR
    oracle 605 1 0 May 08 ? 0:07 ora_dbw2_LIBR
    oracle 607 1 0 May 08 ? 0:08 ora_dbw3_LIBR
    oracle 609 1 0 May 08 ? 0:08 ora_dbw4_LIBR
    oracle 611 1 0 May 08 ? 0:08 ora_dbw5_LIBR
    oracle 613 1 0 May 08 ? 0:09 ora_arch_LIBR
    oracle 615 1 0 May 08 ? 0:35 ora_lgwr_LIBR
    oracle 617 1 0 May 08 ? 1:09 ora_ckpt_LIBR
    oracle 619 1 0 May 08 ? 1:17 ora_smon_LIBR
    oracle 621 1 0 May 08 ? 0:00 ora_reco_LIBR


    -----------------------------------------------------------------

    None of these oracle system processes should be listening on an
    associated port from my understanding, but from the lsof output
    and comparing the proccess id, you can see that some do.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •