错误如下:
[oracle@localhost database]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Feb 6 14:53:18 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> select status from v$instance;
select status from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number:
解决办法:
1.输入:connect/as sysdba;
2.输入:startup 重起数据库;
正常来说 这样就开启了数据库了。
但是输入startup 却提示
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initora11g.ora'
大概的意思是:无法打开参数文件。(initora11g.ora)
1、进入/u01/app/oracle/product/11.2.0/dbhome_1/dbs/ 发现没有initora11g.ora文件。
[oracle@datatest ~]$ cd /u01/app/oracle/product/11.1.0/dbhome_1/dbs/
[oracle@datatest dbs]$ ls
hc_orcl.dat init.ora lkORCL orapworcl spfileorcl.ora
2、解决此问题的方法就是到cd /home/oracle/app/oracle/admin/orcl/pfile/目录下,将init.ora.15201814236复制到dbs目录下:
cp init.ora.15201814236 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initora11g.ora
注:在复制时有可能会遇到授权问题 用chmod命令: chmod -R 777 目标 /目标文件夹。如:chmod -R 777 init.ora.15201814236 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initora11g.ora(用root用户)
3、su oracle
输入如下命令:cp init.ora.15201814236 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initora11g.ora
4、再重新执行startup 就好了。