ORA-00845 When Starting Up An 11g Instance With AMM Configured
今天一個11.2版本 for linux x86_64 測試庫啟動時報以下錯誤ORA-00845錯誤
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 22 14:48:01 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
SQL>
SQL>
透過查metalink id 460506.1 , 確認為虛擬交換記憶體太少,不能低與sga_max_size與pga_max_size之和,一定要比這兩個大
[oracle@rac1 ~]$ df -m
Filesystem 1M-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
62832 24262 35327 41% /
/dev/sda1 99 13 82 14% /boot
tmpfs 1024 1024 0 100% /dev/shm
[oracle@rac1 ~]$
可以看到tmpfs檔案系統已經不夠用了
透過編輯/etc/fstab檔案,對tmpfs檔案系統加大到2G
/dev/VolGroup00/LogVol00 / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults,size=2048M 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
/dev/VolGroup00/LogVol01 swap swap defaults 0 0
umount /dev/shm
mount /dev/shm
然後啟動資料庫正常
SQL> show parameter mem
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 1216M
memory_target big integer 1216M
shared_memory_address integer 0
SQL>
memory_max_target的大小設定已經超過1G了,所以tmpfs檔案系統容量一定要加大
根據實體記憶體的大小,進行適當的擴充套件。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-668759/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-15055 Unable to Connect to ASM When Starting an InstanceASM
- 3.1.5.2 Starting an Instance, and Mounting and Opening a DatabaseDatabase
- 11g AMM和/dev/shmdev
- ASM Spfile Is Not Used when ASM Instance StartsASM
- HugePages與AMM不相容:ORA-00845: MEMORY_TARGET not supported on this system
- Oracle 11g AMM與ASMM切換OracleASM
- Login Oracle Instance Even When sysdba Cannot Do SoOracle
- android-Building a Notification,Preserving Navigation when Starting an ActivityAndroidUINavigation
- ORA-19599 When Backing up an Archivelog that is CorruptHive
- ORA-19527 reported in Standby Database when starting Managed Recovery_352879.1Database
- ''Sbt Error = 7011, Errno = 959'' Error When Backing Up To TapeError
- Linux 11G RAC啟用HugePages與AMM的禁用Linux
- Linux Hugepage ,AMM及 USE_LARGE_PAGES for oracle 11GLinuxOracle
- [Oracle] oracle 11g dataguard (one instance)Oracle
- Does Not Delete Archivelogs Even When They Already Backed Up To Tape_1607250.1deleteHive
- Oracle 11g新引數USE_LARGE_PAGES與AMM使用Oracle
- Linux下安裝Oracle11g , MEMORY_TARGET(AMM)小於/dev/shm處理(ORA-00845)LinuxOracledev
- 【AMM】關於ASM中AMM引數說明ASM
- 11g parallel_instance_group 'cursor: mutex S'ParallelMutex
- Oracle 11g報錯"ORA-00845: MEMORY_TARGET not supported on this system"Oracle
- oracle 11g報錯ORA-00845: MEMORY_TARGET not supported on this systemOracle
- 解決Linux上11g的ORA-00845錯誤Linux
- AMM與ASMMASM
- Troubleshooting when srvctl can't start RAC instance, but sqlplus can start it [ID 844272.1]SQL
- Add Node/Instance Remove Node/Instance in 10gR2 11g Clusterware RAC_1332451.1REM
- Oracle ASMM和AMMOracleASM
- 【AMM】關於資料庫例項AMM引數說明資料庫
- How to create user for oracle10g/11g asm instanceOracleASM
- oracle 11g之instance自動啟動設定Oracle
- No CurrentSessionContext configuredSessionContext
- 關於ASMM和AMMASM
- ASMCA fails to create 11.2 ASM instance when upgrading from 10.2 [ID 1125053.1]ASMAI
- Starting & Stopping SAP
- Starting HAL daemon:[FAILED]AI
- ORA-00845 解決
- TNS-12537, TNS-12560, TNS-00507 Linux Error: 29: Illegal seek error When Starting the ListenerLinuxError
- wake up
- Level Up