`
itspace
  • 浏览: 981632 次
  • 性别: Icon_minigender_1
  • 来自: 杭州
社区版块
存档分类
最新评论

Oracle Rac监听之困惑

OracleAIXIBMCC++ 
阅读更多

今天在客户碰到一问题，在这里记录一下：
/etc/hosts文件配置为
引用
127.0.0.1       localhost       loopback        # loopback (lo0) name/address

#public network
192.200.31.3    hisdb01
192.200.31.4    hisdb02

#virtual ip address
192.200.31.19   hisdb01_vip
192.200.31.20   hisdb02_vip

#private network used for rac
10.0.0.1        hisdb01_priv
10.0.0.2        hisdb02_priv


listener.ora文件配置为

引用
LISTENER_HISDB02 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hisdb02_vip)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.200.31.4)(PORT = 1521)(IP = FIRST))
    )
  )

SID_LIST_LISTENER_HISDB02 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/products/rdbms)
      (PROGRAM = extproc)
    )
  )

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER_HISDB02=OFF
INBOUND_CONNECT_TIMEOUT_ =0
PREFER_LEAST_LOADED_NODE_LISTENER_LISTENER_HISDB02=OFF


主机上监听状态显示
引用
oracle.orcl2@hisdb02:/home/oracle$lsnrctl status listener

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 05-FEB-
2010 10:58:49

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1
.0 - Production
Start Date                03-FEB-2010 16:00:32
Uptime                    1 days 18 hr. 58 min. 16 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /oracle/products/rdbms/network/admin/listener.ora
Listener Log File         /oracle/products/rdbms/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hisdb02)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "orcl" has 2 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
  Instance "orcl2", status READY, has 2 handler(s) for this service...
Service "orclXDB" has 2 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
  Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 2 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
  Instance "orcl2", status READY, has 2 handler(s) for this service...
Service "standby" has 2 instance(s).
  Instance "standby1", status READY, has 1 handler(s) for this service...
  Instance "standby2", status READY, has 2 handler(s) for this service...
Service "standby_XPT" has 2 instance(s).
  Instance "standby1", status READY, has 1 handler(s) for this service...
  Instance "standby2", status READY, has 2 handler(s) for this service...
The command completed successfully



引用
oracle.orcl2@hisdb02:/oracle/products/rdbms/network/admin$lsnrctl service

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 05-FEB-
2010 11:02:54

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "orcl" has 2 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:2147 refused:0 state:ready
         REMOTE SERVER
         (ADDRESS=(PROTOCOL=TCP)(HOST=hisdb01)(PORT=1521))
  Instance "orcl2", status READY, has 2 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:29731 refused:0 state:ready
         LOCAL SERVER
      "DEDICATED" established:0 refused:0 state:ready
         REMOTE SERVER
         (ADDRESS=(PROTOCOL=TCP)(HOST=hisdb02)(PORT=1521))
Service "orclXDB" has 2 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: hisdb01, pid: 1232986>
         (ADDRESS=(PROTOCOL=tcp)(HOST=hisdb01)(PORT=32808))
  Instance "orcl2", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: hisdb02, pid: 1232986>
         (ADDRESS=(PROTOCOL=tcp)(HOST=hisdb02)(PORT=32856))
Service "orcl_XPT" has 2 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:2147 refused:0 state:ready
         REMOTE SERVER
         (ADDRESS=(PROTOCOL=TCP)(HOST=hisdb01)(PORT=1521))
  Instance "orcl2", status READY, has 2 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:29731 refused:0 state:ready
         LOCAL SERVER
      "DEDICATED" established:0 refused:0 state:ready
         REMOTE SERVER
         (ADDRESS=(PROTOCOL=TCP)(HOST=hisdb02)(PORT=1521))
Service "standby" has 2 instance(s).
  Instance "standby1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         REMOTE SERVER
         (ADDRESS=(PROTOCOL=TCP)(HOST=hisdb01)(PORT=1521))
  Instance "standby2", status READY, has 2 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
      "DEDICATED" established:0 refused:0 state:ready
         REMOTE SERVER
         (ADDRESS=(PROTOCOL=TCP)(HOST=hisdb02)(PORT=1521))
Service "standby_XPT" has 2 instance(s).
  Instance "standby1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         REMOTE SERVER
         (ADDRESS=(PROTOCOL=TCP)(HOST=hisdb01)(PORT=1521))
  Instance "standby2", status READY, has 2 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
      "DEDICATED" established:0 refused:0 state:ready
         REMOTE SERVER
         (ADDRESS=(PROTOCOL=TCP)(HOST=hisdb02)(PORT=1521))
The command completed successfully


监听进程显示为
引用
oracle.orcl2@hisdb02:/home/oracle$ps -ef|grep tns
  oracle 1040544       1   0   Feb 03      -  3:52 /oracle/products/rdbms/bin/tnslsnr LISTENER -inherit
  oracle 3342398 3113092   0 10:58:35  pts/0  0:00 grep tns


rac状态显示为
引用
oracle.orcl2@hisdb02:/home/oracle$crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    hisdb01
ora....01.lsnr application    ONLINE    ONLINE    hisdb01
ora....b01.gsd application    ONLINE    ONLINE    hisdb01
ora....b01.ons application    ONLINE    ONLINE    hisdb01
ora....b01.vip application    ONLINE    ONLINE    hisdb01
ora....SM2.asm application    ONLINE    ONLINE    hisdb02
ora....02.lsnr application    ONLINE    ONLINE    hisdb02
ora....b02.gsd application    ONLINE    ONLINE    hisdb02
ora....b02.ons application    ONLINE    ONLINE    hisdb02
ora....b02.vip application    ONLINE    ONLINE    hisdb02
ora.orcl.db    application    ONLINE    ONLINE    hisdb01
ora....orcl.cs application    ONLINE    ONLINE    hisdb01
ora....cl1.srv application    ONLINE    ONLINE    hisdb01
ora....cl2.srv application    ONLINE    ONLINE    hisdb02
ora....l1.inst application    ONLINE    ONLINE    hisdb01
ora....l2.inst application    ONLINE    ONLINE    hisdb02


本地客户端tnsnames.ora配置为
引用
RAC2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.200.31.20)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
      (INSTANCE_NAME = orcl2)
    )
  )


奇怪的事情发生了，tnsping居然能通，为什么呢？
引用
C:\Documents and Settings\Administrator>tnsping rac2

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-2月 -
2010 10:56:42

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

已使用的参数文件:
D:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora


已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.200.
31.20)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)
(INSTANCE_NAME = orcl2)))
OK (10 毫秒)



0
顶
0
踩
分享到：
| HP-UX: Asynchronous i/o
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    Oracle RAC 项目实施方案

    Oracle RAC 项目实施方案 Oracle RAC（Real Application Clusters）是 Oracle 公司的一种集群解决方案，旨在提供高可用性和高性能的数据库解决方案。在生产环境下实施 Oracle RAC 需要进行详细的规划和实施本文将...

    Oracle rac功能测试方案

    ### Oracle RAC 功能测试方案详解 #### 一、引言 Oracle Real Application Clusters (RAC) 是一种高可用性、高性能的企业级数据库解决方案。本文档旨在提供一个全面的Oracle 11g RAC安装后的功能测试方案，主要包括...

    oracle rac防火墙配置学习

    Linux 常用命令 oracle rac 中文手册 官网翻译 oracle rac

    深入理解Oracle RAC 12c(完整书签).pdf

    Oracle RAC 12c是Oracle数据库的集群版本，全称是Oracle Real Application Clusters。它允许在多个计算机之间分布数据和负载，提供了高可用性、可扩展性和灵活性。RAC技术是Oracle数据库12c版本中提供的一项关键特性...

    Oracle RAC增加ASM盘,创建表空间

    Oracle RAC 增加 ASM 盘, 创建表空间 Oracle RAC 是一种高可用、高性能的数据库解决方案，通过将多个服务器节点组成一个集群，提供了高可用性和高性能的数据库服务。在 Oracle RAC 中，ASM（Automated Storage ...

    Windows平台Oracle RAC 集群安装过程

    ### Windows平台Oracle RAC集群安装过程详解 #### 引言 在企业级应用环境中，为了提高数据处理能力和系统的高可用性，Oracle Real Application Clusters (RAC) 成为了一种热门选择。尤其在Windows平台上部署Oracle...

    Oracle RAC重启操作手册

    - **背景**: 关闭集群服务是完全停止RAC环境的重要步骤之一。 - **目的**: 确保所有集群资源和服务都已正确关闭。 - **操作方法**: - 切换到`root`用户，并进入`grid_home/bin`目录。 - 执行`crsctl stop cluster ...

    Oracle RAC 12c运维最佳实践指南.pdf

    Oracle RAC 12c 运维最佳实践指南 Oracle RAC 12c 是一种高可用、高性能的集群解决方案，旨在实现数据库的高可用性和可扩展性。本文将对 Oracle RAC 12c 运维最佳实践指南进行解读，总结出相关的知识点。 一、 ...

    Understanding Oracle RAC Internals - The Cache Fusion Edition

    标题《Understanding Oracle RAC Internals - The Cache Fusion Edition》涉及的主题是Oracle RAC内部机制，特别是Cache Fusion技术。Oracle RAC（Real Application Clusters）是Oracle数据库的一个重要特性，它允许...

    记录一次在Vmware ESXi6虚拟机环境下搭建oracle的RAC的过程

    Vmware ESXi6虚拟机环境下搭建Oracle RAC的过程 在本文中，我们将记录一次在Vmware ESXi6虚拟机环境下搭建Oracle RAC的过程。Oracle RAC（Real Application Clusters）是一种高可用性解决方案，能够提供高性能和高...

    Oracle RAC核心技术详解

    Oracle RAC（Real Application Clusters）是Oracle数据库的一项高级特性，它允许多个实例同时访问同一个物理数据库，从而实现高可用性和负载均衡。在Oracle RAC核心技术详解中，我们将深入探讨RAC的工作原理、架构、...

    华为云ECS ORACLE RAC 11.2.0.4 的安装指导

    【华为云ECS ORACLE RAC 11.2.0.4 安装指导】 在当前技术环境中，由于去IOE（IBM、Oracle、EMC）的趋势，许多国内企业正考虑替换Oracle数据库，转而使用国产数据库或云计算平台上的数据库服务。然而，将Oracle RAC...

    oracle rac 安装部署文档.pdf

    Oracle RAC 安装部署文档 本文档详细介绍了 Oracle RAC 的安装部署过程，涵盖了物理硬件配置需求、虚拟机需求、操作系统安装、数据库安装、 Oracle RAC 图形界面搭建方法、创建磁盘组、安装 Oracle 数据库、性能...

    oracle rac 不停机调整时间.txt

    oracle rac 不停机调整时间.txt

    oracle RAC集群修改归档日志路径.docx

    Oracle RAC（Real Application Clusters）集群是一种高可用性解决方案，它允许多个实例同时访问同一个数据库，确保在单个节点故障时数据的连续性和一致性。归档日志是Oracle数据库的重要组成部分，它们记录了自上次...

    Oracle RAC部署环境准备手册之一：系统与工具安装

    Oracle RAC（Real Application Clusters）是Oracle数据库的一种高可用性解决方案，允许多个数据库实例同时访问同一物理数据库，提供故障切换和负载均衡能力。在部署Oracle RAC环境时，操作系统的选择和配置是至关...

    Oracle RAC核心技术详解_高斌

    市面上最好的oracle RAC原理书,由oracle原厂工程师编写。

    Oracle RAC部署环境准备手册之二：yum源配置

    Oracle RAC部署环境的准备过程中，YUM源的配置是一个至关重要的步骤，因为这直接影响到软件包的安装和系统的稳定性。YUM（Yellowdog Updater, Modified）是Linux系统中用于管理和更新软件包的工具，它能自动解决...

    深入理解OracleRAC12c

    资源名称：深入理解Oracle RAC 12c内容简介：《深入理解Oracle RAC 12c》介绍了Oracle RAC 12c技术的方方面面，涵盖了与RAC技术相关的集群件知识、数据库知识、存储知识、网络知识，并在基于RAC的应用软件设计、优化...

    oracle RAC

    ### Oracle RAC：数据库集群的优缺点解析 Oracle RAC（Real Application Clusters）是Oracle数据库的一种集群技术，旨在提供高可用性和可扩展性。它允许多个数据库实例同时访问同一份数据，从而实现了资源的共享和...

Magicbox
Global site tag (gtag.js) - Google Analytics