Re: DBCA Connection Options - How to determine an existing server mode?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 29 Mar 2004 10:29:22 +0100
Message-ID: <4067ec73$0$3303$ed9e5944@reading.news.pipex.net>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:40649f6e$0$31901$afc38c87_at_news.optusnet.com.au...
>
> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
> news:40649699$0$24211$cc9e4d1f_at_news.dial.pipex.com...
> > You can investigate parameter settings using show parameter <some
relevant
> > substring> in sqlplus when logged in with a dba account. so for example
to
> > show dump directories you might use show parameter dest. In the case of
> > shared servers the parameters you need are for Multi-Threaded Server or
> MTS.
> > show parameter mts will show you what the relevant parameters are set to
> at
> > the database level.
>
> Well, they would do if Oracle 9 still referred to it as MTS, but since it
> doesn't, it won't!!
>
> In 9i, it's just DISPATCHERS (not mts_dispatchers) and SHARED_SERVERS (not
> mts_shared_servers).
>
> So unfortunately, you have to know the parameters in 9i before you can
check
> on them.

Grrrgh, don't you hate it when that happens. However I claim that my method would still work on 9 even if it is wrong for that release!

SQL*Plus: Release 10.1.0.2.0 - Production on Mon Mar 29 10:24:30 2004

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production

SYS_at_nl9204>show parameter mts

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------------------
---
mts_circuits                         integer     170
mts_dispatchers                      string      (PROTOCOL=TCP)
(SERVICE=nl9204
                                                 XDB)
mts_listener_address                 string
mts_max_dispatchers                  integer     5
mts_max_servers                      integer     20
mts_multiple_listeners               boolean     FALSE
mts_servers                          integer     1
mts_service                          string      nl9204
mts_sessions                         integer     165

SYS_at_nl9204>show parameter disp

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------------------
---
dispatchers                          string      (PROTOCOL=TCP)
(SERVICE=nl9204
                                                 XDB)
max_dispatchers                      integer     5
mts_dispatchers                      string      (PROTOCOL=TCP)
(SERVICE=nl9204
                                                 XDB)
mts_max_dispatchers                  integer     5

SYS_at_nl9204>show parameter shared

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------------------
---
hi_shared_memory_address             integer     0
max_shared_servers                   integer     20
shared_memory_address                integer     0
shared_pool_reserved_size            big integer 2097152
shared_pool_size                     big integer 41943040
shared_server_sessions               integer     165
shared_servers                       integer     1

SYS_at_nl9204>

Howard is correct though that the naming has changed between 8i and 9i. In 10 the obsolete mts_ have disappeared (I just checked).

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Mon Mar 29 2004 - 03:29:22 CST