当前位置：首页 -> AI编程基础 -> 数据库编程

oracle shared server配置(二)

2015-11-21 01:28:23 · 作者: · 浏览: 9
标签: oracle shared server 配置
_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）客户端配置
?
在 Oracle server 启动listener
?
客户端配置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