SQL> startup
ORA-01506: missing or illegal database name
SQL> startup nomount pfile=c:\pfile
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size                  2177456 bytes
Variable Size             503318096 bytes
Database Buffers         1627389952 bytes
Redo Buffers                5001216 bytes
SQL> create spfile from pfile=c:\pfile;---要加上單引號
create spfile from pfile=c:\pfile
                         *
ERROR at line 1:
ORA-02236: invalid file name

SQL> create spfile from pfile='c:\pfile';---spfile自nomount狀態已在使用
create spfile from pfile='c:\pfile'
*
ERROR at line 1:
ORA-32002: cannot create SPFILE already being used by the instance

--關庫
SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.

----連線至sqlplus自配置好的pfile建立spfile
SQL> create spfile from pfile='c:\pfile';

File created.

SQL> startup --啟動庫
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size                  2177456 bytes
Variable Size             503318096 bytes
Database Buffers         1627389952 bytes
Redo Buffers                5001216 bytes
Database mounted.
Database opened.
SQL>

oracle11g ORA-32002

相關文章