OCM_Session1_2_Server-side Network Configuration

最新推荐文章于 2017-07-14 15:05:03 发布
最新推荐文章于 2017-07-14 15:05:03 发布
阅读量3.1k 收藏 1
点赞数
分类专栏： OCM experiment
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/rlhua/article/details/21477125
版权
2. Server-side Network Configuration
 2.1 Create a listener using the default listener name. 
  2.1.1 The TCP/IP protocol will be used for all connections. Use the machine name(not the IP address) for host.  
  2.1.2 This listener will listen on the default port.
  2.1.3 Databases: PROD and EMREP(created later) will be serviced by this listener.
 2.2 Add a second listener , named LSNR2,which will listen on port 1526.Configure this listener to support only automatic instance registrations.
   2.2.1 Set up the PROD instance to automatically register with the LSNR2.
  2.3 Start both listeners.

参考联机文档：
Net Services Reference ==> 7 Listener Parameters (listener.ora)

Example 7-1 shows a listener.ora file for a listener named LISTENER, which is the default name of the listener.

Example 7-1 Example listener.ora File

LISTENER
=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=sale-server)(PORT=1521))
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
SID_LIST_
LISTENER
=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=sales.us.acme.com)
      (ORACLE_HOME=/oracle10g)
      (SID_NAME=sales))
    (SID_DESC=
      (SID_NAME=plsextproc)
      (ORACLE_HOME=/oracle10g)
      (PROGRAM=extproc)))

 2.1 Create a listener using the default listener name. 创建一个监听，使用缺省的监听名字
  2.1.1 The TCP/IP protocol will be used for all connections. Use the machine name(not the IP address) for host.
             使用TCP/IP协议，使用机器名称，不使用IP地址
  2.1.2 This listener will listen on the default port.缺省端口1521
  2.1.3 Databases: PROD and EMREP(created later) will be serviced by this listener.

  • 修改如下：
  • 1.创建一个监听，使用缺省的监听名字LISTENER，使用TCP/IP协议，使用机器名称（不使用IP地址），缺省端口1521.两个数据库PROD和EMREP
[oracle@ocm1 ~]$ hostname
ocm1.localdomain
[oracle@ocm1 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/10.2.0/db_1

[root@ocm1 ~]#   su - oracle
[oracle@ocm1 ~]$   cd $ORACLE_HOME/network/admin
[oracle@ocm1 admin]$ ll
total 8
drwxr-x--- 2 oracle oinstall 4096 Mar 16 19:17 samples
-rw-r----- 1 oracle oinstall  172 Dec 26  2003 shrept.lst

[oracle@ocm1 admin]$   vi listener.ora 
LISTENER=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL= tcp)(HOST= ocm1.localdomain)(PORT= 1521))
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME= PROD)
      (ORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME= PROD))
    (SID_DESC=
      (GLOBAL_DBNAME= EMREP)
      (ORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME= EMREP))
    (SID_DESC=
      (SID_NAME=plsextproc)
      (ORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM=extproc)))
~
"listener.ora" 19L, 557C written                                                                                       
[oracle@ocm1 admin]$ 

  • 2.启动刚创建的缺省监听
[oracle@ocm1 admin]$  lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-MAR-2014 12:05:33

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                18-MAR-2014 12:05:33
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "EMREP" has 1 instance(s).
  Instance "EMREP", status UNKNOWN, has 1 handler(s) for this service...
Service "PROD" has 1 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
Service "plsextproc" has 1 instance(s).
  Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@ocm1 admin]$ 


 2.2 Add a second listener , named LSNR2,which will listen on port 1526.Configure this listener to support only automatic instance registrations.
            再配置一个监听，名字叫LSNR2，端口是1526,只支持动态监听。


  • 3.追加内容，监听名称为LSNR2，端口为1526，并启动监听LSNR2
这里动态监听即为在listener名称下面没有SID_LIST_LISTENER，注意下面的端口和KEY（与上面的LISTENER的KEY不同）。


[oracle@ocm1 admin]$ vi listener.ora 
LISTENER=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521))
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=PROD)
      (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME=PROD))
    (SID_DESC=
      (GLOBAL_DBNAME=EMREP)
      (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME=EMREP))
    (SID_DESC=
      (SID_NAME=plsextproc)
      (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM=extproc)))

LSNR2=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1526))
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc1))))
~
~
~
~
"listener.ora" 25L, 712C written         

    
  2.2.1 Set up the PROD instance to automatically register with the LSNR2.
            将PROD实例自动注册到LSNR2。

  • 4.将PROD实例动态注册到LSNR2中。
这里即是修改local_listener的参数。

SQL> conn /as sysdba
Connected.
SQL> 
SQL> show parameter local

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string
log_archive_local_first              boolean     TRUE

参考联机文档：
Reference ==> LOCAL_LISTENER参数

LOCAL_LISTENER

PropertyDescription
Parameter type String
Syntax LOCAL_LISTENER = network_name
Default value (ADDRESS = (PROTOCOL=TCP)(HOST=hostname)(PORT=1521)) where hostname is the network name of the local host.
Modifiable ALTER SYSTEM
Basic No

LOCAL_LISTENER specifies a network name that resolves to an address or address list of Oracle Net local listeners (that is, listeners that are running on the same machine as this instance). The address or address list is specified in the TNSNAMES.ORA file or other address repository as configured for your system.


SQL> alter system set local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=ocm1.localdomain)(PORT=1526))';

System altered.

SQL> show parameter local


NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

local_listener                       string      (ADDRESS = (PROTOCOL=TCP)(HOST

                                                 =ocm1.localdomain)(PORT=1526))

log_archive_local_first              boolean     TRUE

SQL> 

  • 5.启动LSNR2监听

[oracle@ocm1 ~]$ lsnrctl status lsnr2

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-MAR-2014 13:01:03

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias                     lsnr2
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                18-MAR-2014 12:31:26
Uptime                    0 days 0 hr. 29 min. 36 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@ocm1 ~]$ 

  • 6.如果此时查不到PROD，则需要在SQL中再注册一下：
[oracle@ocm1 ~]$ lsnrctl status lsnr2

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-MAR-2014 13:02:58

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias                     lsnr2
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                18-MAR-2014 13:02:09
Uptime                    0 days 0 hr. 0 min. 49 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1)))
The listener supports no services
The command completed successfully

则在SQL中再注册一下：

SQL>   alter system register;

System altered.

再来查看状态：

[oracle@ocm1 ~]$ lsnrctl status lsnr2

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-MAR-2014 13:04:20

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias                     lsnr2
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                18-MAR-2014 13:02:09
Uptime                    0 days 0 hr. 2 min. 11 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/lsnr2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1)))
Services Summary...
Service "PROD" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@ocm1 ~]$ 


  2.3 Start both listeners.
之前两个监听都已经启动。
 

Riveore
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
OCM_Session1_4_Client-side Network configuration
一抹曦阳-Oracle
03-18 3659
4. Client-side Network configuration  4.1 Create the client-side network configuration files providing connect descriptors to your databases using local naming and easy connect methods.   4.1.1 The 
OCM_Session1_3_Shared Server Configuration
一抹曦阳-Oracle
03-18 3224
3. Shared Server Configuration  3.1 Configure the PROD database to support up to 300 sessions, reserving 100 for dedicated connections.   3.2 Configure the PROD database to support.    3.2.1 Defaul
OCM考试实验-Skillset1----Network configuration
RookieDBA的博客
07-14 631
Questition:3. Server-sid Network Configuration 3.1 Create a listener using the default listener name. 3.2 The TCP/IP protocol will be used for all connectionps,Use the machine name (not
Oracle LISTENER监听文件参数详解及Lsnrctl命令
csh159的专栏
05-29 1199
<br /># listener.ora Network Configuration File: F:/oracle/product/10.2.0/db_1/network/admin/listener.ora<br /># Generated by Oracle configuration tools.<br />SID_LIST_LISTENER =<br />  (SID_LIST =<br />    (SID_DESC =<br />      (SID_NAME = PLSExtProc)<br
ocm---考试内容一Server Configuration
cuipeng3659的博客
03-07 91
Server Configuration [] Create the database [] Determine and set sizing parameters for databas...
LCD.rar_OCM12864-9_ocm12864_visual c
09-23
2. **字库集成**：由于驱动不包含字库，需要找到与OCM12864兼容的字库文件，并将其正确加载到程序中，以便驱动能够解析和显示文本。 3. **初始化和控制**：通过`LCD.h`中的函数调用来初始化显示屏，并进行后续的...
ocm.cankaochengxu.rar_OCM12864-9_ocm12864_ocm12864-1_ocm12864-2
09-22
标题中的"ocm.cankaochengxu.rar_OCM12864-9_ocm12864_ocm12864-1_ocm12864-2"表明这是一个关于OCM12864的参考资料压缩包，其中包含了不同版本的OCM12864程序或模块。OCM12864通常指的是一个128x64像素的图形显示...
ADS.rar_ocm12232_ucos_ucos ads_ucos-ii_ucos移植
09-23
2. **中断服务例程(ISRs)**：中断是实时系统中的关键部分，需要为OCM12232上的每个可服务中断编写相应的ISR。这些ISRs必须是实时且高效，同时遵守uCOS-II的中断管理规则，如使用信号量或消息队列进行上下文切换。 3...
OCM.rar_OCM Java_oracle_oracle ocm
09-19
**Oracle Certified Master (OCM)** 是Oracle公司针对其数据库产品推出的最高级别的专业认证，它证明了持有者在Oracle数据库管理、性能优化、故障排查等方面具备高级技术和专业知识。OCM认证对于那些希望在Oracle...
yejin.rar_OCM12864-9_ks0107_lcd ks0107_ocm12864
09-14
《OCM12864液晶显示模块与KS0107控制器详解》 OCM12864液晶显示模块在嵌入式系统和工业设备中广泛应用，它以其高清晰度和灵活的显示能力而备受青睐。这个128×64像素的点阵型液晶显示器能够展示丰富的字符和图形...
EXP-00091和IMP-00010解决办法
热门推荐
一抹曦阳-Oracle
03-27 1万+
在session4的4小题需要用到SH.COUNTRIES表，而手工建库时，这个SH用户没有这个表，就想着将别处的这个表拷贝过来。 原来导出表的库：database ORACLE_SID=TEST0221 版本： 11.2.0.4 需要导进的库：database ORACLE_SID=PROD 版本：10.2.0.1 因为字符集的问题，出现了EXP-00091的错误 因为数据库版
OCM实验目录
一抹曦阳-Oracle
03-29 1万+
OCM实验目录     环境准备   http://blog.csdn.net/rlhua/article/details/21370431 session0   http://blog.csdn.net/rlhua/article/details/21475621 session1 1.Database
OCM_环境准备
一抹曦阳-Oracle
03-17 4879
虚拟机：VirtualBox-4.3.8 虚拟机里装的OS：OracleLinux-R5-U7-Server-i386 内存：1024MB 一、配置本地yum环境 1.创建介质装载目录/media/disk: [root@ocm1 /]# pwd / [root@ocm1 /]# mkdir /media/disk 2.插入OEL DVD光盘 3.
OCM_Session7_5_修改/etc/security/limits.conf和 /etc/pam.d/login和/etc/profile
一抹曦阳-Oracle
03-23 4745
五、修改/etc/security/limits.conf和 /etc/pam.d/login和/etc/profile   这个在OCM环境已经配置好。 参考官方文档：http://docs.oracle.com/cd/B19306_01/install.102/b14203/prelinux.htm To increase the shell limits:
OCM_Session1_1_Database Setup and Undo Management
一抹曦阳-Oracle
03-18 3967
TIMES: 45 minutes  1. Database Setup and Undo Management  1.1 Run the minimum required scripts to complete the basic configuration of the PROD database. 1.2 Set up automatic undo management in
OCM_session0手动建库实验
一抹曦阳-Oracle
03-18 3890
Section 0 :创建数据库(即手动建库) 1. Create a database the sid name is PROD 2. Don't run the Script catalog.sql and catproc.sql 参考联机文档： Reference ==> Basic Initialization Parameters http://docs.ora
OCM_Session4_3_Oracle_Loader External Tables
一抹曦阳-Oracle
03-27 3670
3. Oracle_Loader External Tables 3.1 In the scripts directory, you will find prod_master.dat and prod_master.ctl. Using the information found in these files, create an external table names PROD_MASTER
OCM_Session7_4_修改内核配置文件/etc/sysctl.conf
一抹曦阳-Oracle
03-23 3269
四、修改内核配置文件--两个节点都要执行   这个在OCM环境已经配置好 参考官方文档：http://docs.oracle.com/cd/B19306_01/install.102/b14203/prelinux.htm To view the current value specified for these kernel parameters, and t
通过stc控制OCM240128-1代码
最新发布
05-25
首先，需要了解OCM240128-1的通讯协议，然后使用STC单片机进行编程控制。 OCM240128-1的通讯协议一般有两种：串行接口和并行接口。串行接口通讯速度较慢，但是只需要少量的引脚，比较适合单片机控制；并行接口通讯...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值