这个是个归档路径问题。由于我之前做实验的时候修改了归档日志路径,并且修改错了。解决办法很简单,修改pfile即可。[@more@]
报错过程:
[oracle@STPACS ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 17 08:36:10 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux Error: 2: No such file or directory
解决问题过程:
SQL> conn / as sysdba
Connected to an idle instance.
SQL> create pfile from spfile;
File created.
SQL> host
[oracle@STPACS ~]$ cd $ORACLE_HOME/dbs
[oracle@STPACS dbs]$ vi initpacs2.ora
[oracle@STPACS dbs]$ exit
exit
SQL> create spfile from pfile;
File created.
SQL> startup
ORACLE instance started.
Total System Global Area 524288000 bytes
Fixed Size 1220384 bytes
Variable Size 142606560 bytes
Database Buffers 373293056 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.