[RAC]环境变量与实例设置SID不同导致的报错 - 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

9231867f39fc5d29c4.png (169.87 KB, 下载次数: 505)

2025-4-7 17:49 上传

如果在oracle用户的环境变量文件.bash_profile中，所设置的ORACLE_SID与安装时所设置的不一样的话，

8871367f3a0144cbdb.png (48.15 KB, 下载次数: 441)

2025-4-7 17:51 上传

比如将上图中相关参数改为"orcl4"

就会导致如下的报错：

[oracle@rac4 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 7 04:39:57 2025

Connected to an idle instance.

SQL> startup mount;

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0.4/db_1/dbs/initorcl4.ora'

查找相关文件会发现：

[root@rac4 bin]# ll /u01/app/oracle/product/11.2.0.4/db_1/dbs/

hc_orcl1.dat initorcl1.ora

init.ora orapworcl1

建议先修改环境变量中的SID与安装时一样的参数，然后重启或手动使其生效，详细步骤参考如下：

重启srvctl：

[oracle@rac4 ~]$ srvctl stop instance -d orcl -i orcl1

[oracle@rac4 ~]$ srvctl stop instance -d orcl -i orcl2

[oracle@rac4 ~]$ srvctl start instance -d orcl -i orcl1

[oracle@rac4 ~]$ srvctl start instance -d orcl -i orcl2

[oracle@rac4 ~]$ export ORACLE_SID=orcl1 #在节点rac3中也需要手动输入相应SID

再次测试：

[oracle@rac4 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 7 04:43:34 2025

Connected to:

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

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

重启测试：

7552667f3a1dbb0e31.png (293.56 KB, 下载次数: 511)

2025-4-7 17:58 上传

数据库可以正常启动了。

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)