conn / as sysdba;startup nomount;alter system set sga_max_size=1G scope=spfile;shutdown immediate;startup
手动删除SPFILE文件,然后使用文本工具编辑PFILE文件,使用PFILE文件启动。 STARTUP NOMOUNT CREATE SFPILE FROM PFILE SHUTDOWN .. STARTUPALTER SYSTEM ...SHUTDOWN .. STARTUPok.
SQL> alter system set sga_max_si alter system set sga_max_size=1G * 第 1 行出现错误: ORA-01034: ORACLE not available
QL> startup nomount; RA-01078: failure in processing system parameters RA-01565: error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfilebonchilora.ora' RA-27046: file size is not a multiple of logical block size SD-04012: ?????????????? (OS 3557) QL> alter system set sga_max_size=1G scope=spfile; lter system set sga_max_size=1G scope=spfile?1 行出现错误: RA-01034: ORACLE not available
1. conn / as sysdba2. create pfile='d:\pfile.txt' from spfile;3. 编辑d:\pfile.txt4. startup pfile='d:\pfile.txt';5. create spfile from pfile;6. 重启数据库,用正常的命令就可以
STARTUP NOMOUNT
CREATE SFPILE FROM PFILE
SHUTDOWN ..
STARTUPALTER SYSTEM ...SHUTDOWN ..
STARTUPok.
alter system set sga_max_size=1G
*
第 1 行出现错误:
ORA-01034: ORACLE not available
QL> startup nomount;
RA-01078: failure in processing system parameters
RA-01565: error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfilebonchilora.ora'
RA-27046: file size is not a multiple of logical block size
SD-04012: ?????????????? (OS 3557)
QL> alter system set sga_max_size=1G scope=spfile;
lter system set sga_max_size=1G scope=spfile?1 行出现错误:
RA-01034: ORACLE not available
1.
conn / as sysdba2.
create pfile='d:\pfile.txt' from spfile;3.
编辑d:\pfile.txt4.
startup pfile='d:\pfile.txt';5.
create spfile from pfile;6.
重启数据库,用正常的命令就可以
C:\oracle\product\10.2.0\db_1/dbs/spfilebonchilora.ora然后,手工把这个文件中相关的内存的数据改回去,再重启
这是正解,startup nomount的时候就会load spfile,并分配内存了,所以nomount这个状态肯定是不行的了解决方法
如5楼的方法就可以了。也可以直接用修改好pfile直接create spfile然后冲spfile启动。
这里也有解决问题的实例
http://www.inthirties.com/?p=438