After TNSNAME is removed, the CRS-0215 and CRS-1019 cannot Start Node 1.
[Oracle @ node1 product] $ crs_stat-t
Name Type Target State Host
------------------------------------------------------------
Ora... C1.inst application ONLINE OFFLINE
Ora... C2.inst application ONLINE node2
Ora. MYRAC. db application ONLINE node1
Ora... sm1.asm application online node1
Ora... e1.lsnr application offline
Ora. node1.gsd application online node1
Ora. node1.ons application online node1
Ora. node1.vip application online node1
Ora... sm2.asm application online node2
Ora... E2.lsnr application ONLINE node2
Ora. node2.gsd application ONLINE node2
Ora. node2.ons application ONLINE node2
Ora. node2.vip application ONLINE node2
[Oracle @ node1 product] $ crs_start-f ora. MYRAC. MYRAC1.inst
Attempting to start 'ora. MYRAC. MYRAC1.inst 'on member 'node1'
Start of 'ora. MYRAC. MYRAC1.inst 'on member 'node1' failed.
Node2: CRS-1019: Resource ora. node1.ASM1. asm (application) cannot run on node2
CRS-0215: cocould not start resource 'ora. myrac. myrac1.inst '.
[Oracle @ node1 product] $ asmcmd
Asmcmd> ls
Data/
Asmcmd> ls-S
Sector block au total_mb free_mb req_mir_free_mb usable_file_mb offline_disks name
512 4096 1048576 4094 2535 0 2535 0 Data/
Asmcmd> exit
[Oracle @ node1 product] $ export oracle_sid = + ASM1
[Oracle @ node1 product] $ sqlplus/nolog
SQL * Plus: Release 10.2.0.1.0-production on Wed May 16 20:22:12 2012
Copyright (c) 1982,200 5, Oracle. All rights reserved.
SQL> conn sys/235619 as sysdba
Connected.
[Oracle @ node1 product] $ export oracle_sid = myrac1
[Oracle @ node1 product] $ sqlplus/nolog
SQL * Plus: Release 10.2.0.1.0-production on Wed May 16 20:39:44 2012
Copyright (c) 1982,200 5, Oracle. All rights reserved.
SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORA-00119: Invalid specification for system parameter remote_listener
ORA-00132: syntax error or unresolved network name 'listeners _ myrac'
SQL> startup mount
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'listeners _ MYRAC'
SQL> exit
Disconnected
[Oracle @ node1 MYRAC] $ cd pfile/
[Oracle @ node1 pfile] $ ll
Total usage 8
-Rw-r ----- 1 oracle oinstall 2806 January 18 19:48 init. ora.018201219489
-Rw-r ----- 1 root 2806 May 13 16:10 init. ora.018201219489 _ bak01
[Oracle @ node1 pfile] $ vi init. ora.018201219489
######################################## ###
# Cluster Database
######################################## ###
Cluster_database_instances = 2
Remote_listener = LISTENERS_MYRAC
I suddenly remembered the node TNSNAME yesterday. ORA removed
[Oracle @ node1 admin] $ more tnsnames. ora
# Tnsnames. ora Network Configuration File:/opt/oracle/database/product/10.2.0/db_1/network/ad
Min/tnsnames. ora
# Generated by Oracle configuration tools.
MYRAC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = node2-vip) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYRAC)
(INSTANCE_NAME = MYRAC2)
)
)
MYRAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = node1-vip) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYRAC)
(INSTANCE_NAME = MYRAC1)
)
)
MYRAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = node1-vip) (PORT = 1521 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = node2-vip) (PORT = 1521 ))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYRAC)
)
)
LISTENERS_MYRAC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = node1-vip) (PORT = 1521 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = node2-vip) (PORT = 1521 ))
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0 ))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
[Oracle @ node1 admin] $ crs_start-f ora. MYRAC. MYRAC1.inst
Attempting to start 'ora. MYRAC. MYRAC1.inst 'on member 'node1'
Start of 'ora. MYRAC. MYRAC1.inst 'on member 'node1' succeeded.
[Oracle @ node1 admin] $ crs_stat-t
Name Type Target State Host
------------------------------------------------------------
Ora... C1.inst application ONLINE node1
Ora... C2.inst application ONLINE node2
Ora. MYRAC. db application ONLINE node1
Ora... SM1.asm application ONLINE node1
Ora... E1.lsnr application ONLINE node1
Ora. node1.gsd application ONLINE node1
Ora. node1.ons application ONLINE node1
Ora. node1.vip application ONLINE node1
Ora... sm2.asm application online node2
Ora... e2.lsnr application online node2
Ora. node2.gsd application online node2
Ora. node2.ons application online node2
Ora. node2.vip application online node2