【报错解决】ORA-03135;ORA-24324;ORA-01041

Inkcup

实验环境
Oracle Linux 7.9

安装软件：
Oracle database 11.2.0.4

节点设置：
主库：dbserver  192.168.133.111
备库：db_dg      192.168.133.112

                               
登录/注册后可看大图

启动备库为nomount状态时，出现如下报错：

[oracle@db_dg dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 9 05:17:19 2025

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> STARTUP NOMOUNT PFILE='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/initorcl.ora';

ORA-03135: connection lost contact

SQL>  STARTUP NOMOUNT

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdef extension doesn't exist

解决报错：
检查oracle用户的环境变量设置
$ vim /home/oracle/.bash_profile
#确认LD_LIBRARY_PATH变量设置正确：

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

登录/注册后可看大图