由于目录权限问题导致Oracle RAC 重启遭遇ORA-01078、ORA-01565、ORA-17503、ORA-12547报错处理过程

最新推荐文章于 2025-10-11 11:43:57 发布

原创

最新推荐文章于 2025-10-11 11:43:57 发布 · 1k 阅读

5 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库

由于数据库服务器重启导致一个节点集群无法启动，遭遇ORA-12547等错误，具体如下：

[root@rac1 ~]# ps -ef|grep ora
grid 3975 1 0 16:42 ? 00:00:00 /u01/grid11g/bin/oraagent.bin
root 3998 3692 0 16:42 pts/0 00:00:00 grep ora

[grid@rac2 ~]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.ARCH.dg    ora....up.type ONLINE    ONLINE    rac2
ora.DATA.dg    ora....up.type ONLINE    ONLINE    rac2
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac2
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac2
ora.OCR.dg     ora....up.type ONLINE    ONLINE    rac2
ora.asm        ora.asm.type   ONLINE    ONLINE    rac2
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac2
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE
ora....network ora....rk.type ONLINE    ONLINE    rac2
ora.oc4j       ora.oc4j.type ONLINE    ONLINE    rac2
ora.ons        ora.ons.type   ONLINE    ONLINE    rac2
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac2
ora....SM2.asm application    ONLINE    ONLINE    rac2
ora....C2.lsnr application    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    OFFLINE   OFFLINE
ora.rac2.ons   application    ONLINE    ONLINE    rac2
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2
ora.racdb.db   ora....se.type ONLINE    ONLINE    rac2
ora.scan1.vip ora....ip.type ONLINE    ONLINE    rac2

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Dec 16 16:47:58 2023

ERROR:
ORA-12547: TNS:lost contact

Enter user-name: exit
Enter password:
[oracle@rac1 ~]$
遭遇ORA-12547错误，一般为权限问题，发现集群目录权限变了，可能有人为错误导致：

[root@rac1 cdata]# cd /u01/
[root@rac1 u01]# ls -lhrt
total 40K
drwx------ 2 mongodb mongodb 16K Aug 14 2023 lost+found
drwxr-xr-x 8 mongodb mongodb 4.0K Aug 19 2023 grid_anzhuangbao
drwxr-xr-x 66 mongodb mongodb 4.0K Aug 20 2023 grid11g
drwxrwx--- 6 grid oinstall 4.0K Aug 20 2023 oraInventory
drwxr-xr-x 9 mongodb mongodb 4.0K Dec 25 2023 grid
drwxr-xr-x 5 mongodb mongodb 4.0K Jan 6 2023 mongodb
drwxr-xr-x 9 oracle oinstall 4.0K Nov 27 14:45 oracle

更改权限为合适的权限：
[root@rac1 u01]# chown grid:oinstall grid -R
[root@rac1 u01]# chown grid:oinstall grid11g -R
[root@rac1 u01]# ls -lhrt
total 40K
drwx------ 2 mongodb mongodb   16K Aug 14 2023 lost+found
drwxr-xr-x 8 mongodb mongodb 4.0K Aug 19 2023 grid_anzhuangbao
drwxr-xr-x 66 grid    oinstall 4.0K Aug 20 2023 grid11g
drwxrwx--- 6 grid    oinstall 4.0K Aug 20 2023 oraInventory
drwxr-xr-x 9 grid    oinstall 4.0K Dec 25 2023 grid
drwxr-xr-x 5 mongodb mongodb 4.0K Jan 6 2023 mongodb
drwxr-xr-x 9 oracle oinstall 4.0K Nov 27 14:45 oracle

重启机器：
[root@rac1 u01]# reboot

集群起来，但是实例没有启动：
[oracle@rac1 ~]$ ps -ef|grep ora
grid      3699     1 0 17:03 ?        00:00:00 /u01/grid11g/bin/oraagent.bin
root      3845     1 0 17:03 ?        00:00:00 /u01/grid11g/bin/orarootagent.bin
grid      4017     1 0 17:03 ?        00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid      4032     1 0 17:03 ?        00:00:00 oracle+ASM1_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid      4036     1 0 17:03 ?        00:00:00 oracle+ASM1_asmb_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid      4040     1 0 17:03 ?        00:00:00 oracle+ASM1_o000_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid      4160     1 0 17:04 ?        00:00:00 /u01/grid11g/bin/oraagent.bin
root      4164     1 0 17:04 ?        00:00:00 /u01/grid11g/bin/orarootagent.bin
grid      4210     1