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.

...

 

posted @ 2010-06-01 10:21  TQ.CH  阅读(1356)  评论(0编辑  收藏  举报