Step by Step ASM/ Grid Installation in Oracle RAC
Hope it helped !! 🙂
Read moreOracle
How to Perform ORACLE_HOME Backup?
Backup of the Oracle home can be taken using any preferred method. You can use…
Read moreUNIX Shell Script To Run DataPump Or Traditional Export Or Import Utilities
To create a shell script to run export/import utilities. Running the script If you save…
Read moreHow To tell if a script was run in the background ?
The ps utility can get the process state. The process state code will contain the…
Read moreHow to move/copy controlfile from filesystem to ASM ??
1. Create a pfile as a backup of your spfile 2. Update the control_file parameter…
Read moreProfiles
A profile is a collection of attributes that apply to a user.The profile is used…
Read moreUser Management
About User Accounts:The areas in which you can configure security are as follows: • User…
Read moreHow to Decide if column should be indexed?
Many people ask these Questions, Q. How to identify which column is candidate for Index…
Read moreProtected: Database Link (DB Link)
There is no excerpt because this is a protected post.
Read moreRecovery Catalog
What is Recovery Catalog? A recovery catalog is a database schema used by RMAN Which…
Read moreRecovery of dropped tablespace with RMAN
SELECT NAME ,OPEN_MODE FROM V$DATABASE;SELECT LOG_MODE FROM V$DATABASE;SELECT NAME FROM V$DATAFILE;SELECT NAME FROM V$TABLESPACE; CREATE…
Read moreControl File and Redolog File Multiplexing
Control file and Redolog file contains crucial database information and loss of these files will…
Read moreARCHIVE AND OLD RMAN BACKUP REMOVAL
***************************FOR ARCHIVELOG****************************** $ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup-lv_root 57G 46G…
Read moreHow to determine what is keeping Catalog and Catproc invalid in the Registry
1. Run this SQL script until it returns 'CATPROC can be validated now'. For any…
Read moreCreating pluggable database from seed, when pdb$seed in in mount state and open state.
In the above , first we tried to create a new pluggable database PDB2 from…
Read more12cR1 to 19C upgradation with auto upgrade feature
Advantages of AutoUpgrade Utility: ========================== 1. Time saving method (completes the upgrade in a short…
Read moreUpgrade Oracle Database from 12.1.0.2 to 12.2.0.1 using DBUA
Supported Upgrade PathsDirect upgrades are possible from existing databases with the following versions.Destination Source=========== ======12c…
Read moreStep by Step ASM/ Grid Installation in Oracle Standalone
Prerequisite. Add below OS groups Add asmdba as secondary group to Oracle user Create Grid…
Read moreCommon User Vs Local User In 12c
COMMON USER: 1.A common user is a Database user, which perform an activity in all…
Read moreHow To Rename A Pluggable Database ( PDB)
The following explains how to rename a container (pluggable databases). Step-By-Step 1. Shutdown the pluggable…
Read moreMulti-tenant Architecture
Oracle Database 12c introduced a new feature called “Multitenant.” The multitenant feature provides the ability…
Read moreAzure : Create Gateway Subnet
STEP-1- Create Gateway Subnet Resource Group > VNET>SUBNETS> GATEWAY SUBNETS>ADD – 10.0.1.0/24 (Available Free Subnet).…
Read moreProtected: AZURE MONITORING – VIA LOG ANALYTICS
There is no excerpt because this is a protected post.
Read moreStep by Step Data Guard Configuration in 19c
1) PREREQUISITES: Requirements before starting the DATA GUARD CONFIGURATION. NOTE: 1) In PRIMARY SERVER DG11…
Read moreUndo Tablespace & ORA-01555 snapshot too old error..!!
As an “Oracle DBA ” normally interviewer ask about ORA-01555 snapshot too old error. What…
Read more