Step by step procedure to clone Oracle Home Source Home /u01/app/oracle/product/11.2.0/dbhome_1 Target Home /u01/app/oracle/product/11.2.0/dbhome_2 Steps to clone the Oracle Home Below steps can be executed Step 1. Pack the Source
How to reclaim space from the datafile level in Oracle. Description : Below script provides output with alter statements if at least 1MB can be reclaimed from the individual datafiles
Reboot of Exadata Cell Nodes in Non-Rolling High Level Steps: a) Increase Disk Repair Time in ASM, to avoid disks drop from ASM b) Execute All commands as root user
Script to get oracle database status UP or DOWN. This script verifies if the oratab file exists in /etc/ directory then the server is Linux or AIX and ORATAB variable
DNS alias creation for oracle Database connectivity. In this Article we will see what is the DNA alias and why we need to create and who creates it . After
Shutdown and Startup of Exadata CellNode in Rolling High Level Steps: a) Increase Disk Repair Time in ASM, to avoid disks drop from ASM b) Execute All commands as
How to invoke GUI by using MobaXterm. To install Oracle database/Client software or configurations by using tools in GUI mode on Linux or Unix systems , we need Xwindows software
Database Migration steps from windows 2003 to Exadata DB Server : Steps @(windows) Source server: 1.Connect to the database Cmd>set oracle_sid=<sidname> Cmd>sqlplus sys as sysdba Password:<password>
DG Broker setup in Oracle Source: DB Version: 19.12.0.0.0 OS : Redhat Linux 7.6 Target : DB Version: 19.12.0.0.0 OD: Oracle Linux 7.9 On Primary ============== ARCHIVE LOG
Script to get tablespace alert in Oracle This script can be run on any Uinx/Linux flavours. For AIX,HP, and Linux oratab’s path is /etc/oratab, for solaris oratab’s path
