Oracle10g startup報ORA-27102
Oracle10g startup報ORA-27102
DB版本:10.2.0.4
OS版本:Linux-X86_64
資料庫啟動報錯:
SQL> startup nomount
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
檢視sga,系統引數:
show parameter sga
12G
$ cat /proc/sys/kernel/shmall
2097152
2097152
$ getconf PAGE_SIZE
4096
4096
根據公式12G/4096=3145728,shmall引數至少要設為3145728
我這裡設為4194304
kernel.shmall = 4194304
16G/4096=4194304
then run the following command:
$ sysctl -p
$ cat /proc/sys/kernel/shmall
4194304
$ cat /proc/sys/kernel/shmall
4194304
資料庫啟動成功。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24996904/viewspace-773450/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Upon startup of Linux database get ORA-27102LinuxDatabase
- startup ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on deviceLinuxErrordev
- 啟動oracle10g的多個語句_startup相關Oracle
- startup,startup mount,startup nomount之間的區別
- 【ORACLE】ORA-27102: out of memory報錯的處理Oracle
- StartUp Health:健康行業年中投資報告行業
- startup資料庫報錯ORA-16038資料庫
- startup mount與startup restrict mount有何區別REST
- windows2008作業系統報ora-27102Windows作業系統
- STARTUP FORCE 理解
- Oracle shutdown and startupOracle
- MySQL Server Startup ScriptMySqlServer
- dbca -silent -responsefile 建庫由於tmpfs太小報錯ORA-27102: out of memory
- oracle10g使用10046 報錯Oracle
- Oracle 資料庫啟動 startup和startup force的區別Oracle資料庫
- oracle10201 startup nomount報ora-00600錯Oracle
- Jetpack之Startup快速掌握Jetpack
- oracle-startup過程Oracle
- Oracle startup mount exclusive作用Oracle
- Forced Startup in Abnormal Situations (292)ORM
- Restricting Access to a Database at StartupRESTDatabase
- windows7安裝oracle10g報錯WindowsOracle
- note the ORA-27102: out of memory errorError
- startup migrate、startup upgrade區別以及Oracle打補丁集文件(轉)Oracle
- download startup video in xlzhaoIDE
- Overview of Instance and Database Startup (289)ViewDatabase
- Restricted Mode of Instance Startup (291)REST
- oracle startup(nomount mount open restrict)OracleREST
- ORA-27102: out of memory故障解決
- Unable to startup CRS as ASM failed to startup with "ORA-01017:inval_1681849.1ASMAI
- 啟動Oracle報錯ORA-27102: out of memory、Linux-x86_64 Error: 28: No space leftOracleLinuxError
- 當匯入flutter專案時,報Waiting for another flutter command to release the startup lockFlutterAI
- Oracle startup報錯ORA-03113: end-of-file on communication channel 解決方案Oracle
- Oracle10g 自動生成AWR報告的指令碼Oracle指令碼
- 【ERROR】ORA-27102: out of memory 解決方法Error
- ORA-27102: out of memory解決辦法
- oracle啟動遭遇ORA-27102: out of memoryOracle
- ORA-27102 Out of Memory問題處理