After TNSNAME is removed, the CRS-0215 and CRS-1019 cannot Start Node 1.

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.