Re: Oracle 8.0.6.2 MTS configuration..need help?

On 8 Aug 2002 17:01:16 -0700, dominica_l_at_yahoo.com (Dominica Leung) wrote:

>Hi All,
>
>I am trying to setup MTS on oracle 8.0.6.2 (32 bits)
>on Solaris 2.6 platform.
>
>My initORACLE_SID.ora is like:
>-------------------
>mts_dispatchers="(ADDRESS=(HOST=db1.company1.com)(PORT=1723)(PROTOCOL=TCP))"
>mts_max_dispatchers=10
>mts_servers=1
>mts_max_servers=8
>
>---------------------
>My listener.ora is like:
>-----------------------------
>LISTENER3 =
> (ADDRESS_LIST =
> (ADDRESS= (PROTOCOL= TCP)(Host= db1.company1.com)(Port= 1523))
> )
>SID_LIST_LISTENER3 =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME= db1.company1.com)
> (ORACLE_HOME= /company1/oracle/product/8.0.6)
> (SID_NAME = USRDB1)
> )
> )
>----------------------
>STrange thing is:
>
>When I do a test connection by sqlplus testuser/testuser_at_WHATEVER
>
>and then I do a
>select server, username from V$session where username = 'testuser',
>
>it says "DEDICATED".
>
>I just don't get it.
>
>WHen I run this command: lsnrctl services:
>
>--------
>LSNRCTL for Solaris: Version 8.0.6.2.0 - Production on 08-AUG-2002 23:57:49
>
>(c) Copyright 1999 Oracle Corporation. All rights reserved.
>
>Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
>TNS-12224: TNS:no listener
> TNS-12541: TNS:no listener
> TNS-12560: TNS:protocol adapter error
> TNS-00511: No listener
> Solaris Error: 2: No such file or directory
>Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=db1.company1.com))
>Services Summary...
> DB2 has 1 service handler(s)
> DEDICATED SERVER established:0 refused:0
> LOCAL SERVER
> USRDB1 has 1 service handler(s)
> DISPATCHER established:0 refused:0 current:0 max:254 state:ready
> D000 <machine: db1.company1.com, pid: 3096>
> (ADDRESS=(PROTOCOL=tcp)(HOST=203.168.2.2)(PORT=1723))
>The command completed successfully
>
>-----------------------
>
>Basically from the lsnrctl service command,
>I saw "USRDB1", the one I care about, has a DISPATCHER running??
>
>I did read Oracle's admin guide and
>oracle's certification exam book about how to set up MTS,
>and also try to find whether Oracle has a DOC # for configuration
>of MTS on 8.0.6.2.
>
>I only find the one for 8.1.7.
>
>Just quite confuse now.
>
>Thanks in advance,
>
>
>Dominica

1 When setting up the listener you need to restart the listener and bounce the database (in that order)
2 in your case you need to refer to port 1723 in your client tnsnames.ora
3 The output of your lnsrctl services doesn't match listener.ora. You don't have multiple listener.ora's floating around do you? You seem to have multiple listeners defined but your listener.ora shows only one, listener3. You lnsrctl command is implicitly referring to the listener listener. In short, your sqlnet configuration looks quite messy and we don't have yet all the gory details.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Aug 08 2002 - 23:45:40 CDT