Deleting alert log files, Trace Files Automated in Oracle Database
[oracle@localhost ~]$ adrci
ADRCI: Release 126.96.36.199.0 - Production on Tue Mar 7 10:42:16 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/grid"
adrci> show homes
adrci> show h
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 188.8.131.52 using the … Read more
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 – 184.108.40.206 os platform – Linux grid owner – oracle
Check software version :
oracle@node1~$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [220.127.116.11.0]
oracle@node2~$ crsctl query crs softwareversion
Oracle Clusterware version on node node1 is [18.104.22.168.0]
2. Download the software and unzip on your first … Read more
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
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
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