@H_
301_0@ps aux | grep ora_pmon 有几个
数据库服务器就有几个这个进程(进程监控进程和外部打交道)
@H_
301_0@vim
sqlnet.ora 这个可以让
数据库略微安全,让
sqlplus 不能登陆
@H_
301_0@
sqlnet.authentication_services=(none)
@H_
301_0@conn hr/oracle_4U@orcl 产生物理连接逻辑会话
@H_
301_0@host ps 查看终端是哪个
@H_
301_0@! ps
@H_
301_0@然后通过windows的
sqlplus plus 工具连接
@H_
301_0@select * from v_$session s where s.TERMINAL ='pts/2';
@H_
301_0@SADDR 会话地址 SGA共享池,控制新值的存放
@H_
301_0@PADDR 内存地址
@H_
301_0@TADDR 事物地址,旧值地址,如果更改就产生事物,也在共享池
@H_
301_0@这时候lsnrctl stop
@H_
301_0@select salary from employes; 还是连着的,但是进行一个新的连接就发现连不上了
@H_
301_0@lsnrctl
@H_
301_0@help
@H_
301_0@srvctl status listener
@H_
301_0@crs_stat -p | grep lsnr
@H_
301_0@crs_unregister ora.LISTENER.lsnr
@H_
301_0@srvctl add listener -p 15210 手动
增加监听器
@H_
301_0@crsctl stop has
关闭整个集群
@H_
301_0@emctl start dbconsole 启动图形
页面
@H_
301_0@emca 重新
生成图形
页面
@H_
301_0@emca -deconfig dbcontrol db -repos drop
@H_
301_0@emca -config dbcontrol db -repos create
@H_
301_0@配置第2个监听器
@H_
301_0@vim listener.ora
@H_
301_0@srvctl add listener -l l2 -p 15211
@H_
301_0@srvctl start listener -l l2
@H_
301_0@lsnrctl services l2
@H_
301_0@vim tnsnames.ora
@H_
301_0@
sqlplus /nolog
@H_
301_0@alter system register; 强制系统去动态
注册一下
@H_
301_0@动态
注册远程开不了
数据库
@H_
301_0@FOR15212 =
@H_
301_0@(DESCRIPTION =
@H_
301_0@(ADDRESS_LIST=
@H_
301_0@ (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.55)(PORT = 15212))
@H_
301_0@ (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.55)(PORT = 15211))
@H_
301_0@))
@H_
301_0@conn hr/oracle_4U@192.168.0.55:15212/orcl.example.com 简单连接
@H_
301_0@shutdown abort强制
关闭数据库
@H_
301_0@export LANG=en_US
@H_
301_0@netmgr 图形配置网络
页面
@H_
301_0@netca
@H_
301_0@vim tnsnames.ora
@H_
301_0@conn hr/oracle_4U@192.168.0.55:TIGER/rcat.example.com
@H_
301_0@TIGER
负载均衡配置
@H_
301_0@让两个监听器认识lsnrctl services D000......
@H_
301_0@vim listener.ora
@H_
301_0@#动态
注册LISTENER监听器
@H_
301_0@LISTENER =
@H_
301_0@ (DESCRIPTION_LIST =
@H_
301_0@ (DESCRIPTION =
@H_
301_0@ (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 15212))
@H_
301_0@ )
@H_
301_0@ )
@H_
301_0@#动态
注册L2监听器
@H_
301_0@L2=
@H_
301_0@(DESCRIPTION_LIST =
@H_
301_0@ (DESCRIPTION =
@H_
301_0@ (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 15213))
@H_
301_0@ )
@H_
301_0@ )
@H_
301_0@
@H_
301_0@ #使监听器LISTENER静态
注册,使其能够与上面的监听器进行一动一静
@H_
301_0@SID_LIST_LISTENER =
@H_
301_0@ (SID_LIST =
@H_
301_0@ (SID_DESC =
@H_
301_0@ (GLOBAL_DBNAME= rcat.example.com)
@H_
301_0@ (SID_NAME= rcat)
@H_
301_0@ (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/
@H_
301_0@ )
@H_
301_0@ )
@H_
301_0@ )
@H_
301_0@使监听器L2静态
注册,使其能够与上面的监听器进行一动一静
@H_
301_0@SID_LIST_L2 =
@H_
301_0@ (SID_LIST =
@H_
301_0@ (SID_DESC =
@H_
301_0@ (GLOBAL_DBNAME= rcat.example.com)
@H_
301_0@ (SID_NAME= rcat)
@H_
301_0@ (ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1/
@H_
301_0@ )
@H_
301_0@ )
@H_
301_0@ )
@H_
301_0@
vim tnsnames.ora
@H_
301_0@#tnsnames.ora所在的那台客户端认为在15212能找到
注册服务,若不能找到就连不上。
@H_
301_0@RCAT =
@H_
301_0@ (DESCRIPTION =
@H_
301_0@ (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 15212))
@H_
301_0@ (CONNECT_DATA =
@H_
301_0@ (SERVER = DEDICATED)
@H_
301_0@ (SERVICE_NAME = rcat.example.com)
@H_
301_0@ )
@H_
301_0@ )
@H_
301_0@#tnsnames.ora所在的那台客户端认为在15212能找到
注册服务,若不能找到就连不上。
@H_
301_0@RCAT2
@H_
301_0@(DESCRIPTION =
@H_
301_0@ (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 15213))
@H_
301_0@ (CONNECT_DATA =
@H_
301_0@ (SERVER = DEDICATED)
@H_
301_0@ (SERVICE_NAME = rcat.example.com)
@H_
301_0@ )
@H_
301_0@ )
@H_
301_0@ #动态
注册FOR15212
@H_
301_0@FOR15212 =
@H_
301_0@ (DESCRIPTION =
@H_
301_0@ (ADDRESS_LIST=
@H_
301_0@ (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 15212))
@H_
301_0@ (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 15213))
@H_
301_0@ )
@H_
301_0@)
@H_
301_0@#tiger是给win客户端写的条目,
负载均衡静态15212和15213这两个监听端口
@H_
301_0@TIGER =
@H_
301_0@ (DESCRIPTION =
@H_
301_0@ (ADDRESS_LIST =
@H_
301_0@ (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 15212))
@H_
301_0@ (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 15213))
@H_
301_0@ (LOAD_BALANCE = yes )
@H_
301_0@ )
@H_
301_0@ (CONNECT_DATA =
@H_
301_0@ (SERVICE_NAME = rcat.example.com)
@H_
301_0@ )
@H_
301_0@ )
@H_
301_0@
@H_
301_0@ #以上需要使其动态
注册生效,需要进
sqlplus
修改配置
@H_
301_0@. oraenv
@H_
301_0@rcat
@H_
301_0@
sqlplus /nolog
@H_
301_0@conn /as sysdba
@H_
301_0@alter system set local_listener=FOR15212;
@H_
301_0@alter register; #更快的让监听器动态
注册,不然得等待2分钟以上
@H_
301_0@. oraenv
@H_
301_0@+ASM
@H_
301_0@sqplus /nolog
@H_
301_0@conn /as sysdba
@H_
301_0@alter system set local_listener=FOR15212;
@H_
301_0@#以上需要使其动态
注册生效,需要进
sqlplus
修改配置
@H_
301_0@. oraenv
@H_
301_0@rcat
@H_
301_0@
sqlplus /nolog
@H_
301_0@conn /as sysdba
@H_
301_0@alter system set local_listener=FOR15212;
@H_
301_0@alter system register; #更快的让监听器动态
注册,不然得等待2分钟以上
@H_
301_0@. oraenv
@H_
301_0@+ASM
@H_
301_0@sqplus /nolog
@H_
301_0@conn /as sysdba
@H_
301_0@alter system set local_listener=FOR15212;
@H_
301_0@alter system register; #更快的让监听器动态
注册,不然得等待2分钟以上
@H_
301_0@#更快的让监听器动态
注册,不然得等待2分钟以上
@H_
301_0@以上结束后查看LISTENER监听器状态
@H_
301_0@[oracle@station90 admin]$ lsnrctl services LISTENER;
@H_
301_0@LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 05-SEP-2016 23:16:52
@H_
301_0@Copyright (c) 1991,2011,Oracle. All rights reserved.
@H_
301_0@Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=station90.example.com)(PORT=15212)))
@H_
301_0@Services Summary...
@H_
301_0@Service "+ASM" has 1 instance(s).
@H_
301_0@ Instance "+ASM",status READY,has 1 handler(s) for this service... #是动态
注册出现的
@H_
301_0@ Handler(s):
@H_
301_0@ "DEDICATED" established:0 refused:0 state:ready
@H_
301_0@ LOCAL SERVER
@H_
301_0@Service "rcat.example.com" has 2 instance(s).
@H_
301_0@ Instance "rcat",status UNKNOWN,has 1 handler(s) for this service... #是静态
注册出现的
@H_
301_0@ Handler(s):
@H_
301_0@ "DEDICATED" established:0 refused:0
@H_
301_0@ LOCAL SERVER
@H_
301_0@ Instance "rcat",has 1 handler(s) for this service... #是动态
注册出现的
@H_
301_0@ Handler(s):
@H_
301_0@ "DEDICATED" established:0 refused:0 state:ready
@H_
301_0@ LOCAL SERVER
@H_
301_0@Service "rcatXDB.example.com" has 1 instance(s). #是动态
注册出现的隐含服务,XMLDB
@H_
301_0@ Instance "rcat",has 1 handler(s) for this service...
@H_
301_0@ Handler(s):
@H_
301_0@ "D000" established:0 refused:0 current:0 max:1022 state:ready
@H_
301_0@ DISPATCHER <machine: station90.example.com,pid: 12730>
@H_
301_0@ (ADDRESS=(PROTOCOL=tcp)(HOST=station90.example.com)(PORT=44903))
@H_
301_0@The command completed successfully
@H_
301_0@L2监听器的状态
@H_
301_0@[oracle@station90 admin]$ lsnrctl services l2
@H_
301_0@LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 05-SEP-2016 23:19:08
@H_
301_0@Copyright (c) 1991,Oracle. All rights reserved.
@H_
301_0@Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=station90.example.com)(PORT=15213)))
@H_
301_0@Services Summary...
@H_
301_0@Service "rcat.example.com" has 2 instance(s).
@H_
301_0@ Instance "rcat",has 1 handler(s) for this service... #是静态
注册出现的
@H_
301_0@ Handler(s):
@H_
301_0@ "DEDICATED" established:0 refused:0
@H_
301_0@ LOCAL SERVER
@H_
301_0@ Instance "rcat",has 1 handler(s) for this service... #是动态
注册出现的
@H_
301_0@ Handler(s):
@H_
301_0@ "DEDICATED" established:0 refused:0 state:ready
@H_
301_0@ LOCAL SERVER
@H_
301_0@Service "rcatXDB.example.com" has 1 instance(s).
@H_
301_0@ Instance "rcat",has 1 handler(s) for this service... #是动态
注册出现的隐含服务,XMLDB
@H_
301_0@ Handler(s):
@H_
301_0@ "D000" established:0 refused:0 current:0 max:1022 state:ready
@H_
301_0@ DISPATCHER <machine: statio
n90.example.com,pid: 12730>
@H_
301_0@ (ADDRESS=(PROTOCOL=tcp)(HOST=station90.example.com)(PORT=44903))
@H_
301_0@The command completed successfully
@H_
301_0@
小提示:crossdver软件可以让WINDOWNS程序装在linux上