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