oracle参数MEMORY_TARGET太小无法启动的解决过程

时间:2023-03-09 00:50:46
oracle参数MEMORY_TARGET太小无法启动的解决过程

环境:

windows server  datacenter 4G,4x2=8处理器
oracle 11g

错误如下

ORA-: Specified value of MEMORY_TARGET is too small, needs to be at least 936M

创建文件

create pfile='$ORACLE_HOME/dbs/spfileorcl_bak.ora' from spfile;

该文件的内容如下:

orcl.__db_cache_size=1543503872
orcl.__java_pool_size=33554432
orcl.__large_pool_size=50331648
orcl.__oracle_base='C:\app\Administrator'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=1375731712
orcl.__sga_target=2063597568
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=402653184
orcl.__streams_pool_size=0
*.audit_file_dest='C:\app\Administrator\admin\orcl\adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='C:\oradata\orcl\control01.ctl','C:\oradata\orcl\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.deferred_segment_creation=FALSE
*.diagnostic_dest='C:\app\Administrator'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.log_archive_dest_1='LOCATION=C:\archivelog'
*.log_archive_format='ARC%S_%R.%T'
*.memory_target=536870912
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=1000
*.processes=1000
*.remote_login_passwordfile='EXCLUSIVE'
*.sec_case_sensitive_logon=FALSE
*.sessions=2000
*.sga_max_size=209715200
*.undo_tablespace='UNDOTBS1'

512M
修改为1073741824
即1G

修改后保存

startup pfile='C:/app/Administrator/product/11.2.0/dbhome_1/dbs/spfileorcl_bak.ora';

卡了挺长时间的;
一直在启动中,后面关掉重新startup,提示已经有个启动进程中,文件无法加锁,就重启了服务器;
重启服务器后再测试,可以启动了:

oracle参数MEMORY_TARGET太小无法启动的解决过程

再利用pfile创建 spfile

create spfile from pfile='C:/app/Administrator/product/11.2.0/dbhome_1/dbs/spfileorcl_bak.ora';

可直接重启

oracle参数MEMORY_TARGET太小无法启动的解决过程