Re: Oracle8, MTS, Linux, huh?

From: John P. Higgins <jh33378_at_deere.com>
Date: Thu, 01 Oct 1998 21:15:31 -0500
Message-ID: <36143742.16847FBF@deere.com>

Do the users specify the TNS service-name to connect?

Bjorn Borud wrote:

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"
  FROM v$session
  ORDER BY process;

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@guardian.no>       | "The Net interprets censorship
 <URL:http://borud.priv.no/>           | as damage and routes around it."
 UNIX person, one of "them"            |         - John Gilmore

  Received on Thu Oct 01 1998 - 21:15:31 CDT