Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> second set of eyes needed - db not registering nor getting dispatchers for shared server
Platform: Oracle 9.2 on Solaris 5.9
Recently started getting problems on a dev db of maxing out 'processes.' Made the decision to enable shared server, so added 'dispatchers' init parm, fiddled with shared pool and large pool sizes. When this all seemed to check out I replicated the same changes to qa, pre-prod and prod databases and to a set of dev/qa/pre-prod/prod 'sister' db's that live on another net.
All but one of a total of 8 distinct db (and that one is one of the two prod db's) are showing mts dispatchers and shared server connections. The one db is still showing nothing but dedicated connections, and the listener is not reporting anything from dynamic registration.
>From eyballing the init.ora (we're not yet using spfiles on these), sqlnet.ora, and listener.ora files, I found only one difference bet. the 'bad' db, and all the 'good' ones. That was in the listener.ora, where the bad server listed host by ip address, and all the good ones listed by server name, but when I substituted IP address for server name on one of the test servers, restarted the listener and did ALTER SYSTEM REGISTER, the problem did not reproduce. Listener status shows only one 'unknown' service handler (from the specific SID list in listener.ora), and listener services doesnt' show any dispatcers.
Here is the listener config from listener.ora file (masked the ip
address)
$>: cat listener.ora
# LISTENER.ORA Network Configuration File:
/u01/app/oracle/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
#-----------------------------------------------------------------------
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.xx.xx.xxx)(PORT = 1521)(QUEUESIZE=20)) (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)(QUEUESIZE=20)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) )
and the sqlnet.ora file:
$>: cat sqlnet.ora
# SQLNET.ORA Network Configuration File:
/u01/app/oracle/product/9.2.0/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES) and what I believe to be all the relevant parts of init.ora
$>: cat initVITXP01.ora
###########################################
############################################db_domain=WORLD
###########################################
###########################################instance_name=VITXP01
###########################################
###########################################compatible=9.2.0.0.0
###########################################
###########################################processes=200
and the relevant results from SHOW PARAMETERS
$>: sqlplus system
SQL*Plus: Release 9.2.0.1.0 - Production on Mon May 16 20:05:02 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> show parameter
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ circuits integer 2000 cluster_database boolean FALSE compatible string 9.2.0.0.0 db_domain string db_name string VITXP01 dispatchers string (protocol=tcp)(dispatchers=3) global_names boolean FALSE instance_groups string instance_name string VITXP01 instance_number integer 0 local_listener string max_dispatchers integer 5 max_shared_servers integer 20 mts_circuits integer 2000 mts_dispatchers string (protocol=tcp)(dispatchers=3) 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 VITXP01 mts_sessions integer 1995 processes integer 200 remote_listener string service_names string VITXP01 sessions integer 2000 shared_server_sessions integer 1995 shared_servers integer 1 spfile string
Thanks.