oracle11g memory_target,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/，如需转载，请注明出处，否则将追究法律责任。