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/，如需轉載，請注明出處，否則將追究法律責任。

創作挑戰賽新人創作獎勵來咯，堅持創作打卡瓜分現金大獎

總結

以上是生活随笔為你收集整理的oracle11g memory_target,Oracle11g启动报：ORA-00845: MEMORY_TARGET not supported on this system的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。