Re: Need help on MTS configuration

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Tue, 26 Oct 2004 15:37:18 -0400
Message-ID: <FGxfd.207$dq4.10985@tor-nn1.netcom.ca>

Howard,

Yes, The INSTANCE_NAME has to be set otherwise the instance name is registered as "@" by the listener.
Even if ORA_SID (the logical name that does the same job as the Unix variable ORACLE_SID) is set.

        $ lsnrctl service
          @             has 1 service handler(s)
            DEDICATED SERVER established:0 refused:0
          LOCAL SERVER

and...
$ sqlplus user/pwd_at_inercs

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Oct 26 15:30:37 2004

ERROR:
ORA-12500: TNS:listener failed to start a dedicated server process

What I have now is this:

INIT.ORA

db_name = "INERCS"
instance_name = "INERCS"
db_domain = world
service_names = INERCS.WORLD

mts_dispatchers = "(PROTOCOL=TCP)(DISPATCHERS=1)"
mts_max_dispatchers = 3
mts_servers = 4

local_listener = INERCS

TNSNAMES.ORA

MTS_INERCS.WORLD =
(DESCRIPTION =

    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = HELIOS)(PORT = 1526))     )
    (CONNECT_DATA =
      (SERVICE_NAME = INERCS.WORLD)
    )
  )

INERCS.WORLD =
(DESCRIPTION =

    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = HELIOS)(PORT = 1526))     )
    (CONNECT_DATA =

      (SERVICE_NAME = INERCS.WORLD)
      (SERVER = DEDICATED)

)
)

Btw, I noticed that the alias names must also have the .WORLD in tnsnames.ora (not just the service names need it). What's all about the domains? What purpose do they serve? Certainly here they're just cumbersome.

As for the hanging problem, the TAR is still in "Work In Progress" status. I was told there are many bugs in 8i that will not be fixed (even if the desupport date is officially 2 months from now). If nothing else works I will try to use a 9.2 listener and see if that helps. I'm waiting for another Oracle fix before I can (re)install 9i. I can't upgrade my db right now, must wait for the vendor software to be upgraded as well (soon).

Thanks !

-- 
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Howard J. Rogers" <hjr_at_dizwell.com> a écrit dans le message de
news:417e9f75$0$21703$afc38c87_at_news.optusnet.com.au...
> Syltrem wrote:
>
> > LOCAL_LISTENER=ZZZRCS
> > MTS_DISPATCHERS="(PROTOCOL=TCP)(DISPATCHERS=1)"
> >
> > Works great !
> > Many thanks.
> >
>
>
> Crikey! That's a short reply to an extremely long-winded post, but
whatever:
> I'm glad it's sorted!!
>
> Just out of interest: are you still saying that INSTANCE_NAME is
compulsory
> on OpenVMS?  Or has that resolved itself now, too? It's just that I'd like
> to not mislead any more OpenVMSers in the future if at all possible.
>
> :-)
> HJR

Received on Tue Oct 26 2004 - 14:37:18 CDT