startupLinux下oracle报以下错ORA-27102:outofmemoryLinux-X86_64Error:28:Nospaceleftondevice[ID301830.1]适用于:OracleServer-EnterpriseEdition-Version:9.2.0.1andlater[Release:9.2andlater]OracleServer-StandardEdition-Version:9.2.0.1andlater[Release:9.2andlater]OracleServer-EnterpriseEdition-Version:9.2.0.1andlater[Release:9.2andlater]Linuxx86-64WhentryingtoincreasetheSGAtoapproachhalfavailableRAMwithanOracle64-bitversiononaLinux64-bitoperatingsystem,eventhoughshmmaxissettomatchhalftheamountofRAM,yougetthefollowingerrorwhentryingtostarttheinstance:在64位linux下使用64位版本的oracle，即使把shmmax参数的大小设置系统可用内存的一半，当把SGA增加到接近一半的系统内存时候，当startup实例的时候，可能得到以下错误SQL>startupnomountORA-27102:outofmemoryLinux-x86_64Error:28:NospaceleftondeviceChangesshmallistoosmall,mostlikelyissettothedefaultsettingof2097152$cat/proc/sys/kernel/shmall2097152Causeshmallisthetotalamountofsharedmemory,inpages,thatthesystemcanuseatonetime.shmall是系统在所有页同一时间使用的共享内存段的总数Solution解决办法SetshmallequaltothesumofalltheSGAsonthesystem,dividedbythepagesize.设定shmall的值为等同于在系统中所有SGA占用内存大小除以分页大小的得出的最后的值Thepagesizecanbedeterminedusingthefollowingcommand:用以下命令得到分页的大小$getconfPAGE_SIZE4096Forexample,ifthesumofalltheSGAsonthesystemis16Gbandtheresultof'$getconfPAGE_SIZE'is4096(4Kb)thensetshmallto4194304pages例如，如果系统中所有SGA的综合为16Gb,然后getconfPAGE_SIZE得出的结果是4096（4k）那么shmall就设定为4194304页Astherootusersettheshmallto4194304inthe/etc/sysctl.conffile:用root用户在/etc/sysctl.conf文件中设定shmall为4194304kernel.shmall=4194304thenrunthefollowingcommand:设定后执行以下命令$sysctl-p$cat/proc/sys/kernel/shmall4194304NOTE:Theabovecommandloadsthenewvalueandarebootisnotnecessary.以上命令无须重启Switchbacktobeingtheoracleuserandretrythestartupcommand.切换到oracle用户，重新执行startup命令Modifying/etc/sysctl.confisapermanentworkaround(appliesatboottime).修改/etc/sysctl.conf是一个永久的解决办法（适用于开机时间）IfforsomereasonyouDONOTwanttochangethesystemwideconfiguration,youcandoitontheflybydirectlychangingthekernelpseudoFSAKAprocfs.如果出于某种原因不详对系统大范围改动配置，可以直接改变内核的pseudoFSAKAprocfs.#echo"4194304">/proc/sys/kernel/shmallUsingHUGEPAGESdoesnotalterthecalculationforconfiguringshmall.使用大页不会改变配置shmall的计算结果以上翻译仅供参考ReferencesNOTE:169706.1-OracleDatabaseonUnixAIX,HP-UX,Linux,MacOSX,Solaris,Tru64UnixOperatingSystemsInstallationandConfigurationRequirementsQuickReference(8.0.5to11.2)NOTE:851598.1-MasterNoteofLinuxOSRequirementsforDatabaseServerNOTE:1351051.2-InformationCenter:InstallandConfigureDatabaseServer/ClientInstallationsOracleDatabaseProducts>OracleDatabase>OracleDatabase>OracleServer-EnterpriseEditionOracleDatabaseProducts>OracleDatabase>OracleDatabase>OracleServer-StandardEditionOracleDatabaseProducts>OracleDatabase>OracleDatabase>OracleServer-EnterpriseEdition64-BIT;64BIT;HUGEPAGES;INSTALL&CONFIGURE;LINUX;NOSPACELEFTONDEVICE;OUTOFMEMORY;STARTINSTANCEORA-27102Copyright(c)2007,2010,Oracle.Allrightsreserved.LegalNoticesandTermsofUse|PrivacyStatement