Re: Oracle8i---MTS Not working

From: Sean Zhang <sean_at_cnfei.com>
Date: Thu, 29 Apr 1999 20:38:58 GMT
Message-ID: <Cr3W2.2231$p17.5955784@firenze.visi.net>

Thank You very much for your help.

Here is more details:
Clients files: in \orawin95\network\admin

                tnsnames.ora  :
# C:\ORAWIN95\NET80\ADMIN\TNSNAMES.ORA Configuration File:C:\ORAWIN95\net80

#\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant

CNF.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oscar)(PORT = 1522))     (CONNECT_DATA = (SID = cnf)(GLOBAL_NAME = cnf.world))   )

            sqlnet.ora
 AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES)
names.default_domain = world
name.default_zone = world

Sever listener.ora in /var/opt/oracle:

   # LISTENER.ORA Configuration
File:/app/oracle/product/8.1.5/network/admin/listener.ora # Generated by Oracle Net8 Assistant

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = cnf))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oscar)(PORT = 1522))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

    )
   )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = cnf.world)
(ORACLE_HOME = /app/oracle/product/8.1.5)
(SID_NAME = cnf)

    )
  )

 BY the way, I think the MTS may not be running, because when I run "lsnrctl services": I got the following:

     connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=CNF))


      (PROTOCOL_STACK=(PRESENTATION=TTC)(SESSIONS=NS)))


      service summary ...
      cnf has 1 service handler(s)
      DEDICATED SERVER established: 1649 refused: 0
      LOCAL SERVER

    The command completed successully.

Again, I really appreciate your help.

Sean Zhang <sean_at_cnfei.com> wrote in message news:9X1W2.2226$p17.5906383_at_firenze.visi.net...

> Hello, Everyone,
>
> Our Oracle 8i Multi-Thread Server is not working, Please give me
> suggestions and advices.
>
> Envrioment:  Oracle 8i EE server  in Sun Enterpirses 3000 with Solaris
2.6.
>                       Clients: Windows95 PCs running Devepoper 2K version
> 2.0
>                       ( SQL net 2.3.4, using a local TNSNAMES.ORA file for
> connection)
> Problems:  Even I configured Oracle Server for MTS,  it's not working
> because
>                     when each user connects to Oracle , I can see an
> additional process
>                      is created for that session. Consequently when I try

to

> list Oracle
>                      processes on the server, I got something like the
> following: (sid is cnf)
>                    > ps -ef |grep oracle
>
>   oracle 13161     1  0 04:07:34 ?        0:00 ora_d000_cnf
>   oracle 13163     1  0 04:07:34 ?        0:00 ora_d001_cnf
>   oracle 13159     1  0 04:07:34 ?        0:00 ora_s000_cnf
>   oracle 13149     1  0 04:07:33 ?        0:06 ora_dbw0_cnf
>   oracle 13157     1  0 04:07:34 ?        0:00 ora_reco_cnf
>   oracle 13153     1  0 04:07:34 ?        0:14 ora_ckpt_cnf
>   oracle 13151     1  0 04:07:33 ?        0:13 ora_lgwr_cnf
>   oracle 13147     1  0 04:07:33 ?        0:51 ora_pmon_cnf
>   oracle 13155     1  0 04:07:34 ?        0:15 ora_smon_cnf
>   oracle 13858     1  0 10:56:38 ?        0:00 oraclecnf (LOCAL=NO)
>   oracle 13756     1  0 10:39:52 ?        0:01 oraclecnf (LOCAL=NO)
>   oracle 14279     1  0 13:08:28 ?        0:01 oraclecnf (LOCAL=NO)
>   oracle 14264     1  0 13:02:17 ?        0:06 oraclecnf (LOCAL=NO)
>   oracle 14158     1  0 12:08:39 ?        0:00 oraclecnf (LOCAL=NO)
>   oracle 14262     1  0 13:02:17 ?        0:01 oraclecnf (LOCAL=NO)
>   oracle 14288     1  0 13:10:37 ?        0:01 oraclecnf (LOCAL=NO)
>   oracle 14394     1  0 13:37:05 ?        0:00 oraclecnf (LOCAL=NO)
>   ------------------------( a lot more oraclecnf processes)
>
>  My configuration file <initcnf.ora>  has the follwing parameters related

to

> MTS:
>        mts_dispatchers="(protocol=TCP)(disp=1)(mul=OFF)(pool=OFF)"
>        mts_max_dispatchers=5
>        mts_serves=1
>        mts_max_servers=20
>  And the listener name is : LISTENER the PORT is 1522 ( the only parameter
> NOT Default).
>
> Suggestions sought:  Becuase Oracle started with dispatchers, I guess the
> problem
>     is that the dispatchers not registered with Oracle. But when I tried
>     to change the parameter mts_dispatchers to:
>
> mts_dispatchers="(protocol=TCP)(disp=1)(list=LISTENER)(mul=OFF)(pool=OFF)"
>   The database can't start saying" Invalid initializaition specifications
> for MTS".
>
> Any advices and suggestions are greatly appreciated.
>
>
> Sean Zhang
> mailto:sean_at_cnfei.com
>
>
>
>
>
>

Received on Thu Apr 29 1999 - 15:38:58 CDT