Re: Oracle8i---MTS Not working

Hi Sean,
A few notes.
From your reply it definitely appears MTS is not running. I know remember a 'chicken and egg' situation I have always been stumbling with using mTS: which one should you start first the database or the listener. It's the other way around, and I don't remember whether I started the listener first or the database. In your case: try reversing the process. There doesn't seem to be anything wrong with your configuration. As a last resort you can change the trace level in both sqlnet.ora and listener.ora from OFF into 16. This will dump debugging info intro two trace files. I have some experience in reading them, and I hope it is not necessary. If it is necessary, zip them up using winzip, they can be huge!

Hth,
Sybrand Bakker, Oracle DBA

Sean Zhang wrote in message ...
>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 - 16:07:39 CDT