Current Version 1.0 released on 21-Sep-2021

• 👋 Hi, welcome to DBA Genesis scripts
• 👀 Our goal is to simplify DBA's life
• 🌱 Access all our DBA scripts in one location
• 💞️ We update this repository time to time
• 📫 You can write to us at support@dbagenesis.com

How to download DBA Genesis scripts

First make sure you have git package installed on the server, if not then install with root user

yum -y install git

Switch to Oracle user and clone all our DBA Genesis (dg) scripts from Git Hub to your local system

su - oracle
git clone https://github.com/dba-genesis/dg-scripts.git
ls dg-scripts

How to run DBA Genesis scripts inside Oracle database

First we need to set the SQLPATH variable inside .bash_profile to point our downloaded scripts

vi .bash_profile
export SQLPATH=/home/oracle/dg-scripts              --> save and close
. .bash_profile

Now we can connect to SQL*Plus and run any of DBA Genesis scripts

sqlplus / as sysdba
SQL> @help.sql