Backup & Recovery, Linux, Oracle, pluggable database, Unpluggable database

Plugging an Unplugged Pluggable Database with copy method

3 Comments
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Plugging an Unplugged Pluggable Database

Unplugging the PDB

To unplug a PDB, you first close it and then generate an XML manifest file. The XML file contains information about the names and the full paths of the tablespaces, datafiles of the unplugged PDB. The information will be used by the plugging operation.

We are going to unplug the PDB to plug them with Copy methods.

[oracle@localhost pdb3]$ . oraenv
ORACLE_SID = [cdb1] ? cdb1
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@localhost pdb3]$ sqlplus / as sysdba

SQL> show con_name

CON_NAME
------------------
… Read more
Database Administration, Grid Infrastructure, Linux, node, Oracle, RAC, Sql Server

Upgrade RAC Grid and Database from 11g To 12c

33 Comments
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Main steps:
Grid: –
1. Check all services are up and running from 11gR2 GRID_HOME
2. Perform backup of OCR, voting disk and Database.
3. Create new directory for installing 12C software on both RAC nodes.
4. Run “runcluvfy.sh” to verify errors.
5. Install and upgrade GRID from 11gR2 to 12cR1
6. Verify upgrade version
Database: –
1. Backup the database before the upgrade
2. Database upgrade Pre-check
Creating Stage for 12c database software
Creating directory for 12c oracle home
Check the pre upgrade status.
3.Unzip 12c database software in stage
4Install the 12.1.0.2 using the … Read more

Database Administration, Grid Infrastructure, Linux, node, Oracle

How To Downgrade Oracle 19c Grid To 12c Grid

1 Comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

In the pervious article we have explained the Upgrade Grid Infrastructure 12c To 19c Oracle Now We will explain the steps for downgrade oracle 19c 2 node GRID to oracle 12.1.0.2 GRID.

ENVIRONMENT DETAILS:
2 NODES – localhost1 and localhost2
Grid owner – oracle
19C ORACLE_HOME(current) – > /sharearea/crs/grid19c
12C ORACLE_HOME (old) -> /crs/app/oracle/product/grid12c

1. Check the current grid version:( check on both the nodes)

oracle@localhost1:/$ crsctl query crs softwareversion
Oracle Clusterware version on node [dbhost1] is [19.0.0.0.0]
oracle@localhost1:$ crsctl
… Read more
Database Administration, Grid Infrastructure, Linux, node, Oracle, Patching, Single Instance

Upgrade Grid Infrastructure 12c To 19c Oracle

4 Comments
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

The latest oracle version is oracle 19C . In the below article we will explain the steps for upgrading grid infrastructure to 19c from oracle 12c . The upgrade will be done in rolling mode.

Current configuration – >

No of nodes  – 2 node
current version – 12.1.0.2
os platform – Linux
grid owner – oracle

Check software version :
oracle@node1~$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [12.1.0.2.0]

oracle@node2~$ crsctl query crs softwareversion
Oracle Clusterware version on node node1 is [12.1.0.2.0]

2. Download the software and unzip on your first … Read more

Database Administration, Linux, Oracle, Single Instance

How to Configuration GRID/ASM for single instance using UDEV

10 Comments
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Configuration GRID/ASM for single instance using UDEV

UDEV Linux configuration:

What I’m preparing in the background is a RAC installation using two virtual machine running under VirtualBox. For this I have attached to my first virtual machine four fixed size of 1GB disks like this

 

To attach those disks in another virtual machine go to Virtual Media Manager and change their property to shareable like this

udev02

Once you start your guest OS you should see something:

[root@localhost ~]# fdisk -l
.
.
.
Disk /dev/sdb: 1073 MB, 1073741824 bytes, 2097152 sectors
Units = sectors of 1 * 512 = 5
… Read more
Database Administration, Database Administration, Linux, OEM, Oracle, oracle cloud

How to Install Grid/ASM for Single Instance on Oracle cloud:

4 Comments
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Installation of  Grid/ASM for single instance on cloud:

First open the browser any browser and type oracle cloud.

And sign-in your Oracle cloud
And select the three-line bar beside Oracle cloud.

And Select the option of Bare metal and VM and Exa data

After selecting that the next step is select Create DB system
1. Select a compartment name which is you want to provide
Name your DB system which is you want to provide
Select an availability domain
Select a shape type which is virtual machine
Select a shape vm standard 2.2 2 Available Core Count, 1 Node Count which are basic if you want u can change

 … Read more

Database Administration, Linux, Oracle

Installation of 18c oracle binaries and Database at same time

1 Comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

In this Article you will se how to install oracle 18c binaries as well as Database

Step 1 :
Disable firewall and selinux:
first check the status of firewalld status weather is active or not:

[root@localhost /]# systemctl status firewalld
● firewalld.service – firewalld – dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2021-05-03 01:47:30 IST; 4h 12min ago
Docs: man:firewalld(1)
Main PID: 957 (firewalld)
Tasks: 2
CGroup: /system.slice/firewalld.service
└─957 … Read more