重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛
标题: 【报错解决】ORA-03135;ORA-24324;ORA-01041 [打印本页]
作者: Inkcup 时间: 前天 15:05
标题: 【报错解决】ORA-03135;ORA-24324;ORA-01041
实验环境
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
