Sriram Sanka – My Experiences with Databases & More

Oracle-MySQL-SQL SERVER-Python-Azure-AWS-Oracle Cloud-GCP etc

  • Enter your email address to follow this blog and receive notifications of new posts by email.

  • Total Views

    • 588,542 hits

  • $riram $anka


    The experiences, Test cases, views, and opinions etc expressed in this website are my own and does not reflect the views or opinions of my employer. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content.Product and company names mentioned in this website may be the trademarks of their respective owners.

Archive for December, 2018

How to Add Swap Memory using a file

Posted by Sriram Sanka on December 22, 2018


 

Swap space in Linux is used when the amount of physical memory (RAM) is full. If the system needs more memory resources and the RAM is full, inactive pages in memory are moved to the swap space.

Swap space can be a dedicated swap partition (recommended), a swap file, or a combination of swap partitions and swap files.

We can Create Swap file and make use of it as described below .

Step 1: Create a file with required size

To create the file we need to use dd command as root user .

 

I am adding 64G of Swap to my server so the count is 67108864 (1024 * 1024 * 64) 

dd if=/dev/zero of=/u03/extra_swap bs=1024 count=67108864

 

Step 2: Change the file Permission using

chmod 0600 /u03/extra_swap

Step 3 : Set Up linux Swap Area.

[root@idc ~]# mkswap /u03/extra_swap


Step 4 :Execute the Following To enable the swap file immediately, You can Check the Added swap using free -g Command .

swapon /u03/extra_swap


Step 5: Add an Entry in /etc/fstab to Make this Swap file Enabled at boot Time

/u03/extra_swap swap swap defaults 0 0

We can use swapon or /proc/swap to Get the Swap info.

 

 

 

Posted in Linux | Tagged: , , , | Leave a Comment »

HOW-TOHow to Fix VirtualBox “UUID already exists” Errors

Posted by Sriram Sanka on December 15, 2018


There are several ways to fix UUID Issues, One of the methods is to Clone the hard Disk Attached using the clonevdi

When you are trying to Add a VM to your VBox, If it’s failed with Below Error, you can use clonevdi to clone the Hard disk using

VBoxManage clonevdi <Source> <Target> and reattach the Disk to the machine.

 

 

Posted in Oracle VM | Leave a Comment »

Oracle VM Virtual Appliance for Oracle E-Business Suite 12.2.6 – Download and Create Staging Appliance

Posted by Sriram Sanka on December 15, 2018


This Post is about How to Create Stage Area To Deploy Oracle VM Virtual Appliance for Oracle E-Business Suite 12.2.6

Step 1:

Download the Oracle E-Business Suite Appliance from Oracle Software Delivery Cloud, Which Contains Below ZIP Files.

V861124-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (1 of 10) (Part 1 of 2)     Linux x86-64
V861124-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (1 of 10) (Part 2 of 2)     Linux x86-64
V861125-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (2 of 10) (Part 1 of 2)     Linux x86-64
V861125-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (2 of 10) (Part 2 of 2)     Linux x86-64
V861126-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (3 of 10) (Part 1 of 2)     Linux x86-64
V861126-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (3 of 10) (Part 2 of 2)     Linux x86-64
V861127-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (4 of 10) (Part 1 of 2)     Linux x86-64
V861127-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (4 of 10) (Part 2 of 2)     Linux x86-64
V861128-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (5 of 10) (Part 1 of 2)     Linux x86-64
V861128-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (5 of 10) (Part 2 of 2)     Linux x86-64
V861129-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (6 of 10) (Part 1 of 2)     Linux x86-64
V861129-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (6 of 10) (Part 2 of 2)     Linux x86-64
V861130-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (7 of 10) (Part 1 of 2)     Linux x86-64
V861130-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (7 of 10) (Part 2 of 2)     Linux x86-64
V861131-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (8 of 10) (Part 1 of 2)     Linux x86-64
V861131-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (8 of 10) (Part 2 of 2)     Linux x86-64
V861132-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (9 of 10) (Part 1 of 2)     Linux x86-64
V861132-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (9 of 10) (Part 2 of 2)     Linux x86-64
V861133-01      Oracle E-Business Suite Release 12.2.6 Single Node Vision Install X86 (64 bit) - (10 of 10) (Part 1 of 1)     Linux x86-64

Step 2:

Download assembly.sh (UNIX) or assemble_OSX.sh(for Mac) from Oracle Support Doc ID 2254565.1  Or  You can Use UNZIP Tools like 7ZIP.exe.  Generate Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.00 to Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.18 

Step 3:

UnZip All the OVA part Files to Make it as a Single OVA file.  i.e. Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova

 

Unix/Linux :

cat Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.00 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.01 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.02 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.03 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.04 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.05 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.06 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.07 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.08 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.09 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.10 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.11 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.12 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.13 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.14 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.15 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.16 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.17 \

Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.18 >  Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova

For Windows, we can use Type Instead of “cat”

Step 4:

Import Appliance as below.

 

 

Posted in Oracle VM | 1 Comment »

 
Tales From A Lazy Fat DBA

Its all about Databases & their performance, troubleshooting & much more .... ¯\_(ツ)_/¯

Thinking Out Loud

Michael T. Dinh, Oracle DBA

Notes On Oracle

by Mehmet Eser

Oracle Diagnostician

Performance troubleshooting as exact science

deveshdba

get sum oracle stuffs

Data Warehousing with Oracle

Dani Schnider's Blog

Oracle Database Internal Mechanism

Learning is not a spectator sport

ORASteps

Oracle DBA's Daily Work

DBAspaceblog.com

Welcome everyone!! The idea of this blog is to help the DBA in their daily tasks. Enjoy.

Anand's Data Stories

Learn. Share. Repeat.

curtisbl.wordpress.com/

Tanel Poder's blog: Core IT for geeks and pros

Oracle Performance Tuning, Troubleshooting, Internals

Yet Another OCM

Journey as an Oracle Certified Master

DBAtricksWorld.com

Sharing Knowledge is ultimate key to Gaining knowledge...

Neil Chandler's DB Blog

A resource for Database Professionals

DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBA's become bulletproof!

OraExpert Academy

Consulting and Training

blog.tanelpoder.com

Micah Richardson