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

                 disconnect

         exit

EOF

echo ‘Starting database restart procedure…’

sleep 10

dbshut

dbstart

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 www.techpages.org · All Rights Reserved · Powered by WordPress ·