11.2.0.4 has 启动失败

crsctl start has
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.

[grid@qzdb1 client]$ cat crsctl_root.log
Oracle Database 11g Clusterware Release 11.2.0.4.0 - Production Copyright 1996, 2011 Oracle. All rights reserved.
2019-09-05 17:42:36.626: [ OCRMSG][901379872]prom_waitconnect: CONN NOT ESTABLISHED (0,29,1,2)
2019-09-05 17:42:36.626: [ OCRMSG][901379872]GIPC error [29] msg [gipcretConnectionRefused]
2019-09-05 17:42:36.626: [ OCRMSG][901379872]prom_connect: error while waiting for connection complete [24]

清理日志把$ORACLE_HOME/log/qzdb1目录删除以为重启has会自建目录,但是有些目录没建起来  导致启动has时报错没信息输出。

参考

OHASD Failed to Start: Inappropriate ioctl for device (Doc ID 1069182.1)

Troubleshoot Grid Infrastructure Startup Issues (Doc ID 1050908.1)

重新建立目录修改权限grid启动成功

启动数据库时有报错

SQL> startup nomount
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/qdswxxgx/spfileqdswxxgx.ora'
ORA-17503: ksfdopn:10 Failed to open file +DATA/qdswxxgx/spfileqdswxxgx.ora
ORA-12547: TNS:lost contact

参考Oracle Database Fails to Start with Error ORA-12547 (Doc ID 1307075.1)

[grid@qzdb1 bin]$ ls -l oracle
-rwxr-x--x 1 grid oinstall 210233135 Oct 18 2018 oracle
[grid@sbfqzdb1 bin]$ id
uid=500(grid) gid=6000(oinstall) groups=6000(oinstall),5000(asmadmin),5001(asmdba),5002(asmoper)
[grid@qzdb1 bin]$ chmod 6751 oracle
[grid@sbfqzdb1 bin]$ ls -l oracle
-rwsr-s--x 1 grid oinstall 210233135 Oct 18 2018 oracle

修改完权限以后启动成功

 

posted @ 2019-09-06 10:52  刚好遇见Mysql  阅读(630)  评论(0编辑  收藏  举报