node1@ /u01/app/oracle/product/10.2.0/db_1/log/node1/racg -> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
ora....SM3.asm application ONLINE ONLINE node3
ora....E3.lsnr application ONLINE ONLINE node3
ora.node3.gsd application ONLINE ONLINE node3
ora.node3.ons application ONLINE ONLINE node3
ora.node3.vip application ONLINE ONLINE node3
ora.wilson.db application ONLINE ONLINE node1
ora....n1.inst application ONLINE ONLINE node1
ora....n2.inst application ONLINE OFFLINE
ora....n3.inst application ONLINE ONLINE node3

node2@ /home/oracle -> sqlplus /nolog

SQL*Plus: Release 10.2.0.5.0 - Production on Mon May 7 14:02:04 2012

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup nomount
ORA-01078: failure in processing system parameters
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENERS_WILSON'

node1@ /u01 -> cat pfile.ora
wilson2.__db_cache_size=188743680
wilson1.__db_cache_size=176160768
wilson3.__db_cache_size=188743680
wilson2.__java_pool_size=4194304
wilson1.__java_pool_size=4194304
wilson3.__java_pool_size=4194304
wilson2.__large_pool_size=4194304
wilson1.__large_pool_size=4194304
wilson3.__large_pool_size=4194304
wilson2.__shared_pool_size=83886080
wilson1.__shared_pool_size=96468992
wilson3.__shared_pool_size=83886080
wilson2.__streams_pool_size=0
wilson1.__streams_pool_size=0
wilson3.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/wilson/adump'
*.background_dump_dest='/u01/app/oracle/admin/wilson/bdump'
*.cluster_database_instances=2
*.cluster_database=true
*.compatible='10.2.0.5.0'
*.control_files='+DATA/wilson/controlfile/current.261.778015011','+DATA/wilson/controlfile/current.260.778015011'
*.core_dump_dest='/u01/app/oracle/admin/wilson/cdump'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='wilson'
*.db_recovery_file_dest='+DATA'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=wilsonXDB)'
wilson1.instance_number=1
wilson2.instance_number=2
wilson3.instance_number=3
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=+DATA/'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_listener='LISTENERS_WILSON'
*.remote_login_passwordfile='exclusive'
*.sga_target=285212672
wilson2.thread=2
wilson1.thread=1
wilson3.thread=3
*.undo_management='AUTO'
wilson2.undo_tablespace='UNDOTBS2'
wilson1.undo_tablespace='UNDOTBS1'
wilson3.undo_tablespace='UNDOTBS3'
*.user_dump_dest='/u01/app/oracle/admin/wilson/udump'
node1@ /u01 ->