oracle怎么启memory,oracle参数MEMORY_TARGET太小无法启动的解决过程

环境：

windows server 2008 datacenter 4G，4x2=8处理器

oracle 11g

错误如下

ORA-00838: 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，提示已经有个启动进程中，文件无法加锁，就重启了服务器；

重启服务器后再测试，可以启动了：

再利用pfile创建 spfile

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

可直接重启