Creating a Pluggable Database

In this topic, I will show how to Create and manage PDB:

Continue reading

Creating Container and Pluggable Database Using CREATE DATABASE SQL Command

In Oracle OCM exam, You may need to create database using command line. Even in real life, You may no have the option to use the software for GUI. I will show how to create a CDB and PDB using SQL Command.

Continue reading

Install Oracle 12.1 Software and Create database in Silent Mode

In this Topic, I will show how to install Oracle 12.1.0.2 Software only and Create database using DBCA by silent mode.

Oracle Installation Prerequisites:

Add following kernel parameters on /etc/sysctl.conf.

s.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

Run following command to verify and output will be like below:

[root@proddb ~]# /sbin/sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576

Add following kernel parameters on /etc/security/limits.conf.

oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    16384
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768

Install oracle database related packages: If you have internet connection then you can install from public Yum.

yum install binutils -y
yum install compat-libcap1 -y
yum install compat-libstdc++-33 -y
yum install compat-libstdc++-33.i686 -y
yum install gcc -y
yum install gcc-c++ -y
yum install glibc -y
yum install glibc.i686 -y
yum install glibc-devel -y
yum install glibc-devel.i686 -y
yum install ksh -y
yum install libgcc -y
yum install libgcc.i686 -y
yum install libstdc++ -y
yum install libstdc++.i686 -y
yum install libstdc++-devel -y
yum install libstdc++-devel.i686 -y
yum install libaio -y
yum install libaio.i686 -y
yum install libaio-devel -y
yum install libaio-devel.i686 -y
yum install libXext -y
yum install libXext.i686 -y
yum install libXtst -y
yum install libXtst.i686 -y
yum install libX11 -y
yum install libX11.i686 -y
yum install libXau -y
yum install libXau.i686 -y
yum install libxcb -y
yum install libxcb.i686 -y
yum install libXi -y
yum install libXi.i686 -y
yum install make -y
yum install sysstat -y
yum install unixODBC -y
yum install unixODBC-devel -y

Create groups and user:

groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
# Below group can be created if you want to separate the responsibility like backup team need to access the database backup. 
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
# Below group can be created if you use GRID Infrastructure even for Stand alone DB
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin

useradd -u 54321 -g oinstall -G dba,oper oracle

Create required directories:

mkdir -p /u01/app/oracle/product/12.1.0.2/dbhome_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01

Set secure Linux to permissive by editing the “/etc/selinux/config” file or use “setenforce Permissive” and reboot the server.

[root@proddb ~]# setenforce Permissive
[root@proddb ~]# cat /etc/selinux/config | grep SELINUX
# SELINUX= can take one of these three values:
SELINUX=permissive
# SELINUXTYPE= can take one of these two values:
SELINUXTYPE=targeted

Install Oracle 12c Software in Silent Mode:

Prepare the response file with required Input:

Copy the response file from Software unzipped location to any other location and change the file.

Continue reading

Permission changed for all directories including files in Oracle Home (RAC)

Sometime user (os admin or dba) make mistake to change or provide the permission in Oracle Binary.

User might requested for changing the particular file or directory permission but admin might run with recursively.

Example: To change owner for patch directory (/u01/patch) including all files on patch. But by mistake run below command

Continue reading

OCM 12c Preparation: Prepare Exam Environments

Oracle Certified Master is one of the prestigious exam in database world. Most of the Oracle DBA have a dream to be OCM certified. This certification will distinguish you from others in Market.

Prerequisites to be OCM Certified: Details

Oracle 12c OCM exam is based on Oracle Database 12c Release 1 and includes the use of Oracle Real Application Clusters (Oracle RAC). The operating system is Oracle Linux Server Release 6.5.

Exam Environment

https://education.oracle.com/oracle-database-12c-certified-master-exam/pexam_12cOCM

  • Oracle Linux Release 6.5 64 bit
  • Mozilla Browser, Text (emacs, gedit) and vi editors
  • Shell environment: bash, csh
  • Use either CLI or GUI environment and tools when available
  • Oracle Database 12c Enterprise Edition Release 12.1.0.2.0  64 bit
  • Oracle Grid Infrastructure 12Release 1 (12.1.0.2)
  • Oracle Enterprise Manager Cloud Control 12c Rel 4
Continue reading

Move or Rename Oracle Files

DBA needs to rename or move oracle file from one filesystem or ASM DISKGroup to another.

  • Move Datafiles Using ALTER DATABASE MOVE DATAFILE command – 12c and onward
  • Moving Datafile Using RMAN with offline option – 10g or 11g

Prerequisites: Database should be configured archive log mode.

Continue reading

OCM 12c Preparation

Oracle Certified Master is one of the prestigious exam in database world. Most of the Oracle DBA have a dream to be OCM certified. This certification will distinguish you from others in Market.

Prerequisites to be OCM Certified: Details

Oracle 12c OCM exam is based on Oracle Database 12c Release 1 and includes the use of Oracle Real Application Clusters (Oracle RAC). The operating system is Oracle Linux Server Release 6.5.

Exam Environment

https://education.oracle.com/oracle-database-12c-certified-master-exam/pexam_12cOCM

  • Oracle Linux Release 6.5 64 bit
  • Mozilla Browser, Text (emacs, gedit) and vi editors
  • Shell environment: bash, csh
  • Use either CLI or GUI environment and tools when available
  • Oracle Database 12c Enterprise Edition Release 12.1.0.2.0  64 bit
  • Oracle Grid Infrastructure 12Release 1 (12.1.0.2)
  • Oracle Enterprise Manager Cloud Control 12c Rel 4
Continue reading

Setup Password less connection using SSH for User Equivalence on Linux

Setup SSH (Key-Based Authentication)

Password less connectivity is required for RAC setup. Sometimes need to send files from one server to another using script with scheduler job. For this kind of tasks, password less connectivity is required. Password less connectivity can setup one direction (from server A -> B) or both directions (From Server A -> Server B or vs).

Execute following command on both Nodes:

Continue reading

Add a New Disk to an Existing Linux Server

In this article describes how to add a file system on exiting Linux OS. As OS is running on VM, First will show how to add a disk on VM then Create a Filesystem on OS Level.

Continue reading

Step by Step of Installation Oracle Enterprise Manager (OEM) 13c (13.2.0.0) on RAC

Oracle Enterprise Manage (OEM) is a great tools to monitor and manage all kind of oracle software including Oracle Databases and Server.

  • Create Database
  • Install OEM Software
  • Install Agent
Continue reading