1、关闭现在已经启动监听。

   2、删除已存在的监听,否则提示已存在同名(listener)的监听,同时在安装数据库软件时,安装程序将jason1节点的所有程序拷贝至jason3节点, $ORACLE_HOME/network/admin目录listener.ora、tnsname.ora里内容与节点jason1内容完全一致,因此需要删除已有监听重新创建监听。以oracle账户登录jason1节点执行$ORACLE_HOME/bin/netca,如下

RedHat 5.6_x86_64 + ASM + RAW+ Oracle 10g RAC (十) 添加节点—创建监听_Oracle 10g RAC  add

选择cluster configuration点击next

RedHat 5.6_x86_64 + ASM + RAW+ Oracle 10g RAC (十) 添加节点—创建监听_Oracle 10g RAC  add _02

选择所有节点点击next

RedHat 5.6_x86_64 + ASM + RAW+ Oracle 10g RAC (十) 添加节点—创建监听_ASM_03

选择listener configuration

RedHat 5.6_x86_64 + ASM + RAW+ Oracle 10g RAC (十) 添加节点—创建监听_RedHat 5.6_x86_64_04

选择add

RedHat 5.6_x86_64 + ASM + RAW+ Oracle 10g RAC (十) 添加节点—创建监听_Oracle 10g RAC  add _05

使用默认监听名

RedHat 5.6_x86_64 + ASM + RAW+ Oracle 10g RAC (十) 添加节点—创建监听_RAW_06

选择tcp协议

RedHat 5.6_x86_64 + ASM + RAW+ Oracle 10g RAC (十) 添加节点—创建监听_RedHat 5.6_x86_64_07

使用默认端口1521

RedHat 5.6_x86_64 + ASM + RAW+ Oracle 10g RAC (十) 添加节点—创建监听_ASM_08

选择no

RedHat 5.6_x86_64 + ASM + RAW+ Oracle 10g RAC (十) 添加节点—创建监听_ASM_09

   最终配置jason3的监听文件内容如下

[root@jason3 admin]# cat listener.ora

# listener.ora.jason3 Network Configuration File: /home/oracle/orahome/product/10.2.0/db_1/network/admin/listener.ora.jason3

# Generated by Oracle configuration tools.


SID_LIST_LISTENER_JASON3 =

 (SID_LIST =

   (SID_DESC =

     (SID_NAME = PLSExtProc)

     (ORACLE_HOME = /home/oracle/orahome/product/10.2.0/db_1)

     (PROGRAM = extproc)

   )

 )


LISTENER_JASON3 =

 (DESCRIPTION_LIST =

   (DESCRIPTION =

     (ADDRESS = (PROTOCOL = TCP)(HOST = jason3-vip)(PORT = 1521)(IP = FIRST))

     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.193)(PORT = 1521)(IP = FIRST))

   )

 )