OCM_Session1_4_Client-side Network configuration

最新推荐文章于 2022-03-06 15:20:24 发布
最新推荐文章于 2022-03-06 15:20:24 发布
阅读量3.6k 收藏 1
点赞数
分类专栏： OCM experiment
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/rlhua/article/details/21481215
版权
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 
摘要由CSDN通过智能技术生成

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   prod alias should connect to the PROD instance using the   default listener  and always use a   dedicated server connection.
  4.1.2 The   prod_s  alias should connect to the PROD instance using   LSNR2 and use a   shared server connection.
 4.2 The racdb alias should connect to the RACDB service (created later) with a dedicated server connection.
  4.2.1 The RACDB service will be running on your RAC Cluster
 4.3 The emrep alias should connect to the EMREP instance (created later) wiht a dedicated server connection. 

  •  4.1 Create the client-side network configuration files providing connect descriptors to your databases using local naming and easy connect methods.
参考联机文档：
Net Services Reference ==>5 Profile Parameters (sqlnet.ora)

NAMES.DIRECTORY_PATH

Purpose

Use the parameter NAMES.DIRECTORY_PATH to specify the order of the naming methods used for client name resolution lookups.

Default

NAMES.DIRECTORY_PATH=(tnsnames, onames, hostname)

Values

Table 5-1 NAMES.DIRECTORY_PATH Values

Naming Method ValueDescription
tnsnames (local naming naming method) Set to resolve a net service name through the tnsnames.ora file on the client.

See Also: Oracle Database Net Services Administrator's Guide

ldap (directory naming naming method) Set to resolve a database service name, net service name, or net service alias through a directory server.

See Also: Oracle Database Net Services Administrator's Guide

ezconnect or hostname (easy connect naming or host naming method) Select to enable clients to use a TCP/IP connect identifier, consisting of a host name and optional port and service name.

See Also: Oracle Database Net Services Administrator's Guide

cds (CDS external naming method) Set to resolve an Oracle database name in a Distributed Computing Environment (DCE) environment.

See Also: Oracle Database Advanced Security Administrator's Guide

nis (Network Information Service (NIS) external naming method) Set to resolve service information through an existing NIS.

See Also: Oracle Database Net Services Administrator's Guide


NAMES.DIRECTORY_PATH=(tnsnames,  ezconnect)


创建 sqlnet.ora，内容如下：
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

[oracle@ocm1 admin]$ vi sqlnet.ora
MES.DIRECTORY_PATH=(tnsnames, ezconnect)

~
"sqlnet.ora" [New] 1L, 41C written                                                                                              
[oracle@ocm1 admin]$ 



监听重启，验证：
                                                                                            
[oracle@ocm1 admin]$   lsnrctl stop 

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-MAR-2014 13:40:48

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521)))
The command completed successfully
[oracle@ocm1 admin]$  lsnrctl start

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

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 13:40:59
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]$   lsnrctl stop lsnr2

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-MAR-2014 13:41:07

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1526)))
The command completed successfully
[oracle@ocm1 admin]$  lsnrctl start lsnr2

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-MAR-2014 13:41:21

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/lsnr2.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1526)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1)))

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:41:21
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/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
[oracle@ocm1 admin]$ 

重新注册一下
SQL> alter system register
  2  ;

System altered.

[oracle@ocm1 admin]$ cat sqlnet.ora 
MES.DIRECTORY_PATH=(tnsnames, ezconnect)


验证easy 连接
CONNECT   username/ password@ [//]host[: port][/ service_name]

验证，可以连接
SQL> connect system/oracle@//ocm1.localdomain:1521/PROD
Connected.

  •   4.1.1 The prod alias should connect to the PROD instance using the default listener and always use a dedicated server connection.
参考联机文档：
Net Services Reference ==> 6 Local Naming Parameters (tnsnames.ora)

Example 6-1 Basic Format of tnsnames.ora File

Example

net_service_name=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=sales1-svr)(PORT=1521))
  (ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr)(PORT=1521))
  (CONNECT_DATA=
   (SERVICE_NAME=sales.us.acme.com)))

修改后：

[oracle@ocm1 admin]$   vi tnsnames.ora
prod=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521))
  (CONNECT_DATA=
   (SERVICE_NAME=PROD)
   (SERVER=dedicated)))
~
验证连接：
SQL> conn system/oracle@prod
Connected.
可以连接


  • 4.1.2 The prod_s alias should connect to the PROD instance using LSNR2 and use a shared server connection.
向刚创建的   tnsnames.ora添加prod_s,端口1526，PROD,shared
[oracle@ocm1 admin]$ vi tnsnames.ora 
prod=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521))
  (CONNECT_DATA=
   (SERVICE_NAME=PROD)
   (SERVER=dedicated)))


prod_s=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1526))
  (CONNECT_DATA=
   (SERVICE_NAME=PROD)
   (SERVER=shared)))
~
~
"tnsnames.ora" 14L, 291C written                                                                                                
[oracle@ocm1 admin]$ 

验证连接，可以连接
SQL> conn system/oracle@prod_s
Connected.

可查看是否使用shared服务连接：
Reference--》V$SESSION

SERVER VARCHAR2(9) Server type (DEDICATED| SHARED| PSEUDO| NONE)

SQL> conn system/oracle@prod_s
Connected.
SQL> select sid,server from v$session;

       SID SERVER
---------- ---------
       280 DEDICATED
       282 DEDICATED
       285 DEDICATED
         288 SHARED
       290 DEDICATED
       291 DEDICATED
       292 DEDICATED
       293 DEDICATED
       294 DEDICATED
       295 DEDICATED
       296 DEDICATED

       SID SERVER
---------- ---------
       297 DEDICATED
       298 DEDICATED
       299 DEDICATED
       300 DEDICATED

15 rows selected.

SQL> conn system/oracle@prod
Connected.
SQL> select sid,server from v$session;

       SID SERVER
---------- ---------
       280 DEDICATED
       282 DEDICATED
       285 DEDICATED
        288 DEDICATED
       290 DEDICATED
       291 DEDICATED
       292 DEDICATED
       293 DEDICATED
       294 DEDICATED
       295 DEDICATED
       296 DEDICATED

       SID SERVER
---------- ---------
       297 DEDICATED
       298 DEDICATED
       299 DEDICATED
       300 DEDICATED

15 rows selected.

SQL> 


  •  4.2 The racdb alias should connect to the RACDB service (created later) with a dedicated server connection.
  •   4.2.1 The RACDB service will be running on your RAC Cluster

向刚创建的 tnsnames.ora添加内容racdb，端口1521
[oracle@ocm1 admin]$ vi tnsnames.ora 
prod=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521))
  (CONNECT_DATA=
   (SERVICE_NAME=PROD)
   (SERVER=dedicated)))


prod_s=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1526))
  (CONNECT_DATA=
   (SERVICE_NAME=PROD)
   (SERVER=shared)))


racdb=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521))
  (CONNECT_DATA=
   (SERVICE_NAME=RACDB)
   (SERVER=dedicated)))
~
~
~
~
"tnsnames.ora" 22L, 440C written                                                                                                
[oracle@ocm1 admin]$ 


  •  4.3 The emrep alias should connect to the EMREP instance (created later) wiht a dedicated server connection. 

[oracle@ocm1 admin]$ vi tnsnames.ora 
prod=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521))
  (CONNECT_DATA=
   (SERVICE_NAME=PROD)
   (SERVER=dedicated)))


prod_s=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1526))
  (CONNECT_DATA=
   (SERVICE_NAME=PROD)
   (SERVER=shared)))


racdb=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521))
  (CONNECT_DATA=
   (SERVICE_NAME=RACDB)
   (SERVER=dedicated)))


emrep=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521))
  (CONNECT_DATA=
   (SERVICE_NAME=EMREP)
   (SERVER=dedicated)))
"tnsnames.ora" 30L, 589C written                                                                                                
[oracle@ocm1 admin]$ 

Riveore
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
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_Session1_2_Server-side Network Configuration
一抹曦阳-Oracle
03-18 3115
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) f
论文阅读《Automatic Pavement Crack Detection Based on Hierarchical Feature Augmentation》
weixin_50281629的博客
03-06 3072
目录 Abstract 1 INTRODUCTION 2 RELATED WORK 3 METHODOLOGY 4 EXPERIMENTS 5CONCLUSION Abstract 公路作为重要的基础设施，是交通运输系统的基础。道路裂缝的检测变成了一项重要的任务。然而，由于裂缝形态的复杂性和多样性，检测道路裂缝成为一项挑战性的工作。现有的裂缝检测方法存在检测效果差和泛化能力弱的问题。受到深度学习相关技术的启发，我们提出了一个基于特征增强的裂缝检测网络，以提取道路图像中的...
External Tables
甲骨文可乐的专栏
07-08 938
官方文档地址：http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7002.htm#i2201774 external_table_clause ::= Description of the illustration external_table_clause.gif   (external_data_properti
oracle 外部表之 sqlldr 生成
weixin_34380781的博客
05-30 192
oracle的导入工具,速度挺快,这里记一下外部表的使用,通常外部表要记的语法太多例如: CREATE TABLE PROD_MASTER ( "EMPNO" NUMBER, "ENAME" VARCHAR2(50), "HIREDATE" DATE, "DEPTNO" NUMBER ) ORGANIZATION external ( TYPE oracle_loader ...
LCD.rar_OCM12864-9_ocm12864_visual c
最新发布
09-23
4. **内存映射**：理解OCM12864的内存映射机制，因为LCD的显示内容是通过内存地址映射到屏幕上的像素位置。 5. **同步与异步操作**：在多线程或实时系统中，可能需要考虑同步问题，以防止多个线程同时访问和修改LCD...
ADS.rar_ocm12232_ucos_ucos ads_ucos-ii_ucos移植
09-23
1. **硬件接口适配**：移植的第一步是使uCOS-II与OCM12232的硬件资源兼容。这包括配置时钟、GPIO、中断控制器、存储器映射等。例如，需要编写启动代码以初始化堆栈、设置中断向量表，并将控制权交给uCOS-II的内核。 ...
OCM.rar_OCM Java_oracle_oracle ocm
09-19
**Oracle Certified Master (OCM)** 是Oracle公司针对其数据库产品推出的最高级别的专业认证，它证明了持有者在Oracle数据库管理、性能优化、故障排查等方面具备高级技术和专业知识。OCM认证对于那些希望在Oracle...
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像素的图形显示...
yejin.rar_OCM12864-9_ks0107_lcd ks0107_ocm12864
09-14
《OCM12864液晶显示模块与KS0107控制器详解》 OCM12864液晶显示模块在嵌入式系统和工业设备中广泛应用，它以其高清晰度和灵活的显示能力而备受青睐。这个128×64像素的点阵型液晶显示器能够展示丰富的字符和图形...
论文见解之SRN: Side-output Residual Network for Object Symmetry Detection in the Wild
无奈的小心酸的博客
08-31 4582
论文名称：SRN: Side-output Residual Network for Object Symmetry Detection in the Wild   ----CVPR 2017 code地址：https://github.com/KevinKecc/SRN 论文概述：一篇做图像对称性骨骼的论文，与以往不同的是，此篇论文中采用了自定义的benchmark，基于HED进行网络改造，
OCM考试实验-Skillset1----Undo & Shared Server
RookieDBA的博客
07-12 893
本次实验的全部内容在上一节手动建库中创建的PROD3库中进行操作，如操作有问题可留言指出，欢迎指正。 Questition:2. Undo Management 2.1 Setup automatic undo management in the PROD1 database to support the following requirements: 2.1.1 Avoid
OCM_认证_CREATE DATABASE
十个传奇
11-14 474
整理手工建库的一些东西 1.基本环境 VBOX+REDHAT5.8+ORACLE11GR2 2.基本环境准备 ①安装redhat5.8安装的时候最好把相应的功能都安装了 。 ②ORACLE实例安装 参考：https://oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-5 安装oracl
Oracle 11g R2 RAC 增加节点详解（一）
热门推荐
moscot_wu的博客
05-19 1万+
最近准备给我的RAC环境加个节点，看了下官网，表示写的很简单，也应该是比较简单 第一步当然是准备一台虚拟机，最好是host01的拷贝，在未安装前，安装完毕后 $ cluvfy stage -pre nodeadd -n node3 [-fixup [-fixupdir fixup_dir]] [-verbose]这一步一般开始都不会通过PRVF-4007，原因是新增的主机并未进行SSH用户等效
using the easy connect naming method 简单连接测试
关注系统性能调优
06-02 1423
一直都不明白sqlnet.ora中的NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)是什么意思，今天看到一篇文档，就是登陆选用的方式，做一个测试： tnsnames.ora  10.10.32.119 =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HO
OCM_Session1_3_Shared Server Configuration
一抹曦阳-Oracle
03-18 3226
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
oracle链接的配置--product\11.2.0\client_1\network\admin\tnsnames.ora
03-14 4518
oracle客户端安装路径\product\11.2.0\client_1\network\admin\tnsnames.ora 其内容如下： # tnsnames.ora Network Configuration File: E:\Oracle11g-client2-manager\product\11.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
[每日一题] OCP1z0-047 :2013-08-06   外表部――相关描述........................................................
weixin_34383618的博客
08-06 82
转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/9797277　　　这道题目的知识点是要你熟悉外部表，怎么建外部表，外部表的数据是怎么存储的等等。请给出正确答案，并解释A B C D每项，最好用实验测试证明！　　　外部表的metadata(元数据)是存在数据库中，但它的数据是存储在数据库外部的操作系统文件，oracl...
OCM_第二天课程：Section1 —》配置 Oracle 网络环境
weixin_33862514的博客
09-23 1359
注：本文为原著（其内容来自 腾科教育培训课堂）。阅读本文注意事项如下：1：所有文章的转载请标注本文出处。2：本文非本人不得用于商业用途。违者将承当相应法律责任。3：该系列文章目录列表：一：《OCM 基本班课程表》 二：《OCM_第一天课程：OCM课程环境搭建》 三：《OCM_第二天课程：Section1 —》配置 Oracle 网络环境》 四：《OCM...
Oracle OCM10g认证大师学习笔记_v1.1
同时，结合其他相关学习资料，例如在线博客和文章，如http://www.oracleblog.org/study-note/ocm-exam-summary-one/，可以帮助考生更全面地准备考试。 OCM的学习和认证过程不仅提升了个人技术能力，也有助于在企业...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值