Running in both Dedicated and shared Server? 1

[haste]

Is it possibe for an Oracle server to run in both dedicated and shared server mode? I've read that the mode is defined in the tnsnames.ora as below

TEST.world =
 (DESCRIPTION=
  ...  
)
  (CONNECT_DATA = (SERVER_NAME = TEST.us.oracle.com)
  [COLOR=blue](SERVER=DEDICATED)  # <--- server mode [/color]
)
)

 

[sem]

If your server configured as shared you may use both modes. Actually dba is always connected in dedicated mode. You may specify different aliases in your tnsnames file for different types of connection. If you plan to accept only single type from specific machine, you may set this parameter in sqlnet.ora file.

Regards, Dima

http://seminihin.narod.ru

 

[haste]

Thanx heaps Sem,
found this sample tnsnames.ora showing both dedicated n shared server modes used together

TEST =
  (DESCRIPTION =
    (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = <hostname>) (PORT = 1521)))
    (CONNECT_DATA = (SERVICE_NAME = TEST) [COLOR=blue](SERVER = SHARED) [/color])
  )

RMAN =
  (DESCRIPTION =
    (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = <hostname>) (PORT = 1521)))
    (CONNECT_DATA = (SERVICE_NAME = RMAN) [COLOR=blue](SERVER = DEDICATED) [/color])
  )

To force all client connections from the client node to connect to the server with a dedicated server process, set the following in sqlnet.ora

use_dedicated_server=on

in the sqlnet.ora