Multithreaded server (and OCI)

From: Igor Sereda <sereda_at_spb.runnet.ru>
Date: 1998/03/25
Message-ID: <3518C17A.435547BB_at_spb.runnet.ru>#1/1


Hello,

I have a problem with multithreaded Oracle configuration.
(Oracle 7.3.2 for Solaris x86).

I configured nearly every MTS_* parameter in init.ora file with two listeners, on protocols IPC and TCP. Further, i configured listeners in listener.ora to listen for TCP and IPC connections.

When i start instance, i see that dispatchers and servers start as they should.
When i use SQL*Plus or other tool to connect to the database it really uses multithreaded architecture, but when i try to connect from a php3 script (which, in fact uses Oracle Call Interface)
Oracle spawns a dedicated server to my frustration.

(It can be clearly seen by ps -ef|grep ora, something like this:

  ... ... ... oracleSID (ADDRESS=(LOCAL=NO)) or
  ... ... ... oracleSID (ADDRESS=(LOCAL=YES)(PROTOCOL=beq)) )

Thanks for any advice.

--
Igor Sereda,
ITC, Russia
Received on Wed Mar 25 1998 - 00:00:00 CET

Original text of this message