TNSNAME移走后造成CRS-0215和CRS-1019 启不了节点1实列
来源:互联网 发布:在线视频加速软件 编辑:程序博客网 时间:2024/06/06 16:34
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
- TNSNAME移走后造成CRS-0215和CRS-1019 启不了节点1实列
- crs-1006 crs-0215 aix
- Oracle11.2.0.1.0节点1集群不能正常启动,报CRS-4535,CRS-4530
- CRS-1006 , CRS-0215 故障一例
- vipca报错 CRS-1006,CRS-0215
- RKP-1001 和CRS-0215故障处理
- CRS-0215 错误处理
- CRS-4530,CRS-4534
- CRS-4124 CRS-4000
- CRS-2800 CRS-4000
- 两节点时间不同步导致CRS-0184
- 两节点时间不同步导致CRS-0184
- Cisco CRS-1 光纤清理
- 数据库oracle RAC,磁阵路径改变,造成启动错误CRS-4535 CRS-4000
- 由于CRS磁盘dismount造成的CRS进程无法启动问题
- Vmware 下Oracle RAC搬家引起CRS-1006/CRS-0215/CRS-0233
- 11gR2RAC在节点2执行root.sh报错:PRCR-1079 CRS-5005 CRS-2674 CRS-2632
- 如何保证10g CRS和11g GI并存在同一节点
- 三个月
- 如何在Ubuntu下安装”.deb“、”.bin“、”.tar.gz“、”.tar.bz2“格式的软件包!
- linux高级字符设备驱动之 三 阻塞型字符设备驱动
- 精解局域网访问及共享 实践后记
- suse安装图解2
- TNSNAME移走后造成CRS-0215和CRS-1019 启不了节点1实列
- ants crash problem
- suse安装图解1
- ffmpeg的编译与使用
- .net中js判断浏览器的类型和版本
- C语言程序的内存布局(二)C语言程序段的分类
- 堆和栈的区别
- 兼容火狐和ie的文档键盘事件监听器
- 得到第一个词(token)