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
##########################################################################

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22661144/viewspace-1415230/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22661144/viewspace-1415230/