ORA-01078、LRM-00109 oracle rac 6751问题处理

森森淼淼丶

于 2023-08-07 11:26:44 发布

阅读量275

点赞数 2

分类专栏： oracle 19c 文章标签： oracle 数据库运维 dba

本文链接：https://blog.csdn.net/weixin_61212661/article/details/132141438

版权

oracle 19c 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

问题现象

查看集群状态发现有一个节点的db服务始终没有起来

[root@attdb1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE attdb1 STABLE
ONLINE ONLINE attdb2 STABLE
ora.chad
ONLINE ONLINE attdb1 STABLE
ONLINE ONLINE attdb2 STABLE
ora.net1.network
ONLINE ONLINE attdb1 STABLE
ONLINE ONLINE attdb2 STABLE
ora.ons
ONLINE ONLINE attdb1 STABLE
ONLINE ONLINE attdb2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ARCH.dg(ora.asmgroup)
1 ONLINE ONLINE attdb1 STABLE
2 ONLINE ONLINE attdb2 STABLE
3 OFFLINE OFFLINE STABLE
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE attdb1 STABLE
2 ONLINE ONLINE attdb2 STABLE
3 ONLINE OFFLINE STABLE
ora.CRS.dg(ora.asmgroup)
1 ONLINE ONLINE attdb1 STABLE
2 ONLINE ONLINE attdb2 STABLE
3 OFFLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE attdb1 STABLE
2 ONLINE ONLINE attdb2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE attdb1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE attdb2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE attdb2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE attdb1 Started,STABLE
2 ONLINE ONLINE attdb2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE attdb1 STABLE
2 ONLINE ONLINE attdb2 STABLE
3 OFFLINE OFFLINE STABLE
ora.attdb1.vip
1 ONLINE ONLINE attdb1 STABLE
ora.attdb2.vip
1 ONLINE ONLINE attdb2 STABLE
ora.cvu
1 ONLINE ONLINE attdb2 STABLE
ora.orcl.db
1 ONLINE ONLINE attdb1 Open,HOME=/u01/app/o
racle/product/19.0.0
/db_home1,STABLE
2 ONLINE OFFLINE Instance Shutdown,ST
ABLE
ora.qosmserver
1 ONLINE ONLINE attdb2 STABLE
ora.scan1.vip
1 ONLINE ONLINE attdb1 STABLE
ora.scan2.vip
1 ONLINE ONLINE attdb2 STABLE
ora.scan3.vip
1 ONLINE ONLINE attdb2 STABLE
--------------------------------------------------------------------------------

尝试解决问题

手动启动

[oracle@attdb2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 2 21:09:19 2023
Version 19.3.0.0.0

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/19.0.0/db_home1/dbs/initorcl2.ora'
SQL> exit
Disconnected

手动启动数据库实例报错:ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file

处理方法

给grid的$ORACLE_HOME/bin下的oracle 6751权限

[root@attdb2 ~]# su - grid
Last login: Wed Aug 2 21:07:55 CST 2023
[grid@attdb2 ~]$ cd $ORACLE_HOME/bin
[grid@attdb2 bin]$ chmod 6751 oracle
[grid@attdb2 bin]$ ls -l oracle
-rwsr-s--x 1 grid oinstall 418591368 Aug 1 23:00 oracle

重新启动数据库实例

[root@attdb2 ~]# su - oracle
Last login: Wed Aug 2 21:08:12 CST 2023 on pts/0
[oracle@attdb2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 2 21:11:26 2023
Version 19.3.0.0.0

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1.0033E+10 bytes
Fixed Size 8906840 bytes
Variable Size 1577058304 bytes
Database Buffers 8422162432 bytes
Redo Buffers 24645632 bytes
Database mounted.
Database opened.
SQL>

启动成功