Oracle11g啟動報：ORA-00845: MEMORY_TARGET not supported on this system

SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system

oracle@sles11:/oracle/product/11.2.4/dbs> df -h /dev/shm
Filesystem      Size  Used Avail Use% Mounted on
tmpfs           1.5G   72K  1.5G   1% /dev/shm

--memory_target 大於 /dev/shm 
oracle@sles11:/oracle/product/11.2.4/dbs> strings spfilebsbora.ora |grep -i mem
*.memory_target=1658847232


##########################################################################
解決方法：


--從spfile建立pfile，再修改pfile中的memory_target
oracle@sles11:/oracle/product/11.2.4/dbs> strings spfilebsbora.ora > initbsbora.ora 


oracle@sles11:/oracle/product/11.2.4/dbs> cat initbsbora.ora |grep -i mem
*.memory_target=1358847232


--使用調整完memory_target的pfile建立spfile 
oracle@sles11:/oracle/product/11.2.4/dbs> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 26 10:56:01 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile=initbsbora.ora
ORACLE instance started.

Total System Global Area 1352876032 bytes
Fixed Size                  2253064 bytes
Variable Size            1224740600 bytes
Database Buffers          117440512 bytes
Redo Buffers                8441856 bytes
SQL> 
SQL> select status from v$instance;
STATUS
------------
STARTED

SQL> create spfile from pfile;
File created.

SQL> shutdown abort
ORACLE instance shut down.
SQL> 

--新建立的spfile 
oracle@sles11:/oracle/product/11.2.4/dbs> strings spfilebsbora.ora         
bsbora.__db_cache_size=671088640
bsbora.__java_pool_size=16777216
bsbora.__large_pool_size=33554432
bsbora.__oracle_base='/oracle'#ORACLE_BASE set from environment
bsbora.__pga_aggregate_target=570425344
bsbora.__sga_target=1090519040
bsbora.__shared_io_pool_size=0
bsbora.__shared_pool_size=352321536
bsbora.__streams_pool_size=0
*.audit_file_dest='/oracle/admin/bsbora/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/oradata/bsbora/control01.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='bsbora'
*.db_recovery_file_dest_size=4385144832
*.db_recovery_file_dest=''
*.diagnostic_dest='/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=bsboraXDB)'
*.log_archive_dest_1='location=/archivelog'
*.memory_target=1358847232
*.open_cursors=300
*.processes=1500
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'


--可以看到，現在正常啟動
oracle@sles11:/oracle/product/11.2.4/dbs> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 26 11:04:47 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup 
ORACLE instance started.

Total System Global Area 1352876032 bytes
Fixed Size                  2253064 bytes
Variable Size            1224740600 bytes
Database Buffers          117440512 bytes
Redo Buffers                8441856 bytes
Database mounted.
Database opened.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /archivelog
Oldest online log sequence     3
Next log sequence to archive   5
Current log sequence           5

SQL> select status from v$instance;
STATUS
------------
OPEN
##########################################################################