Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle8, MTS, Linux, huh?
okay, I give up. what's the secret?
I've been trying to make the MTS option work on my Oracle8 but to no avail. I added this to the end of my initGN.ora:
MTS_SERVICE=GN MTS_DISPATCHERS="ipc,1" MTS_SERVERS=1 MTS_MAX_SERVERS=10 MTS_MAX_DISPATCHERS=10
and started the listener before the Oracle server just as the manual told me to. I've also tried to monkey around with the listener to see if there was something wrong in that department, but to no avail. users STILL end up with dedicated servers when I check V$SESSION with
SELECT DISTINCT process "Pid",
substr(username, 1, 10) "Username", osuser "UNIX user", substr(TO_CHAR(logon_time, 'MM-DD HH24:MI'),1,11) "Logon", server "Server"
I still get:
Pid Username UNIX user Logon Server --------- ---------- ------------------------------ ----------- --------- 26589 oracle 10-02 02:11 DEDICATED 26591 oracle 10-02 02:11 DEDICATED 26593 oracle 10-02 02:11 DEDICATED 26595 oracle 10-02 02:11 DEDICATED 26597 oracle 10-02 02:11 DEDICATED 26599 oracle 10-02 02:11 DEDICATED 26856 SYSTEM oracle 10-02 02:22 DEDICATED 26902 BORUD borud 10-02 02:25 DEDICATED 26924 BORUD borud 10-02 02:25 DEDICATED 26947 BORUD borud 10-02 02:25 DEDICATED 26965 BORUD borud 10-02 02:25 DEDICATED 26983 BORUD borud 10-02 02:25 DEDICATED 27269 BORUD borud 10-02 02:27 DEDICATED 27271 BORUD borud 10-02 02:27 DEDICATED 27275 BORUD borud 10-02 02:27 DEDICATED 27277 BORUD borud 10-02 02:27 DEDICATED 27279 BORUD borud 10-02 02:27 DEDICATED 27281 BORUD borud 10-02 02:27 DEDICATED 27283 BORUD borud 10-02 02:27 DEDICATED 27285 BORUD borud 10-02 02:27 DEDICATED 27287 BORUD borud 10-02 02:27 DEDICATED 27290 BORUD borud 10-02 02:27 DEDICATED 27293 BORUD borud 10-02 02:27 DEDICATED 27295 BORUD borud 10-02 02:27 DEDICATED 27304 BORUD borud 10-02 02:27 DEDICATED 27306 BORUD borud 10-02 02:27 DEDICATED 27308 BORUD borud 10-02 02:27 DEDICATED 27310 BORUD borud 10-02 02:27 DEDICATED
what am I missing? :-)
-Bjørn
--
Bjørn Borud <borud_at_guardian.no> | "The Net interprets censorship <URL:http://borud.priv.no/> | as damage and routes around it." UNIX person, one of "them" | - John GilmoreReceived on Thu Oct 01 1998 - 19:35:07 CDT