我的环境是redhat as5 64bit,oracle10g 64bit,物理内存是8G,今天调整了SGA的大小,在EM中修改sga_max_size由原来的1760M增加到2048M,sga_target也由原来的1760M增加到2048M,后重启数据库后报错:
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
SQL> shutdown immediate;
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory谢谢高手指点怎么能将数据库起动起来!!!!!!!
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
SQL> shutdown immediate;
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory谢谢高手指点怎么能将数据库起动起来!!!!!!!
$sqlplus "/as sysdba"
sql>create pfile='/u01/init.ora' from spfile
2.修改pfile文件,将参数修改为原来的正常值
3.生成spfile
sql>create spfile from pfile='/u01/init.ora'
4.启动数据库
sql>startup
ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
你要在上面第2步修改pfile时给DB_RECOVERY_FILE_DEST_SIZE指定一个值,如
DB_RECOVERY_FILE_DEST_SIZE=2000M
create spfile from pfile;
shutdown immediate
startup
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
=================================================================================
先设置 DB_RECOVERY_FILE_DEST_SIZE 大小
再设置 DB_RECOVERY_FILE_DEST 位置
设置db_recovery_file_dest_size:alter system set db_recovery_file_dest_size=3G;