Home -> Usenet -> comp.databases.oracle -> Oracle Dispatcher problems

Oracle Dispatcher problems

From: Ottar Kvindesland <ok_at_achilles.no>
Date: Sat, 21 Jul 2001 21:13:21 GMT
Message-ID: <GSkX6.3656$Q8.102042_at_juliett.dax.net> 






I have a PHP/Apache installation on my Win 2k desktop connected to an Oracle
database.


The database has the dispatcher running as seen below.
To log in to Oracle I use OCIPLogon ($user, $pwd, $host).
Still, I get a db-reconnect for every time I access my PHP script.



I am not convinced the dispatcher is running properly/used correctly.



How do I check and fix this ?




Thanks


Ottar






SQL> select * from v$dispatcher;


NAME





NETWORK






PADDR    STATUS           ACC  MESSAGES     BYTES    BREAKS     OWNED
CREATED      IDLE      BUSY
-------- ---------------- --- --------- --------- --------- --------- ------


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


LISTENER CONF_INDX



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


D000


(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=W2K-ORASRV-1.achilles.no)(PORT=102


7))(PRESENTATION=oracle.


aurora.server.SGiopServer)(S

02C0FC30 WAIT             YES         0         0         0         0
0    124787         0
       0         0




D001


(ADDRESS=(PROTOCOL=tcp)(HOST=W2K-ORASRV-1.achilles.no)(PORT=1029))



02C0FF50 WAIT             YES       281     48048         0         3
3    124609       148
       0         1


Received on Sat Jul 21 2001 - 23:13:21 CEST












Original text of this message