_prod
oracle 21463 1 0 15:22 ? 00:00:00 ora_lgwr_prod
oracle 21465 1 0 15:22 ? 00:00:00 ora_ckpt_prod
oracle 21467 1 0 15:22 ? 00:00:00 ora_smon_prod
oracle 21469 1 0 15:22 ? 00:00:00 ora_reco_prod
oracle 21471 1 0 15:22 ? 00:00:01 ora_mmon_prod
oracle 21473 1 0 15:22 ? 00:00:00 ora_mmnl_prod
oracle 21475 1 0 15:22 ? 00:00:00 ora_d000_prod
oracle 21477 1 0 15:22 ? 00:00:00 ora_s000_prod
oracle 21485 1 0 15:23 ? 00:00:00 ora_qmnc_prod
oracle 21514 1 0 15:23 ? 00:00:00 ora_q000_prod
oracle 21516 1 0 15:23 ? 00:00:00 ora_q001_prod
oracle 21862 1 0 15:33 ? 00:00:00 ora_smco_prod
oracle 21881 1 0 15:33 ? 00:00:00 ora_w000_prod
oracle 21972 1 0 15:35 ? 00:00:00 ora_d001_prod
oracle 21974 1 0 15:35 ? 00:00:00 ora_d002_prod
oracle 21976 1 0 15:35 ? 00:00:00 ora_d003_prod
oracle 21978 1 0 15:35 ? 00:00:00 ora_d004_prod
oracle 22098 1 0 15:38 ? 00:00:00 ora_s001_prod
oracle 22100 1 0 15:38 ? 00:00:00 ora_s002_prod
oracle 22102 1 0 15:38 ? 00:00:00 ora_s003_prod
oracle 22104 1 0 15:38 ? 00:00:00 ora_s004_prod
oracle 22106 1 0 15:38 ? 00:00:00 ora_s005_prod
oracle 22108 1 0 15:38 ? 00:00:00 ora_s006_prod --server进程启动
oracle 22110 1 0 15:38 ? 00:00:00 ora_s007_prod
oracle 22112 1 015:38 ? 00:00:00 ora_s008_prod
oracle 22114 1 0 15:38 ? 00:00:00 ora_s009_prod
?
3）客户端配置
?
?
客户端配置tnsnames.ora
?
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST=ora11g)(PORT = 1521))
(CONNECT_DATA =
(SEVER = SHARED)
(SERVICE_NAME = prod)
)
)
[oracle@ora11g admin]$ tnsping test
TNS Ping Utility for Linux: Version11.2.0.4.0 - Production on 04-NOV-2015 15:42:39
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST=ora11g)(PORT = 1521)) (CONNECT_DATA = (SEVER =SHARED) (SERVICE_NAME = prod)))
OK (10 msec)
?
测试：
?
[oracle@ora11g admin]$ sqlplus system/oracle@test
SQL*Plus: Release 11.2.0.4.0 Production onWed Nov 4 15:42:49 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise EditionRelease 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Miningand Real Application Testing options
SQL>
SQL> select username,sid,server fromv$session where username is not null;
USERNAME SID SERVER
------------------------------ -------------------
SYS 9 DEDICATED
SYSTEM 12 NONE
SQL> selectusername,SERVER,PROGRAM,OSUSER,MACHINE from v$session where username is notnull;
USERNAME SERVER PROGRAM OSUSER MACHINE
------------------------------ --------------------------------------------------------- ------------------------------------------------------------
SYS DEDICATEDsqlplus@ora11g (TNS V1-V3) oracle ora11g
SYSTEM NONE sqlplus@ora11g (TNS V1-V3) oracle ora11g
?
?
4、监控共享server
?
SQL> col network for a50
SQL> select name ,NETWORK,PADDR,STATUS,ACCEPT ,idle,busy from v$dispatcher;
NAME NETWORK PADDR STATUS ACC IDLE BUSY
------------------------------------------------------ ---------------- ------------------- ---------- ----------
D000(ADDRESS=(PROTOCOL=tcp)(HOST=ora11g)(PORT=33225)) 00000000720BA7A0 WAIT YES 132806 0
D001(ADDRESS=(PROTOCOL=tcp)(HOST=ora11g)(PORT=49380)) 00000000720C2D60 WA