TNSNAME移走后造成CRS-0215和CRS-1019 启不了节点1实列

TNSNAME移走后造成CRS-0215和CRS-1019 启不了节点1实列

[oracle@node1 product]$ crs_stat -t

Name           Type           Target    State     Host       

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

ora....C1.inst application    ONLINE    OFFLINE               

ora....C2.inst application    ONLINE    ONLINE    node2      

ora.MYRAC.db   application    ONLINE    ONLINE    node1      

ora....SM1.asm application    ONLINE    ONLINE    node1      

ora....E1.lsnr application    OFFLINE   OFFLINE               

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      

 

[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: Could 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, 2005, 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, 2005, 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

总用量 8

-rw-r-----  1 oracle oinstall 2806  1月 18 19:48 init.ora.018201219489

-rw-r-----  1 root   root     2806  5月 13 16:10 init.ora.018201219489_bak01

[oracle@node1 pfile]$ vi init.ora.018201219489

###########################################

# Cluster Database

###########################################

cluster_database_instances=2

remote_listener=LISTENERS_MYRAC

 

 

忽然昨天想起把节点的TNSNAME。ORA移走了

 

[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    ONLINE    node1      

ora....C2.inst application    ONLINE    ONLINE    node2      

ora.MYRAC.db   application    ONLINE    ONLINE    node1      

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