共享服务器配置

共享服务器配置

在数据库运行时，可启用和关闭共享模式，不用重启数据库，调度进程和共享服务器进程会自动启动和消失。

1.配置服务器端共享模式

alter system set dispatchers='(protocol=tcp)(dispatchers=2)' scope=memory;

alter system set shared_servers=4 scope=memory;

alter system register;

2.查询视图V$PROCESS，确认调度程序及共享服务器已经启动。查找名为SXXX、DXXX的进程

设置后监听状态查询

oracle@RH5x64_[/home/oracle/app/product/11.2.0/db_1/network/admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-JUL-2013 21:01:58

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date                19-JUL-2013 20:26:17

Uptime                    0 days 0 hr. 35 min. 40 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /home/oracle/app/product/11.2.0/db_1/network/admin/listener.ora

Listener Log File         /home/oracle/app/diag/tnslsnr/RH5x64/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Services Summary...

Service "orcl" has 1 instance(s).

  Instance "orcl", status READY, has 3 handler(s) for this service...

Service "orclXDB" has 1 instance(s).

  Instance "orcl", status READY, has 0 handler(s) for this service...

The command completed successfully

oracle@RH5x64_[/home/oracle/app/product/11.2.0/db_1/network/admin]$ lsnrctl 

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-JUL-2013 21:02:06

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> service

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))

Services Summary...

Service "orcl" has 1 instance(s).

  Instance "orcl", status READY, has 3 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:0 refused:0 state:ready

         LOCAL SERVER

      "D000" established:0 refused:0 current:0 max:1022 state:ready

         DISPATCHER

         (ADDRESS=(PROTOCOL=tcp)(HOST=RH5x64)(PORT=43410))

      "D001" established:0 refused:0 current:0 max:1022 state:ready

         DISPATCHER

         (ADDRESS=(PROTOCOL=tcp)(HOST=localhost6.localdomain6)(PORT=32313))

Service "orclXDB" has 1 instance(s).

  Instance "orcl", status READY, has 0 handler(s) for this service...

The command completed successfully

LSNRCTL> 

3.还原专用服务器

alter system set local_listener='' scope=memory;

alter system set service_names='' scope=memory;

alter system set dispatchers='' scope=memory;

alter system set shared_servers=0 scope=memory;

alter system register;