Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Snehasish.

Asked: July 07, 2010 - 5:13 am UTC

Last updated: November 18, 2019 - 12:18 pm UTC

Version: 10.2.0.2.0

Viewed 10K+ times! This question is

You Asked

Hi Tom,

How can we know that our database is running on shared mode or dedicated mode. Can we configure the database so that we can change the mode according to our need.

Thanks,
Snehasish Das.

and Tom said...

All databases ALWAYS run in "dedicated" mode. It is not really even a "mode", it is a method of connecting.

So, you always have dedicated server connections (you need them to start up and shut down and perform other administrative operations). Dedicated server is NOT optional, it is a fact.

Shared server is configured via network settings and init.ora settings. here is the database setup step by steps:

https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-processes.html#GUID-CCC18A52-E47B-48AA-8811-4E87023DB99D

then, when you connect, you would either use a tns connect string that connects to a share server only connection OR use "server=shared" in the connection string, for example:
ORCL_DS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =<b>
      (SERVER = DEDICATED)</b>
      (SERVICE_NAME = xxxxx)
    )
  )

ORCL_SS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =<b>
      (SERVER = SHARED)</b>
      (SERVICE_NAME = yyyy)
    )
  )

Rating

  (4 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Db parameters

Avinash Kumar, February 21, 2017 - 7:12 pm UTC

Is there any database parameter available which can tell whether a database is in dedicated or shared mode.
Connor McDonald
February 22, 2017 - 1:25 am UTC

It doesn't really work that way, because the *same* database can support both.

You can see how *sessions* are connected via V$SESSION

SQL> select sid, server from v$session;

       SID SERVER
---------- ---------
         1 DEDICATED
         2 DEDICATED
         3 DEDICATED
         4 DEDICATED
         5 DEDICATED
         6 DEDICATED
         8 DEDICATED
        10 DEDICATED
        11 DEDICATED
        13 DEDICATED
        16 DEDICATED
...


Db parameters

Avinash Kumar, February 21, 2017 - 7:12 pm UTC

Is there any database parameter available which can tell whether a database is in dedicated or shared mode.

database connection

syed, February 06, 2018 - 10:27 am UTC

Firstly, thanks for sharing our knowledge. When I initiate a Shared connection to my 10g database, I get the below error:

ERROR:
ORA-12520: TNS:listener could not find available handler for requested type of server
Connor McDonald
February 07, 2018 - 12:25 am UTC

See the link in the original answer.

You need to *configure* shared server before you can use it.

Link in original is 404

Ashif Zubair, November 18, 2019 - 8:25 am UTC

Link to oracle doc. is broken.
Connor McDonald
November 18, 2019 - 12:18 pm UTC

Thanks, we've updated the link

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database