工程日志
填报日期:2014/11/20
[实施目的]
1. 解决rac其中一个节点实例只能启动到nomount;
[项目环境]
操作系统 |
linux |
主机名 |
zgcrac1 |
数据库版本 |
Oracle 11.2.0 |
字符集 |
|
生产库实例名 |
PROD |
监听 |
LISTENER/1521 |
[实施步骤]
1. 分析错误原因
1.1查看监听,并分析:
根据李昕描述,监听无法启动,查看监听信息
[grid@zgcrac1~]$ lsnrctl status
LSNRCTL forLinux: Version 11.2.0.3.0 - Production on 19-11月-2014 09:55:30
Copyright (c)1991, 2011, Oracle. All rights reserved.
Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of theLISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version11.2.0.3.0 - Production
StartDate 21-10月-201420:22:13
Uptime 28 days 13 hr. 33 min. 16 sec
TraceLevel off
Security ON: Local OS Authentication
SNMP OFF
ListenerParameter File /g01/11ggrid/app/11.2.0/grid/network/admin/listener.ora
Listener LogFile /g01/11ggrid/app/11.2.0/grid/log/diag/tnslsnr/zgcrac1/listener/alert/log.xml
ListeningEndpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.88.11)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.88.12)(PORT=1521)))
ServicesSummary...
Service"+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has1 handler(s) for this service...
Service"PROD" has 1 instance(s).
Instance"PROD1", status BLOCKED, has 1 handler(s) for this service...
Grid用户
Name Type Target State Host
------------------------------------------------------------
ora.DATADG.dg ora....up.typeONLINE ONLINE zgcrac1
ora.FDG.dg ora....up.typeONLINE ONLINE zgcrac2
ora....ER.lsnr ora....er.type ONLINE ONLINE zgcrac2
ora....N1.lsnr ora....er.type ONLINE ONLINE zgcrac1
ora....EMDG.dg ora....up.type ONLINE ONLINE zgcrac1
ora.asm ora.asm.type ONLINE ONLINE zgcrac1
ora.cvu ora.cvu.type ONLINE ONLINE zgcrac1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE zgcrac1
ora.oc4j ora.oc4j.type ONLINE ONLINE zgcrac1
ora.ons ora.ons.type ONLINE ONLINE zgcrac1
ora.prod.db ora....se.typeONLINE ONLINE zgcrac2
ora.scan1.vip ora....ip.typeONLINE ONLINE zgcrac1
ora....SM1.asm application ONLINE ONLINE zgcrac1
ora....C1.lsnr application OFFLINE OFFLINE
ora....ac1.gsd application OFFLINE OFFLINE
ora....ac1.ons application ONLINE ONLINE zgcrac1
ora....ac1.vip ora....t1.type ONLINE ONLINE zgcrac1
ora....SM2.asm application ONLINE ONLINE zgcrac2
ora....C2.lsnr application ONLINE ONLINE zgcrac2
ora....ac2.gsd application OFFLINE OFFLINE
ora....ac2.ons application ONLINE ONLINE zgcrac2
ora....ac2.vip ora....t1.type ONLINE ONLINE zgcrac2
根据监听信息,可以看到报错。
1.2判断监听:
查看12服务器监听,没有发现问题;
查看22服务器监听,也没有发现问题。
判断是否为网络或者ip问题
1.3hosts文件:
127.0.0.1 localhostlocalhost.localdomain localhost4 localhost4.localdomain4
::1 localhostlocalhost.localdomain localhost6 localhost6.localdomain6
172.16.88.11 zgcrac1 zgcrac1.com
172.16.88.12 zgcrac1-vip
172.16.88.21 zgcrac2 zgcrac2.com
172.16.88.22 zgcrac2-vip
172.16.88.10 zgcrac-clusterzgcrac-cluster-scan
10.10.1.1 zgcrac1-priv
10.10.1.2 zgcrac2-priv
两个服务器ip都没有问题
1.4查看数据库实例运行:
select instance_name,host_name,status from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
查看全部实例运行情况
INSTANCE_NAME HOST_NAME STATUS
------------------------------ --------------------------------------------------------
+ASM1