Tag Archives: oracle

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

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

Installation of 18c oracle binaries and Database at same time

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

How to Upgrade Oracle 11g & 12c

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Downloading  Oracle 11g & 12c Database software and create your 1st Oracle Database

Things to Do:

  • Make sure your laptop has minimum 8 GB of RAM (16 GB or more is recommended).
  • Downloads: 7-zip to unzip, Notepad++ for writing notes.
  • Register at OTN: https://www.oracle.com/technetwork/index.html – this is a must to download Oracle software.
  • We’ll be installing Oracle Enterprise Edition, NOT Standard Edition or any other editions :Download & Install Cygwin: https://cygwin.com/install.html (optio
Read more

RAT

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail


Real Application Testing – step by step
Source Oracle: 11204 (single instance)
Target Oracle: 12102 (2 nodes RAC cluster+pluggable db)

Pre Requisit:
@Source
Need to decide/find the times, when would like to capture the load, it’s recommended to start small; 15 mins, 30 mins or max 1 hr
We did for couple of hours, not recommended, but not a bad idea, but should start small first and then proceed, if reports look good (6-11, 9-11, 14-16, 19-22)
Let’s assume our company peak time is 10 am – 11 am… Read more