Oracle学习笔记之第六节网络介绍及配置,会话

前端之家收集整理的这篇文章主要介绍了Oracle学习笔记之第六节网络介绍及配置,会话前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
@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: 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@提示:crossdver软件可以让WINDOWNS程序装在linux上

猜你在找的Oracle相关文章