Saturday, March 23, 2024

Oracle Installation & Database Creations Options

Database Installation:
======================
Part 1:
=======
Oracle Home Installation / Oracle Software Installation / DB Home Installation / Oracle Installation 
===========================
Option 1: GUI Mode 
- ./runInstaller

Option 2: Silent Mode (Manual Method) (Command line)
- ./runInstaller -silent 

Option 3: Clone (Manual Method) (Command line)
- We have already have Oracle Home Installed on server A
- Take tar backup of OH from server A
- Copy that tar backup into new server / target server 
- untar the Oracle Home backup 
- ./clone.pl

Part 2: 
=======
Database Creation 
=================
Option 1: GUI Mode
- ./dbca

Option 2: Silent Mode (Manual Method) (Command line)
- ./dbca -silent 

Option 3: Silent Mode (Manual Method) (Command line)
- create pfile and start database in nomount mode
- run "create database command"
- run some post script 

Option 4: RMAN method
- We have already have Oracle database on server A
- Build / Create new database on new server / target server 

Part 1 + Part 2 (Not a best practice)
===============
Oracle Home Installation + Database Creation
Option 1: GUI Mode 
- ./runInstaller

Option 2: Silent Mode (Manual Method) (Command line)
- ./runInstaller -silent 
 

No comments:

Post a Comment

Automation Script | Archivelog Generation Hourly Monitoring

1. List out all the running databases and pic one database where we want to monitore the archive log generation from last 1 month. [oracle@o...