重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: 【升级报错】ORA-01034: ORACLE not available [打印本页]

---

作者: Inkcup    时间: 2025-3-10 15:01
标题: 【升级报错】ORA-01034: ORACLE not available
实验环境：
rhel5.4
操作：
Oracle10g升级11g

---

在完成软件升级界面的运行后，尝试打开数据库，出现报错如下：

SQL> select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from dba_registry order by comp_name;

select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from dba_registry order by comp_name

*

ERROR at line 1:

ORA-01034: ORACLE not available

Process ID: 0

Session ID: 0 Serial number: 0

SQL> startup

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0.1/dbhome_1/dbs/initorcl.ora'

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01034: ORACLE not available

Process ID: 0

Session ID: 0 Serial number: 0

SQL> shutdown immediate;

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

---

于是进入相关位置查验：

发现 '/u01/app/oracle/product/11.2.0.1/dbhome_1/dbs/initorcl.ora'文件并不存在，取而代之的是 '/u01/app/oracle/product/11.2.0.1/dbhome_1/dbs/initORCL10g.ora'
也就是说是环境中的SID设置有问题，需要将其修改为现文件所使用的名字。
修改后重启系统，即可解决报错：

登录/注册后可看大图