Home  >  Article  >  Database  >  rhel 5.10下安装oracle 11g R1 启动数据库报错问题解决方法

rhel 5.10下安装oracle 11g R1 启动数据库报错问题解决方法

WBOY
WBOYOriginal
2016-06-07 15:31:301163browse

[oracle@timran ~]$ sqlplus / as sysdba SQL*Plus: Release 11.1.0.6.0 - Production on 星期一 2月 9 13:49:25 2015 Copyright (c) 1982, 2007, Oracle. All rights reserved. 已连接到空闲例程。 SQL startup ORA-01078: failure in processing system par

[oracle@timran ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on 星期一 2月 9 13:49:25 2015

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

已连接到空闲例程。

SQL> startup
ORA-01078: failure in processing system parameters

LRM-00109: ???????????????????????? '/u01/oracle/dbs/inittimran11g.ora'

提示系统参数故障,无法打开/u01/oracle/dbs/inittimran11g.ora文件。


打开.bash_profile环境变量,查看如下行

ORACLE_BASE=/u01
ORACLE_HOME=$ORACLE_BASE/oracle
ORACLE_SID=oracle11                //检查SID是否和先用的数据库名称一样
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH


修改完后执行source .bash_profile,使变量生效。

退出用户重新登录。

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn