ORA-00845: MEMORY_TARGET not supported on this system

原创 2015年07月07日 23:41:16



[main] [ 2015-07-07 17:08:25.109 EDT ] [UsmcaLogger.logException:164] SEVERE:method oracle.sysman.assistants.usmca.backend.USMInstance:configureLocalASM[main] [ 2015-07-07 17:08:25.109 EDT ] [UsmcaLogger.logException:165] ORA-00845: MEMORY_TARGET not supported on this system[main] [ 2015-07-07 17:08:25.109 EDT ] [UsmcaLogger.logException:166] oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-00845: MEMORY_TARGET not supported on this system


node112c:/u01/app/grid/diag/asm/+asm/+ASM1/trace$ df -kFilesystem 1K-blocks Used Available Use% Mounted on/dev/mapper/VolGroup-lv_root 26423572 14864780 10216536 60% /tmpfs 957344 0 957344 0% /dev/shm/dev/sda1 495844 38169 432075 9% /boot

[root@node112c install]# /u01/11.2.0/grid/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params
2015/07/07 17:05:28 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.

2015/07/07 17:05:54 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2015/07/07 17:05:55 CLSRSC-363: User ignored prerequisites during installation

OLR initialization - successful
2015/07/07 17:06:19 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.conf'

CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.evmd' on 'node112c'
CRS-2672: Attempting to start 'ora.mdnsd' on 'node112c'
CRS-2676: Start of 'ora.mdnsd' on 'node112c' succeeded
CRS-2676: Start of 'ora.evmd' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'node112c'
CRS-2676: Start of 'ora.gpnpd' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node112c'
CRS-2672: Attempting to start 'ora.gipcd' on 'node112c'
CRS-2676: Start of 'ora.cssdmonitor' on 'node112c' succeeded
CRS-2676: Start of 'ora.gipcd' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node112c'
CRS-2672: Attempting to start 'ora.diskmon' on 'node112c'
CRS-2676: Start of 'ora.diskmon' on 'node112c' succeeded
CRS-2676: Start of 'ora.cssd' on 'node112c' succeeded

ASM failed to start. Check /u01/app/grid/cfgtoollogs/asmca/asmca-150707PM050758.log for details.

2015/07/07 17:08:25 CLSRSC-184: Configuration of ASM failed

2015/07/07 17:08:25 CLSRSC-258: Failed to configure and start ASM

Died at /u01/11.2.0/grid/crs/install/crsinstall.pm line 2017.
The command '/u01/11.2.0/grid/perl/bin/perl -I/u01/11.2.0/grid/perl/lib -I/u01/11.2.0/grid/crs/install /u01/11.2.0/grid/crs/install/rootcrs.pl ' execution failed
[root@node112c install]# mount -t tmpfs shmfs -o size=7g /dev/shm
[root@node112c install]# df -k
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/mapper/VolGroup-lv_root
                      26423572  14864964  10216352  60% /
tmpfs                  7340032         0   7340032   0% /dev/shm
/dev/sda1               495844     38169    432075   9% /boot
shmfs                  7340032         0   7340032   0% /dev/shm
[root@node112c install]# /u01/11.2.0/grid/crs/install/rootcrs.pl -deconfig -force
Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params
PRCR-1070 : Failed to check if resource ora.net1.network is registered
CRS-0184 : Cannot communicate with the CRS daemon.
PRCR-1070 : Failed to check if resource ora.helper is registered
CRS-0184 : Cannot communicate with the CRS daemon.
PRCR-1070 : Failed to check if resource ora.ons is registered
CRS-0184 : Cannot communicate with the CRS daemon.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'node112c'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'node112c'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'node112c'
CRS-2677: Stop of 'ora.mdnsd' on 'node112c' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'node112c' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'node112c'
CRS-2673: Attempting to stop 'ora.ctssd' on 'node112c'
CRS-2673: Attempting to stop 'ora.evmd' on 'node112c'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'node112c'
CRS-2677: Stop of 'ora.drivers.acfs' on 'node112c' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'node112c' succeeded
CRS-2677: Stop of 'ora.evmd' on 'node112c' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'node112c' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node112c'
CRS-2677: Stop of 'ora.cssd' on 'node112c' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'node112c'
CRS-2677: Stop of 'ora.gipcd' on 'node112c' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'node112c' has completed
CRS-4133: Oracle High Availability Services has been stopped.
2015/07/07 17:22:56 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector.

2015/07/07 17:23:07 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector.

error: package cvuqdisk is not installed
2015/07/07 17:23:07 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node

[root@node112c install]# /u01/11.2.0/grid/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params
2015/07/07 17:31:21 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.

2015/07/07 17:31:46 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2015/07/07 17:31:46 CLSRSC-363: User ignored prerequisites during installation

OLR initialization - successful
2015/07/07 17:32:10 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.conf'

CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.evmd' on 'node112c'
CRS-2672: Attempting to start 'ora.mdnsd' on 'node112c'
CRS-2676: Start of 'ora.evmd' on 'node112c' succeeded
CRS-2676: Start of 'ora.mdnsd' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'node112c'
CRS-2676: Start of 'ora.gpnpd' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node112c'
CRS-2672: Attempting to start 'ora.gipcd' on 'node112c'
CRS-2676: Start of 'ora.cssdmonitor' on 'node112c' succeeded
CRS-2676: Start of 'ora.gipcd' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node112c'
CRS-2672: Attempting to start 'ora.diskmon' on 'node112c'
CRS-2676: Start of 'ora.diskmon' on 'node112c' succeeded
CRS-2676: Start of 'ora.cssd' on 'node112c' succeeded

ASM created and started successfully.

Disk Group OCR_VOTE created successfully.

CRS-2672: Attempting to start 'ora.crf' on 'node112c'
CRS-2672: Attempting to start 'ora.storage' on 'node112c'
CRS-2676: Start of 'ora.storage' on 'node112c' succeeded
CRS-2676: Start of 'ora.crf' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'node112c'
CRS-2676: Start of 'ora.crsd' on 'node112c' succeeded
CRS-4256: Updating the profile
Successful addition of voting disk 20044c2321064f83bfda533729e97601.
Successfully replaced voting disk group with +OCR_VOTE.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   20044c2321064f83bfda533729e97601 (/dev/vote1) [OCR_VOTE]
Located 1 voting disk(s).
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'node112c'
CRS-2673: Attempting to stop 'ora.crsd' on 'node112c'
CRS-2677: Stop of 'ora.crsd' on 'node112c' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'node112c'
CRS-2673: Attempting to stop 'ora.storage' on 'node112c'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'node112c'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'node112c'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'node112c'
CRS-2677: Stop of 'ora.storage' on 'node112c' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'node112c' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'node112c' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'node112c'
CRS-2673: Attempting to stop 'ora.evmd' on 'node112c'
CRS-2673: Attempting to stop 'ora.asm' on 'node112c'
CRS-2677: Stop of 'ora.gpnpd' on 'node112c' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'node112c' succeeded
CRS-2677: Stop of 'ora.crf' on 'node112c' succeeded
CRS-2677: Stop of 'ora.evmd' on 'node112c' succeeded
CRS-2677: Stop of 'ora.asm' on 'node112c' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'node112c'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'node112c' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node112c'
CRS-2677: Stop of 'ora.cssd' on 'node112c' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'node112c'
CRS-2677: Stop of 'ora.gipcd' on 'node112c' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'node112c' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start 'ora.mdnsd' on 'node112c'
CRS-2672: Attempting to start 'ora.evmd' on 'node112c'
CRS-2676: Start of 'ora.mdnsd' on 'node112c' succeeded
CRS-2676: Start of 'ora.evmd' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'node112c'
CRS-2676: Start of 'ora.gpnpd' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'node112c'
CRS-2676: Start of 'ora.gipcd' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node112c'
CRS-2676: Start of 'ora.cssdmonitor' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node112c'
CRS-2672: Attempting to start 'ora.diskmon' on 'node112c'
CRS-2676: Start of 'ora.diskmon' on 'node112c' succeeded
CRS-2676: Start of 'ora.cssd' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'node112c'
CRS-2672: Attempting to start 'ora.ctssd' on 'node112c'
CRS-2676: Start of 'ora.ctssd' on 'node112c' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'node112c'
CRS-2676: Start of 'ora.asm' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'node112c'
CRS-2676: Start of 'ora.storage' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'node112c'
CRS-2676: Start of 'ora.crf' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'node112c'
CRS-2676: Start of 'ora.crsd' on 'node112c' succeeded
CRS-6023: Starting Oracle Cluster Ready Services-managed resources
CRS-6017: Processing resource auto-start for servers: node112c
CRS-6016: Resource auto-start has completed for server node112c
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2015/07/07 17:37:27 CLSRSC-343: Successfully started Oracle Clusterware stack

CRS-2672: Attempting to start 'ora.asm' on 'node112c'
CRS-2676: Start of 'ora.asm' on 'node112c' succeeded
CRS-2672: Attempting to start 'ora.OCR_VOTE.dg' on 'node112c'
CRS-2676: Start of 'ora.OCR_VOTE.dg' on 'node112c' succeeded
Preparing packages for installation...
cvuqdisk-1.0.9-1
2015/07/07 17:38:44 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded


Oracle 11g ORA-00845: MEMORY_TARGET not supported on this system 说明

启动Oracle 11gR2后报错:ORA-00845 rac1:/home/oracle> sqlplus / as sysdba;SQL*Plus: Release 11.2.0.3.0 Prod...
  • tianlesoftware
  • tianlesoftware
  • 2012年02月14日 10:07
  • 21204

Oracle的memory_max_target和memory_target修改和ORA-00845: MEMORY_TARGET not supported on this system错误解决

修改Oracle的memory_max_target和memory_target 最初安装Orale11g时,采用默认自动内存管理,使用1/2Mem。后来想增大最大内存使用值。 系统内存16G M...
  • sunny05296
  • sunny05296
  • 2017年02月22日 20:04
  • 1454

ORA-00845: MEMORY_TARGET not supported on this system

[main] [ 2015-07-07 17:08:25.109 EDT ] [UsmcaLogger.logException:164] SEVERE:method oracle.sysman.as...
  • songyongbo_107
  • songyongbo_107
  • 2015年07月07日 23:41
  • 1312

ORA-00845 : MEMORY_TARGET not supported on this system(调大数据库内存无法启动)

问题描述:调大数据库内存后,启动数据库报 ORA-00845 : MEMORY_TARGET not supported on this system 。 -- 调大数据库内存后,数据库启动报错...
  • zhang123456456
  • zhang123456456
  • 2017年08月08日 22:05
  • 402

ORA-00845: MEMORY_TARGET not supported on this system问题处理

1,oracle11g设置归档重新登录启动报错SQL> startup;
  • mchdba
  • mchdba
  • 2015年11月27日 00:01
  • 4622

Oracle 11gR2 RAC ORA-00845 MEMORY_TARGET not supported on this system 解决方法

公司刚上线一套Oracle 11gR2 的RAC。 将MEMORY_TARGET内存设置为12G后,启动的时候报了错误:       ORA-00845: MEMORY_TARGET not supp...
  • tianlesoftware
  • tianlesoftware
  • 2010年11月17日 01:23
  • 14982

实例启动时报ORA-00845的解决方法

idle> startup ORA-00845: MEMORY_TARGET not supported on this system 因为我一个库里有两个实例,启动时/dev/shm就不够用了。 ...
  • rlhua
  • rlhua
  • 2013年10月28日 14:57
  • 15770

ORA-00845: MEMORY_TARGET not supported on this system

新装一台Oracle 11g的数据库,打算将SGA设大一点,知道 11g 中有一个新特新 MEMORY_TARGET,于是尝一下鲜,谁知报了个 ORA-00845,报错比较容易迷惑人,不借助Googl...
  • jumewo
  • jumewo
  • 2013年08月27日 21:26
  • 633

ORA-00845:MEMORY_TARGET not supported on this system

11g设置内存大小如下: memory_target=2048000000 在启动的过程中报ORA-00845 SQL> startup ORA-00845: MEMORY_TARGET no...
  • tanqingru
  • tanqingru
  • 2014年11月18日 15:48
  • 659

在Linux上的虚拟机上启动Oracle上报ORA-00845: MEMORY_TARGET not supported on this system的问题解决

解决办法:1、将当前虚拟机的内容调整大一些(以下转载:http://jingyan.baidu.com/article/414eccf67b8baa6b421f0a60.html)VMware虚拟机:...
  • toto1297488504
  • toto1297488504
  • 2016年10月10日 19:39
  • 1076
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:ORA-00845: MEMORY_TARGET not supported on this system
举报原因:
原因补充:

(最多只允许输入30个字)