[oracle@localhost ~]$ rlwrap sqlplus "/ as sysdba" rlwrap: warning: your $TERM is 'xterm' but rlwrap couldn't find it in the terminfo database. Expect some problems.SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 27 17:40:05 2015Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.SQL> show parameter LOG_ARCHIVE_DEST_3 ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 SQL>
LOG_ARCHIVE_DEST_X参数错的话,nomount都不行。 ORACLE_SID=你的sid sqlplus / as sysdba create pfile from spfile; exit; 修改你的init你的SID.ora文件,把里面的 LOG_ARCHIVE_DEST_3 先注释掉。 然后 sqlplus / as sysdba create spfile from pfile; startup ; 当然既然你的 LOG_ARCHIVE_DEST_3之前有值,如果 LOG_ARCHIVE_DEST_3之前指向的是本地的话,看看对应的路径有没有问题先,如果路径问题解决,就不用上面的操作,直接再试试startup就可以了。
[oracle@localhost ~]$ rlwrap sqlplus "/ as sysdba"
rlwrap: warning: your $TERM is 'xterm' but rlwrap couldn't find it in the terminfo database. Expect some problems.SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 27 17:40:05 2015Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.SQL> show parameter LOG_ARCHIVE_DEST_3
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL>
ORACLE_SID=你的sid
sqlplus / as sysdba
create pfile from spfile;
exit;
修改你的init你的SID.ora文件,把里面的 LOG_ARCHIVE_DEST_3 先注释掉。
然后
sqlplus / as sysdba
create spfile from pfile;
startup ;
当然既然你的 LOG_ARCHIVE_DEST_3之前有值,如果 LOG_ARCHIVE_DEST_3之前指向的是本地的话,看看对应的路径有没有问题先,如果路径问题解决,就不用上面的操作,直接再试试startup就可以了。