Ora-27102 Linux-x86_64 Error
Contents |
- ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device SQL> startupORA-27102: out of memoryLinux-x86_64 Error: 28: No
Ora-27102 Out Of Memory Linux-x86_64 Error 12
space left on deviceI have used RHEL X86_64 + memory (32GB) ora-27102: out of memory linux-x86_64 error: 28: no space left on device and setted sga_max_size=20G + sga_target=20G and ...$ cat /proc/sys/kernel/shmmax26843545600What wrong with my kernel tuning... So, I checked metalink
Ora-27102 Out Of Memory Solaris
(301830.1) and some recommend from RHELThey told; set SHMALL to the total amount of physical RAM divided by page size.SHMALL =>Total amount of shared memory available (bytes or pages)then:Check ora-27102 out of memory solaris 11 Page Size:$ getconf PAGE_SIZE4096Determine the system wide maximum number of shared memory pages:$ cat /proc/sys/kernel/shmall2097152My system 64bits with memory 32GB, then 1024 * 1024 * 1024 * 32 / 4096 = 8388608So, change kernel.shmall = 8388608$ su - root # echo 8388608 > /proc/sys/kernel/shmallOr modify /etc/sysctl.conf file:kernel.shmall=8388608and # sysctl -pAfter changed... check and startup database again:$ cat /proc/sys/kernel/shmall8388608SQL> startup...--- ora-27102 out of memory windows NO ERROR ---By the way, I read Tuning Red Hat Enterprise Linux: Oracle and Oracle RACFrom this idea with memory 32GBmem=$(free|grep Mem|awk '{print$2}')totmem=$(echo "$mem*1024"|bc)huge=$(grep Hugepagesize /proc/meminfo|awk '{print $2}')max=$(echo "$totmem*75/100"|bc)all=$(echo "$max/$huge"|bc)echo "kernel.shmmax = $max" echo "kernel.shmall = $all" Result:kernel.shmmax = 25213120512, kernel.shmall = 12311094However, This case "ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device" , solved by set SHMALL = MemTotal(byte)/PAGE_SIZE and ...I hope to hear your idea about kernel tuning with Oracle Database. เขียนโดย Surachart Opun ที่ 10:14 PM ป้ายกำกับ: 10g, linux, ora, oracle No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) View Surachart Opun's profile (surachart at gmail dot com) Search This Blog Loading... Feed Me! Posts Atom Posts Comments Atom Comments Blog Archives Blog Archives 09/11 - 09/18 (1) 01/17 - 01/24 (1) 05/24 - 05/31 (2) 12/21 - 12/28 (1) 11/30 - 12/07 (1) 11/16 - 11/23 (2) 10/26 - 11/02 (1) 10/19 - 10/26 (1) 10/05 - 10/12 (2) 09/28 - 10/05 (1) 09/21 - 09/28 (3) 09/14 - 0
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript
Linux-x86_64 Error: 12: Cannot Allocate Memory
back on and reload this page. Please enter a title. linux-x86_64 error 28 no space left on device rman You can not post a blank message. Please type your message and try again. More discussions
Ora 27102 Out Of Memory Oracle 11g Windows
in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 11 Replies Latest reply on Feb 24, 2015 12:38 PM by 12cdb Out of http://surachartopun.com/2009/10/shared-memory-tuning-startup-database.html Memory 2888673 Feb 20, 2015 7:53 AM Dear everyone,Once in a week our db breaks down with the following error:ORA-01034: ORACLE not availableORA-27102: out of memoryLinux-x86_64 Error: 12: Cannot allocate memoryAdditional information: 2Additional information: 786443Additional information: 1660944384I am not a oracle crack, so any help is appreciated.RegardsTobiulimit -a:core file size (blocks, -c) 0data https://community.oracle.com/thread/3676671 seg size (kbytes, -d) unlimitedscheduling priority (-e) 0file size (blocks, -f) unlimitedpending signals (-i) 63696max locked memory (kbytes, -l) 64max memory size (kbytes, -m) unlimitedopen files (-n) 1024pipe size (512 bytes, -p) 8POSIX message queues (bytes, -q) 819200real-time priority (-r) 0stack size (kbytes, -s) 10240cpu time (seconds, -t) unlimitedmax user processes (-u) 16384virtual memory (kbytes, -v) unlimitedfile locks (-x) unlimited/etc/sysctl.conf:# Kernel sysctl configuration file for Red Hat Linux## For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and# sysctl.conf(5) for more details.# Controls IP packet forwardingnet.ipv4.ip_forward = 0# Controls source route verificationnet.ipv4.conf.default.rp_filter = 1# Do not accept source routingnet.ipv4.conf.default.accept_source_route = 0# Controls the System Request debugging functionality of the kernelkernel.sysrq = 0# Controls whether core dumps will append the PID to the core filename.# Useful for debugging multi-threaded applications.kernel.core_uses_pid = 1# Controls the use of TCP syncookiesnet.ipv4.tcp_syncookies = 1# Disable netfilter on bridges.net.bridge.bridge-nf-call-ip6tables = 0net.bridge.bridge-nf-call-iptables = 0net.bridge.bridge-nf-call-arptables = 0# Controls the default maxmimum s
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have https://community.oracle.com/community/developer/search.jspa?q=ORA-27102 JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle out of VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace out of memory depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 201604