刚才在10g上试了一下,改了后,没启来!怀疑!
[php]SQL> alter system set user_dump_dest='' scope=spfile;
System altered.
SQL> startup force;
ORA-00600: internal error code, arguments: [skgasti_2], [], [], [], [], [], [], []
SQL> select sysdate from dual;
select sysdate from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL> conn /as sysdba
Connected to an idle instance.
SQL> create pfile='c:\init.ora' from spfile;
File created.
SQL> create spfile from pfile='c:\init.ora';
File created.
SQL> startup
ORACLE instance started.
Total System Global Area209715200
bytes
Fixed Size
788188
bytes
Variable Size
196081956
bytes
Database Buffers 12582912
bytes
Redo Buffers
262144
bytes
Database mounted.
Database opened.
SQL>
SQL>[/php]
|