ittutorial.org
Open in
urlscan Pro
2606:4700:3030::6815:4440
Public Scan
URL:
https://ittutorial.org/ora-27102-out-of-memory/
Submission: On December 28 via api from CZ — Scanned from DE
Submission: On December 28 via api from CZ — Scanned from DE
Form analysis 5 forms found in the DOM
GET https://ittutorial.org/
<form method="get" id="searchform-mobile" action="https://ittutorial.org/">
<button class="search-button" type="submit" value="Search"><i class="fa fa-search"></i></button>
<input type="text" id="s-mobile" name="s" title="Search" value="Search" onfocus="if (!window.__cfRLUnblockHandlers) return false; if (this.value == 'Search') {this.value = '';}"
onblur="if (!window.__cfRLUnblockHandlers) return false; if (this.value == '') {this.value = 'Search';}">
</form>GET https://ittutorial.org/
<form method="get" id="searchform-header" action="https://ittutorial.org/">
<button class="search-button" type="submit" value="Search"><i class="fa fa-search"></i></button>
<input class="search-live" type="text" id="s-header" name="s" title="Search" value="Search" onfocus="if (!window.__cfRLUnblockHandlers) return false; if (this.value == 'Search') {this.value = '';}"
onblur="if (!window.__cfRLUnblockHandlers) return false; if (this.value == '') {this.value = 'Search';}" autocomplete="off">
</form>POST https://ittutorial.org/wp-comments-post.php
<form action="https://ittutorial.org/wp-comments-post.php" method="post" id="commentform" class="comment-form" novalidate="">
<p class="comment-notes"><span id="email-notes">Your email address will not be published.</span> <span class="required-field-message">Required fields are marked <span class="required">*</span></span></p>
<p class="comment-form-comment"><label for="comment">Comment <span class="required">*</span></label><textarea id="comment" name="comment" cols="45" rows="8" maxlength="65525" required=""></textarea></p>
<p class="comment-form-author"><label for="author">Name <span class="required">*</span></label> <input id="author" name="author" type="text" value="" size="30" maxlength="245" autocomplete="name" required=""></p>
<p class="comment-form-email"><label for="email">Email <span class="required">*</span></label> <input id="email" name="email" type="email" value="" size="30" maxlength="100" aria-describedby="email-notes" autocomplete="email" required=""></p>
<p class="comment-form-url"><label for="url">Website</label> <input id="url" name="url" type="url" value="" size="30" maxlength="200" autocomplete="url"></p>
<p class="form-submit"><input name="submit" type="submit" id="submit" class="submit" value="Post Comment"> <input type="hidden" name="comment_post_ID" value="33860" id="comment_post_ID">
<input type="hidden" name="comment_parent" id="comment_parent" value="0">
</p>
<p style="display: none;"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="1f7fcead42"></p>
<p style="display: none !important;"><label>Δ<textarea name="ak_hp_textarea" cols="45" rows="8" maxlength="100"></textarea></label><input type="hidden" id="ak_js_1" name="ak_js" value="1703783572835">
<script type="text/javascript">
document.getElementById("ak_js_1").setAttribute("value", (new Date()).getTime());
</script>
</p>
</form>GET https://ittutorial.org/
<form role="search" method="get" class="search-form" action="https://ittutorial.org/">
<label>
<span class="screen-reader-text">Search for:</span>
<input type="search" class="search-field" placeholder="Search …" value="" name="s">
</label>
<input type="submit" class="search-submit" value="Search">
</form>GET https://ittutorial.org
<form action="https://ittutorial.org" method="get"><label class="screen-reader-text" for="cat">Categories</label><select name="cat" id="cat" class="postform">
<option value="-1">Select Category</option>
<option class="level-0" value="3">Algoritmalar</option>
<option class="level-0" value="4">Android</option>
<option class="level-0" value="2875">Application</option>
<option class="level-0" value="2880">ASP.NET</option>
<option class="level-0" value="6674">Big Data</option>
<option class="level-0" value="5575">Blockchain</option>
<option class="level-0" value="2876">C</option>
<option class="level-0" value="2879">C#</option>
<option class="level-0" value="2877">C++</option>
<option class="level-0" value="7687">Couchbase</option>
<option class="level-0" value="12904">Data Science</option>
<option class="level-0" value="12300">Data Warehouse</option>
<option class="level-0" value="7">Exadata</option>
<option class="level-0" value="11961">Exchange Server</option>
<option class="level-0" value="2465">Goldengate</option>
<option class="level-0" value="3941">Goldengate Tutorials</option>
<option class="level-0" value="11801">Google</option>
<option class="level-0" value="8">Görüntü İşleme</option>
<option class="level-0" value="2872">HTML</option>
<option class="level-0" value="7520">IIS</option>
<option class="level-0" value="20683">IPTV</option>
<option class="level-0" value="9">Java</option>
<option class="level-0" value="10">Javascript</option>
<option class="level-0" value="11">Linux</option>
<option class="level-0" value="5322">Linux Türkçe</option>
<option class="level-0" value="12">Mikroişlemciler</option>
<option class="level-0" value="6797">MongoDB</option>
<option class="level-0" value="3341">MySQL</option>
<option class="level-0" value="13">Network</option>
<option class="level-0" value="6798">NoSQL</option>
<option class="level-0" value="2700">ODA</option>
<option class="level-0" value="11962">Office 365</option>
<option class="level-0" value="3508">Operating System</option>
<option class="level-0" value="2111">ORA-ERRORS</option>
<option class="level-0" value="1994">Oracle</option>
<option class="level-1" value="5047"> Architecture</option>
<option class="level-1" value="7586"> ASM</option>
<option class="level-1" value="5084"> Dataguard</option>
<option class="level-1" value="5044"> Datapump</option>
<option class="level-1" value="5239"> Flashback</option>
<option class="level-1" value="5043"> Install</option>
<option class="level-1" value="6399"> Migration</option>
<option class="level-1" value="5236"> Oracle RAC</option>
<option class="level-1" value="5393"> Patch</option>
<option class="level-1" value="5085"> Performance Tuning</option>
<option class="level-1" value="5042"> RMAN</option>
<option class="level-1" value="5046"> Security</option>
<option class="level-1" value="6603"> SQL Tuning</option>
<option class="level-1" value="5045"> Upgrade</option>
<option class="level-0" value="2699">Oracle Applications</option>
<option class="level-0" value="7169">Oracle BI</option>
<option class="level-0" value="7171">Oracle Business Intelligence</option>
<option class="level-0" value="2110">Oracle DBA Scripts</option>
<option class="level-0" value="15">Oracle EBS</option>
<option class="level-0" value="3019">Oracle SQL</option>
<option class="level-0" value="5487">Oracle SQL Türkçe</option>
<option class="level-0" value="14">Oracle Türkçe</option>
<option class="level-1" value="5234"> Dataguard Türkçe</option>
<option class="level-1" value="5233"> Datapump Türkçe</option>
<option class="level-1" value="5240"> Flashback Türkçe</option>
<option class="level-1" value="5282"> Oracle Güvenlik</option>
<option class="level-1" value="5231"> Oracle Kurulum</option>
<option class="level-1" value="5232"> Oracle Mimari</option>
<option class="level-1" value="5283"> Oracle RAC Türkçe</option>
<option class="level-1" value="5241"> Performan Tuning Türkçe</option>
<option class="level-1" value="5230"> RMAN Türkçe</option>
<option class="level-1" value="5675"> Upgrade & Patch Türkçe</option>
<option class="level-1" value="5235"> Upgrade Türkçe</option>
<option class="level-0" value="3692">Oracle Tutorials</option>
<option class="level-0" value="5281">Oracle VM Server</option>
<option class="level-0" value="20096">Others</option>
<option class="level-0" value="12837">Outlook</option>
<option class="level-0" value="3647">PL/SQL</option>
<option class="level-0" value="5631">PL/SQL Türkçe</option>
<option class="level-0" value="3896">PostgreSQL</option>
<option class="level-0" value="2295">Primavera</option>
<option class="level-0" value="25">Programming</option>
<option class="level-0" value="7228">Python</option>
<option class="level-0" value="11800">SEO</option>
<option class="level-0" value="20097">Social</option>
<option class="level-0" value="3773">Solaris</option>
<option class="level-0" value="18">Sosyal Yazılar</option>
<option class="level-0" value="3828">SQL Scripts</option>
<option class="level-0" value="2227">SQL Server</option>
<option class="level-0" value="3827">SQL Server DBA Scripts</option>
<option class="level-0" value="19">SQL Server Türkçe</option>
<option class="level-0" value="3826">SQL Server Tutorials</option>
<option class="level-0" value="20">Stegonografi</option>
<option class="level-0" value="17">Süper Bilgisayarlar</option>
<option class="level-0" value="3507">Unix</option>
<option class="level-0" value="21">Veri Güvenliği (Information Security)</option>
<option class="level-0" value="22">Veri Yapıları</option>
<option class="level-0" value="23">Veritabanı</option>
<option class="level-0" value="6019">VirtualBox</option>
<option class="level-0" value="6088">Virtualization</option>
<option class="level-0" value="2296">Weblogic</option>
<option class="level-0" value="3445">Windows</option>
<option class="level-0" value="2874">Wordpress</option>
<option class="level-0" value="2881">XML</option>
<option class="level-0" value="24">Yapay Zeka ( Artifical intelligence )</option>
</select></form>Text Content
* Oracle
* Oracle
* Architecture
* Oracle Install
* Datapump
* RMAN
* Flashback
* Dataguard
* ASM
* Oracle RAC
* Security
* Performance Tuning
* SQL Tuning
* Patch
* Upgrade
* Migration
* Oracle TÜRKÇE
* Oracle Mimari
* Oracle Kurulum
* Datapump Türkçe
* RMAN Türkçe
* Flashback Türkçe
* Dataguard Türkçe
* Performans Tuning Türkçe
* Upgrade & Patch Türkçe
* Oracle DBA Scripts
* Goldengate
* Exadata
* ODA
* ORA-ERRORS
* Oracle SQL
* PL/SQL
* Oracle VM Server
* Oracle Tutorials
* SQL Server
* SQL Server
* SQL Server DBA Scripts
* SQL Server Tutorials
* SQL Scripts
* SQL Server Türkçe
* DWH & APP
* Oracle EBS
* Data Warehouse
* Oracle BI
* Business Intelligence
* Weblogic
* Goldengate
* Tableau
* Primavera
* IIS
* Exchange Server
* Oracle Applications
* Office 365
* Outlook
* WordPress
* SEO
* Database
* Oracle
* SQL Server
* PostgreSQL
* MySQL
* MongoDB
* Couchbase
* Big Data
* Data Science
* OS
* Linux
* Linux Türkçe
* Oracle VM Server
* VirtualBox
* Virtualization
* Windows
* Unix
* Solaris
* Network
* Engineering
* Yapay Zeka ( Artifical intelligence )
* Görüntü İşleme
* Algoritmalar
* Veri Yapıları
* SEO
* Programming
* C
* C++
* C#
* Oracle SQL
* Android
* PL/SQL
* Java
* Javascript
* HTML
* XML
* About Us
* Join Us
* Forum
* Home
* Forum
* About Us
* Join Us
* Oracle
* SQL Server
* Big Data
* Register
* Login
* Profile
* Reset Password
* SQL DBA Jobs
* Forum
IT TUTORIAL IT TUTORIAL | ORACLE DBA | SQL SERVER, GOLDENGATE, EXADATA, BIG
DATA, DATA SCIENCETUTORIAL
* Oracle
* Oracle
* Architecture
* Oracle Install
* Datapump
* RMAN
* Flashback
* Dataguard
* ASM
* Oracle RAC
* Security
* Performance Tuning
* SQL Tuning
* Patch
* Upgrade
* Migration
* Oracle TÜRKÇE
* Oracle Mimari
* Oracle Kurulum
* Datapump Türkçe
* RMAN Türkçe
* Flashback Türkçe
* Dataguard Türkçe
* Performans Tuning Türkçe
* Upgrade & Patch Türkçe
* Oracle DBA Scripts
* Goldengate
* Exadata
* ODA
* ORA-ERRORS
* Oracle SQL
* PL/SQL
* Oracle VM Server
* Oracle Tutorials
* SQL Server
* SQL Server
* SQL Server DBA Scripts
* SQL Server Tutorials
* SQL Scripts
* SQL Server Türkçe
* DWH & APP
* Oracle EBS
* Data Warehouse
* Oracle BI
* Business Intelligence
* Weblogic
* Goldengate
* Tableau
* Primavera
* IIS
* Exchange Server
* Oracle Applications
* Office 365
* Outlook
* WordPress
* SEO
* Database
* Oracle
* SQL Server
* PostgreSQL
* MySQL
* MongoDB
* Couchbase
* Big Data
* Data Science
* OS
* Linux
* Linux Türkçe
* Oracle VM Server
* VirtualBox
* Virtualization
* Windows
* Unix
* Solaris
* Network
* Engineering
* Yapay Zeka ( Artifical intelligence )
* Görüntü İşleme
* Algoritmalar
* Veri Yapıları
* SEO
* Programming
* C
* C++
* C#
* Oracle SQL
* Android
* PL/SQL
* Java
* Javascript
* HTML
* XML
* About Us
* Join Us
* Forum
Home/ORA-ERRORS/ORA-27102: out of memory
ORA-27102: OUT OF MEMORY
Mehmet Salih Deveci May 4, 2021 Leave a comment
I got ” ORA-27102: out of memory ” error in Oracle database.
ORA-27102: OUT OF MEMORY
Details of error are as follows.
ORA-27102: out of memory
Cause: Out of memory
Action: Consult the trace file for details
When trying to increase the SGA to approach half available RAM with an Oracle 64-bit version
on a Linux 64-bit operating system, even though SHMMAX is set to match half the amount of RAM,
you get the following error when trying to start the instance:
SQL> startup nomount
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
OUT OF MEMORY
This ORA-27102 errors are related with the Out of memory.
shmall is too small, most likely is set to the default setting of 2097152
$ cat /proc/sys/kernel/shmall
2097152
SHMALL is the total amount of shared memory, in pages, that the system can use
at one time.
To solve this error, Set SHMALL equal to the sum of all the SGAs on the system,
divided by the page size.
The page size can be determined using the following command:
$ getconf PAGE_SIZE
4096
For example, if the sum of all the SGAs on the system is 16Gb and the result
of ‘$ getconf PAGE_SIZE’ is 4096 (4Kb) then set shmall to 4194304 pages
As the root user set the SHMALL to 4194304 in the /etc/sysctl.conf file:
kernel.shmall = 4194304
then run the following command:
$ sysctl -p
$ cat /proc/sys/kernel/shmall
4194304
NOTE:
The above command loads the new value and a reboot is not necessary.
Switch back to the oracle user and retry the startup command.
Modifying /etc/sysctl.conf is a permanent workaround (applies at boot time). If
for some reason you DO NOT want to change the system wide configuration, you can
do it on the fly by directly changing the kernel pseudo FS AKA procfs.
e.g. echo "4194304" > /proc/sys/kernel/shmall
Using HUGEPAGES does not alter the calculation for configuring shmall.
Or you can remove SGA_* parameters from your pfile and set
MEMORY_MAX_TARGET=500M MEMORY_TARGET=500M , then save pfile and restart
database.
SQL> startup nomount pfile='/home/oracle/pfile.ora';
SQL> alter database mount;
SQL> alter database open;
DO YOU WANT TO LEARN ORACLE DATABASE FOR BEGINNERS, THEN READ THE FOLLOWING
ARTICLES.
> Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA
> )
ABOUT MEHMET SALIH DEVECI
I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle
& SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance
administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert
Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc.
clients as a Consultant, Insource or Outsource.I have done 200+ Operations in
this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle &
SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn
Installation, Database Migration, Disaster Recovery, Backup Restore, Performance
Tuning, Periodic Healthchecks.I have done 2000+ Table replication with
Goldengate or SQL Server Replication tool for DWH Databases in many clients.If
you need Oracle DBA, SQL Server DBA, APPS DBA, Exadata, Goldengate, EBS
Consultancy and Training you can send my email
adress mehmetsalih.deveci@outlook.com.-
-Oracle DBA, SQL Server DBA, APPS DBA,
Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim
için mehmetsalih.deveci@outlook.com a mail atabilirsiniz.
@https://twitter.com/MehmetDeveciDBA
Previous PLS-00302: component “string” must be declared
Next ORA-19625: error identifying file string
LEAVE A REPLY CANCEL REPLY
Your email address will not be published. Required fields are marked *
Comment *
Name *
Email *
Website
Δ
SEARCH IN IT TUTORIAL
Search for:
CATEGORIES
CategoriesSelect CategoryAlgoritmalarAndroidApplicationASP.NETBig
DataBlockchainCC#C++CouchbaseData ScienceData WarehouseExadataExchange
ServerGoldengateGoldengate TutorialsGoogleGörüntü
İşlemeHTMLIISIPTVJavaJavascriptLinuxLinux
TürkçeMikroişlemcilerMongoDBMySQLNetworkNoSQLODAOffice 365Operating
SystemORA-ERRORSOracle Architecture ASM Dataguard Datapump Flashback Install Migration Oracle
RAC Patch Performance Tuning RMAN Security SQL Tuning UpgradeOracle
ApplicationsOracle BIOracle Business IntelligenceOracle DBA ScriptsOracle
EBSOracle SQLOracle SQL TürkçeOracle Türkçe Dataguard Türkçe Datapump
Türkçe Flashback Türkçe Oracle Güvenlik Oracle Kurulum Oracle
Mimari Oracle RAC Türkçe Performan Tuning Türkçe RMAN Türkçe Upgrade &
Patch Türkçe Upgrade TürkçeOracle TutorialsOracle VM
ServerOthersOutlookPL/SQLPL/SQL
TürkçePostgreSQLPrimaveraProgrammingPythonSEOSocialSolarisSosyal YazılarSQL
ScriptsSQL ServerSQL Server DBA ScriptsSQL Server TürkçeSQL Server
TutorialsStegonografiSüper BilgisayarlarUnixVeri Güvenliği (Information
Security)Veri
YapılarıVeritabanıVirtualBoxVirtualizationWeblogicWindowsWordpressXMLYapay Zeka
( Artifical intelligence )
FORUM | ASK A QUESTION
Powered by IT Tutorial | Designed by SysDBASoft IT
IT Tutorial © Copyright 2023, All Rights Reserved
Go to mobile version