Oracle DBA

ORACLE ENTERPRISE LINUX (OEL 7.9 ) INSTALLATION Download Virtual box : Download & Install Latest virtual box on windows machine. Download LINUX 7.9 iso files. Install Linux 7.9 1. Download Virtual box : Download & Install Latest virtual box on windows machine.   2. Download LINUX 7.9 iso files Goto google.com -> edelivery.oracle.com Click on […]

Patching Process In Oracle Create a folder for patch 2 . By Winscp move the patch zip file to /data/patch this location. 3. Now check the current opatch version. #if the opatch version is old , then you have to replace it with the latest version. here it is 12.2.0.1.17. so let’s upgrade it. Now […]

Restore RAC Database from RMAN Backup Set First of all, make sure the clusterware is Up and Running. Restore Cluster Database 1. Make a Directory in Disk Group Make sure that we have a backup set of the database. 2. Detach Database from Clusterware Since we only use one node to do the entire recovery, […]

How to change database name using NID Utility Follow below steps for changing the oracle database name using nid utility. 1. Mount the database SQL>2. Run the NID utility SYNTAX – nid sys/password@CURRENT_DBNAME DBNAME=NEW_DBNAME 3. change the db_name parameter in the parameter file. 4. Rename the spfile to new db name

How To Setup Password Less Ssh Connectivity Using SshUserSetup.Sh Before starting RAC setup between two nodes, we need to have password less ssh connectivity between the nodes.There is a manual process to enable ssh connectivity . However oracle is providing a simple sshUserSetup.sh script, that will automate the steps. db nodes – > node1 , node2 […]

This blog describes how to increase the size of the default logical volume VolGroup00-LogVol00 mounted at the root “/” directory of a guest vServer. Create a volume (say 100gb) Attach the volume to the vServer, for which you want to modify the size of the root partition. Log in, as the rootuser, to the vServer. Examine the current […]

CRS- 6706 : Oracle Clusterware Release Patch Level (‘xxxx’) Does Not Match Sofrware Patch Level. We have restored OCR from backup, started CRS, and rolled back patch using opatchauto. After restarting CRS we’ve got this error: CRS-6706: Oracle Clusterware Release Patch Level (‘xxxx’) Does Not Match Software Patch Level (‘yyyy’) Steps to solve this issue […]

To take Export of a table to Multiple Directories in Oracle Create 2 directories: Note : make these physical directories on server level too. E.g Now take export with parallel option: Now you can see the dump file has been created in multiple directories. Dump file set for testuser.abc is:/home/oracle/DIR1/test_01.dmp/home/oracle/DIR2/test_01.dmp If you wish to compress […]

Update all packages Install below Package Reboot Server Run the vbox edition Go to virtual box setting and change the display resolution

Unplug pdb from 12c and plug into 19c cdb In this blog , We will be unplugging PDB from Oracle 12c CDB and plug it into Oracle 19c CDB. All the steps of unplugging and plugging PDB remain the same except we need to perform PDB upgrade. Steps are as follows : 1.     Unplug PDB […]