OCA读书笔记(6) - 配置Oracle网络环境

最新推荐文章于 2025-09-06 22:56:13 发布

weixin_34319640

最新推荐文章于 2025-09-06 22:56:13 发布

阅读量91

点赞数

CC 4.0 BY-SA版权

文章标签：数据库网络

原文链接：http://www.cnblogs.com/thlzhf/p/3357841.html

本文介绍Oracle网络环境配置方法，包括监听器与服务的动态及静态配置、客户端配置、连接方式等，并提供了具体配置文件示例。

6.Configuring the Oracle Network Environment

su - grid
装grid时自动创建了监听
netca--创建新的监听

vi $ORACLE_HOME/network/admin/listener.ora

启动监听时会进行回环测试，如果注释掉127.0.0.1则不能启动监听。
服务：
动态配置服务
alter system set service_names='orcl','easthome';
alter system register;

静态配置服务
listener.ora
lsnrctl reload

客户端配置：
需要先安装oracle客户端
netca 配置连接方法
vi $ORACLE_HOME/network/admin/sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

netca 配置本地网络服务名
vi $ORACLE_HOME/network/admin/tnsnames.ora
CLIENT_SERVICE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.7)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.8)(PORT = 1521)) -- 故障转移
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

tns ping不检测服务名，只验证ip和端口号。

一个单独的监听器可以服务于多个数据库实例以及成百上千个客户端连接。

Prompt syntax:
LSNRCTL> <command name>
LSNRCTL> start
LSNRCTL> stop

Command-line syntax:
$ lsnrctl <command name>
$ lsnrctl start
$ lsnrctl stop
$ lsnrctl status

SRVCTL syntax:
$ srvctl -h
$ srvctl start listener
$ srvctl stoplistener
$ srvctl start listener -l mylistener
$ srvctl status listener

Resolving connection Information
Easy connect naming: Uses a TCP/IP connect string
CONNECT username/password@host[:port][/service_name]
SQL> connect hr/hr@stu1:1521/db01

$ sqlplus scott/tiger@stu1:1521/db01

Local naming: Uses a local configuration file
stores connect descriptiors in tnsnames.ora
SQL> connect hr/hr@db01

Directory naming: Uses a centralized LDAP-compliant directory server
SQL> connect hr/hr@db01

External naming: Uses a supported non-oracle naming service

Testing Oracle Net Connectivity
Supports easy connect names resolution:
tnsping stu1:1521/db01

Supports local and directory naming:
tnsping db01

1) Server(Listener) configuration files:

listener.ora:
# listener.ora Network Configuration File: /u01/app/grid/product/11.2.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = db01)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db)
(GLOBAL_DBNAME = orcl3) --静态配置的服务名
)

(SID_DESC =
(SID_NAME = +ASM)
(ORACLE_HOME = /u01/app/grid/product/11.2.0/grid)
(GLOBAL_DBNAME = orcl4) --静态配置的服务名
)
)

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = stu1)(PORT = 1521))
    )
)

ADR_BASE_LISTENER = /u01/app/grid

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent

动态配置

sqlplus / as sysdba;
alter system set service_names='orcl','easthome','db01'

动态注册：
alter system register;立即出发PMON进程

或者等待PMON进程自动将service_name注册到监听
lsnrctl stop
lsnrctl start
如果还没有看到服务，说明PMON还没有到达其工作周期

静态配置
需要编辑配置文件
数据库关闭时只能静态注册。
动态注册可以实现基于服务的负载均衡，在RAC中。

sqlnet.ora:
# sqlnet.ora Network Configuration File: /u01/app/grid/product/11.2.0/grid/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /u01/app/grid

2) Client configuration files:

tnsnames.ora:
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DB01 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = stu1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db01)
    )
)

3) CONNECT TO ANOTHER DATABASE

tnsnames.ora:

REMOTE_ORCL =
(DESCRIPTION =
    (ADDRESS =
      (PROTOCOL = TCP)
      (HOST = host02.example.com)
      (PORT = 1521)
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.example.com)
    )
)

SQL*Plus:

CONNECT hr/hr@orcl;

CREATE DATABASE LINK remote
CONNECT TO HR IDENTIFIED BY HR
USING 'REMOTE_ORCL';

SELECT * FROM employees@remote;