oracle11g ORA-32002

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>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-753598/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-753598/