10gR2 RAC一个节点INSTANCE启不来

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@ /home/oracle -> srvctl stop database -d wilson

node1@ /home/oracle -> srvctl start database -d wilson
PRKP-1001 : Error starting instance wilson2 on node node2
CRS-0215: Could not start resource 'ora.wilson.wilson2.inst'.

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 ->

解决，检查tnsnames.ora,
发现有问题的节点中没有tnsnames.ora文件，从别的节点中CP一份，问题解决。

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23862439/viewspace-1058142/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23862439/viewspace-1058142/