a problem Multithreaded server

From: DaMan <jeffc_at_sympatico.ca>
Date: Tue, 27 May 2003 21:04:25 -0400
Message-ID: <c718dv4bq129m22loj00m561td9avh2478_at_4ax.com>

I am studying for the last Oracle 8i OCP exam (Network Admin) and I am having trouble with one of my servers on a Linux box.

Ther server is an 8.1.6 database on a Rehdat 7.3 system that I use for experimentation and studying for the exam (I know, I know, I should be running 8.1.7 but installing it on a RH 7.x system is asking for pain).

I have the server setup with the following in the init.ora;

---

mts_dispatchers = "(PROTOCOL=TCP)(DISP=2)(mul=OFF)(pool=OFF)"
mts_servers = 3
mts_max_servers = 5
--------------------------

my listener.ora looks like this;

---

SAVE_CONFIG_ON_STOP_LISTENER = TRUE LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = westley)(PORT = 1521))
    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = lin1test)
(ORACLE_HOME = /dbase/oracle)
(SID_NAME = lin1test)

    )
    (SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /dbase/oracle)

    )
  )

---

when looking at the services in LSNRCTL it looks like this;

LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) Services Summary...
  PLSExtProc has 1 service handler(s)     DEDICATED SERVER established:0 refused:0

      LOCAL SERVER
  lin1test              has 1 service handler(s)
    DEDICATED SERVER established:1 refused:0
      LOCAL SERVER
  lin1test              has 3 service handler(s)
    DISPATCHER established:0 refused:0 current:0 max:254 state:ready
      D001 <machine: westley, pid: 23843>


      (ADDRESS=(PROTOCOL=tcp)(HOST=westley)(PORT=32989))


    DISPATCHER established:0 refused:0 current:0 max:254 state:ready
      D000 <machine: westley, pid: 23841>


      (ADDRESS=(PROTOCOL=tcp)(HOST=westley)(PORT=32988))


    DEDICATED SERVER established:0 refused:0
      LOCAL SERVER

The command completed successfully

What looks odd to me is the first lin1test dedicate server and then the dispatchers. When I setup a similar database (this time using 8.1.7) on a Win2000 box with the a similar mts setup I can connect to a shared session. The services in LSNRCTL on the new test system looks like this;

LSNRCTL> services
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tetra)(PORT=1521))) Services Summary...
  PLSExtProc has 1 service handler(s)     DEDICATED SERVER established:0 refused:0

      LOCAL SERVER
  TETRA         has 3 service handler(s)
    DEDICATED SERVER established:0 refused:0
      LOCAL SERVER
    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
      D001 <machine: TETRA, pid: 456>


      (ADDRESS=(PROTOCOL=tcp)(HOST=tetra)(PORT=1041))


    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
      D000 <machine: TETRA, pid: 852>


      (ADDRESS=(PROTOCOL=tcp)(HOST=tetra)(PORT=1039))

The command completed successfully

There is only a dedicated server for the local IPC connection, and one for the TCP network connection. I think I have configured something wrong in the listener.ora file for the lin1test. I can't run Net8 on that machine either becuase oracle's java interface doesn't like to run on Rhat 7.x systems (and I would rather not go through the pain of trying to make it work). Received on Wed May 28 2003 - 03:04:25 CEST