Linux AS3.0 + Oracle9.2.0.4  RAC
两节点

现在加入一个节点3 。在RAC上配置都没有问题 。 但是监听有些奇怪 。


参数 ：
---------------------   

*.background_dump_dest='/u01/product/admin/intel/bdump'
*.cluster_database_instances=3
*.cluster_database=true
*.compatible='9.2.0.0.0'
*.control_files='/ocfs_ctrl_redo/intel/control01.ctl','/ocfs_ctrl_redo/intel/control02.ctl','/ocfs_ctrl_redo/intel/control03.ctl'
*.core_dump_dest='/u01/product/admin/intel/cdump'
*.cursor_sharing='EXACT'
*.db_block_size=8192
*.db_cache_size=1073741824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_files=1000
*.db_name='intel'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=intelXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
intel1.instance_name='intel1'
intel2.instance_name='intel2'
intel3.instance_name='intel3'
intel1.instance_number=1
intel2.instance_number=2
intel3.instance_number=3
*.java_pool_size=31457280
*.job_queue_processes=36
*.large_pool_size=20971520
intel1.local_listener='(address=(protocol=tcp)(host=dmdii-node1)(port=1521))'
intel2.local_listener='(address=(protocol=tcp)(host=dmdii-node2)(port=1521))'
intel3.local_listener='(address=(protocol=tcp)(host=dmdii-node3)(port=1521))'
intel1.log_archive_dest_1='LOCATION=/ocfs_arch1/intel/'
intel2.log_archive_dest_1='LOCATION=/ocfs_arch2/intel/'
intel3.log_archive_dest_1='LOCATION=/ocfs_arch2/intel/'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
*.open_cursors=4000
*.optimizer_index_cost_adj=30
*.optimizer_mode='rule'
*.pga_aggregate_target=314572800
*.processes=1015
*.query_rewrite_enabled='FALSE'
intel1.remote_listener='(address=(protocol=tcp)(host=dmdii-node2)(port=1521))','(address=(protocol=tcp)(host=dmdii-node3)(port=1521))'
intel2.remote_listener='(address=(protocol=tcp)(host=dmdii-node1)(port=1521))','(address=(protocol=tcp)(host=dmdii-node3)(port=1521))'
intel3.remote_listener='(address=(protocol=tcp)(host=dmdii-node1)(port=1521))','(address=(protocol=tcp)(host=dmdii-node2)(port=1521))'
*.remote_login_passwordfile='exclusive'
*.resource_limit=TRUE
*.service_names='intel'
*.session_cached_cursors=20
*.shared_pool_size=419430400
*.sort_area_size=2097152
*.star_transformation_enabled='FALSE'
intel1.thread=1
intel2.thread=2
intel3.thread=3
*.timed_statistics=TRUE
*.trace_enabled=false
*.undo_management='AUTO'
*.undo_retention=10800
intel1.undo_tablespace='UNDOTBS1'
intel2.undo_tablespace='UNDOTBS2'
intel3.undo_tablespace='UNDOTBS3'
*.user_dump_dest='/u01/product/admin/intel/udump'  


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




监听开启后， 节点1 只有节点1 的信息 ：


dmdii-node1$lsnrctl status

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 04-APR-2009 16:21:19

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date                04-APR-2009 16:05:16
Uptime                    0 days 0 hr. 16 min. 3 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /u01/product/oracle/network/admin/listener.ora
Listener Log File         /u01/product/oracle/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.1.148)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.156.4.98)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dmdii-node1)(PORT=8080))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dmdii-node1)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "intel" has 1 instance(s).
  Instance "intel1", status READY, has 1 handler(s) for this service...
Service "intel1" has 1 instance(s).
  Instance "intel1", status UNKNOWN, has 1 handler(s) for this service...
Service "intelXDB" has 1 instance(s).
  Instance "intel1", status READY, has 1 handler(s) for this service...
The command completed successfully


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


节点2 有 2，3 两个节点的实例信息


dmdii-node2$lsnrctl status

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 04-APR-2009 16:21:38

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date                04-APR-2009 16:05:36
Uptime                    0 days 0 hr. 16 min. 1 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /u01/product/oracle/network/admin/listener.ora
Listener Log File         /u01/product/oracle/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.1.149)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.156.4.99)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dmdii-node2)(PORT=8080))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dmdii-node2)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "intel" has 2 instance(s).
  Instance "intel2", status READY, has 1 handler(s) for this service...
  Instance "intel3", status READY, has 1 handler(s) for this service...
Service "intel2" has 1 instance(s).
  Instance "intel2", status UNKNOWN, has 1 handler(s) for this service...
Service "intelXDB" has 2 instance(s).
  Instance "intel2", status READY, has 1 handler(s) for this service...
  Instance "intel3", status READY, has 1 handler(s) for this service...
The command completed successfully


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


节点3 上有1，2，3  三个节点的信息

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 04-APR-2009 16:21:14

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date                04-APR-2009 16:05:21
Uptime                    0 days 0 hr. 15 min. 52 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /u01/product/oracle/network/admin/listener.ora
Listener Log File         /u01/product/oracle/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.1.147)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.156.4.103)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dmdii-node3)(PORT=8080))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dmdii-node3)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "intel" has 4 instance(s).
  Instance "intel1", status READY, has 1 handler(s) for this service...
  Instance "intel2", status READY, has 1 handler(s) for this service...
  Instance "intel3", status UNKNOWN, has 1 handler(s) for this service...
  Instance "intel3", status READY, has 1 handler(s) for this service...
Service "intelXDB" has 3 instance(s).
  Instance "intel1", status READY, has 1 handler(s) for this service...
  Instance "intel2", status READY, has 1 handler(s) for this service...
  Instance "intel3", status READY, has 1 handler(s) for this service...
The command completed successfully




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

hosts信息

dmdii-node3$cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
# 127.0.0.1               dmdii-node3
127.0.0.1               localhost.localdomain localhost dmdii-node3.localdomain


10.156.4.98               dmdii-node1
172.20.1.148              dmdii-node1
10.1.1.7                  dmdii-pri1

10.156.4.99               dmdii-node2
172.20.1.149              dmdii-node2
10.1.1.8                  dmdii-pri2

10.156.4.103              dmdii-node3
172.20.1.147              dmdii-node3
10.1.1.9                  dmdii-pri3



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

节点3监听设置 ， 其他2个类似的设置


# LISTENER.ORA Network Configuration File: /u01/product/oracle/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.147)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.4.103)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/product/oracle)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = intel)
      (ORACLE_HOME = /u01/product/oracle)
      (SID_NAME = intel3)
    )
  )