Problem setting up shared server on Oracle 9i

We have a problem setting up the shared server it seems. The initialization parameters as queried from 'show parameter' are as follows:

DISPATCHERS      (PROTOCOL=TCP)(DISPATCHERS=40)
SHARED_SERVERS   40
MAX_DISPATCHERS   50
MAX_SHARED_SERVERS  50
SHARED_SERVER_SESSIONS   1495

This, as per theory enables the shared server. But all the users are getting connected only as dedicated. We use localnaming method and the TNSNAMES.ORA file contents are as follows :

MYDS =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = 10.10.10.1)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SERVICE_NAME = MYDS)
    )
  )


When v$session is queried, we see that 'server' column shows DEDICATED.

Help Needed.
LVL 3
mganeshAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Stephen LappinSenior TechnologistCommented:
Try modifying your TNSNAMES.ORA as follows:


MYDS =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = 10.10.10.1)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SERVICE_NAME = MYDS)
    (SERVER=shared)
    )
  )

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mganeshAuthor Commented:
I suppose the default request from clients is for a shared server is available.
Anyway, I did what you said. I get the error,

ORA-12523 TNS:listener could not find instance appropriate for the client connection

0
mganeshAuthor Commented:
Correction to the above post:

I suppose the default request from clients is for a shared server if  available.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Stephen LappinSenior TechnologistCommented:
What is your SID's service name?

Is it MYDS, or MYDS.domain.com

Try adding (SERVICE=MYDS) to your DISPATCHERS setting
0
mganeshAuthor Commented:
We have no DOMAIN_NAME configured.
show parameter domain_name shows null string.

Still, I did what you said. It is the same, I still get connected as dedicated.

(I am connecting through oracle net and not connecting from the same machine as the server)

Also, here is my listener.ora file :

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.1)(PORT = 1521))
      )

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )


    )
  )



SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /san/apps/oracle/920)
      (PROGRAM = extproc)
    )

    (SID_DESC =
      (GLOBAL_DBNAME = MYDS)
      (ORACLE_HOME = /san/apps/oracle/920)
      (SID_NAME = MYDS)
    )
  )
0
mganeshAuthor Commented:
And here is the output of
lsnrctl services


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.1)(PORT=1521)))
Services Summary...
Service "MYDS" has 1 instance(s).
  Instance "MYDS", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:3587 refused:0
         LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
The command completed successfully
0
Stephen LappinSenior TechnologistCommented:
Can you supply the appropraite section from your init.ora please?
0
Stephen LappinSenior TechnologistCommented:
Does your init.ora have the following entry?

DISPATCHERS="(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.1))"
0
mganeshAuthor Commented:
Here is the complete initMYDS.ora file :


##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
 
###########################################
# Cache and I/O
###########################################
db_block_size=16384
db_cache_size=4294967296
db_file_multiblock_read_count=16
max_enabled_roles=148
###########################################
# Cursors and Library Cache
###########################################
open_cursors=450
db_writer_processes=10
###########################################
# Database Identification
###########################################
db_domain=""
db_name=MYDS

log_archive_start=TRUE
log_archive_format="archMYDS%S.arc"
log_archive_dest_1="location=/san/arch/MYDS/"
log_archive_dest_state_1=enable
log_archive_min_succeed_dest=1
 
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/san/apps/oracle/admin/MYDS/bdump
core_dump_dest=/san/apps/oracle/admin/MYDS/cdump
timed_statistics=TRUE
user_dump_dest=/san/apps/oracle/admin/MYDS/udump
 
###########################################
# File Configuration
###########################################
control_files=("/san/apps/oracle/oradata/MYDS/control01.ctl", "/san/usr2/MYDS/control02.ctl", "/san/usr3/MYDS/control03.ctl", "/san/usr4/MYDS/control04.ctl")
 
###########################################
# Instance Identification
###########################################
instance_name=MYDS
 
###########################################
# Job Queues
###########################################
job_queue_processes=10
 
###########################################
# MTS
###########################################
dispatchers="(PROTOCOL=TCP) (DISPATCHERS=40)"
 
###########################################
# Miscellaneous
###########################################
aq_tm_processes=1
compatible=9.2.0.4.0
 
###########################################
# Optimizer
###########################################
hash_join_enabled=TRUE
query_rewrite_enabled=FALSE
star_transformation_enabled=FALSE
 
###########################################
# Pools
###########################################
java_pool_size=104857600
large_pool_size=2147483648
shared_pool_size=1073741824

shared_servers=40

max_shared_servers=50
max_dispatchers=50
###########################################
# Processes and Sessions
###########################################
processes=1100
sessions=1500
###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300
 
###########################################
# Security and Auditing
###########################################
remote_login_passwordfile=EXCLUSIVE
 
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=536870912
sort_area_size=524288
 
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1
 
0
Stephen LappinSenior TechnologistCommented:
Try adding host to DISPATCHERS in init.ora

DISPATCHERS="(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.1))"


0
mganeshAuthor Commented:
I gave the command :

alter system set dispatchers='(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.1))(DISPATCHERS=40)'

I got the error :

ORA-00105: dispatching mechanism not configured for network protocol
(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.1))


0
Stephen LappinSenior TechnologistCommented:
Can you try chaning the init.ora and restarting the instance?
0
mganeshAuthor Commented:
I will do that once the server becomes sort of free and post back. Thanks for the lightening fast replies.
0
vishal68Commented:
try setting the dispatchers as follows

DISPATCHERS=(PROTOCOL=TCP)(DISPATCHERS=40)(LISTENER=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.1)(PORT=1521)))

Then try

HTH
Vishal
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.