How to Restart Your Oracle Database Using Shell Script

                     Some scenarios like tuning oracle parameters or some other scenarios you want to restart your oracle database using shell scripts. Below script will help you to do the same.

#! /bin/bash

#set -x


#                                 Your title here


su – oracle -c “

         export ORACLE_SID=SNM

         #create spfile from pfile

         sqlplus /   as sysdba <<- EOF

//     Your SQL Statement here




echo ‘Starting database restart procedure…’

sleep 10



About mohan

This is Mohan Jayapalan author of TechPages Blog.I am a part time blogger and Currently working for private Software Concern.

© Copyright 2010-2016 · All Rights Reserved · Powered by WordPress ·