Connected to an idle instance/ ORA-01034/ ORA-27101

连接oracle

# su oracle

$ sqlplus /nolog

SQL> conn / as sysdba;

Connected to an idle instance.

SQL> startup;

ORA-01078:failure in processing system parameters

LRM-00109:could not open parameter file '****/initorcl.ora'

　　将$ORACLE_HOME/admin/数据库名称/pfile目录下的init.ora 文件复制到 $ORACLE_HOME/dbs目录下 即可，

　　修改文件名为“initorcl.ora" orcl是我的实例名ORACLE_SID
SQL> startup
ORACLE instance started.

...

 

转载于:https://www.cnblogs.com/tqspring/archive/2010/06/01/1748871.html