Startup and shutdown script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Startup and shutdown script
# 1  
Old 07-06-2013
Startup and shutdown script

Hi all,

I'm writing a script to stop & start oracle:

Code:
su - oracle -c "sqlplus / as sysdba" -c "shutdown immediate">> ${log} 2>&1

The {log} refers to the log file. The part in bold gives error:
Code:
/usr/sbin/shutdown:  Only root can run /usr/sbin/shutdown

Pls suggest how to correct this.

regards.

Last edited by Scrutinizer; 07-06-2013 at 04:29 AM.. Reason: code tags
# 2  
Old 07-06-2013
You are running the shutdown in shell context i.e. trying to shutdown the system!
Try to nest two types of quotes
Code:
su - oracle -c "sqlplus / as sysdba -c 'shutdown immediate' " >> ${log} 2>&1

# 3  
Old 07-06-2013
Hi,

I tried your suggestion but still doesn't work.

regards
# 4  
Old 07-06-2013
This User Gave Thanks to chakrapani For This Post:
# 5  
Old 07-06-2013
According to the article this should work
Code:
su - oracle -c "echo 'shutdown immediate' | sqlplus '/ as sysdba' " >> ${log} 2>&1

If sqlplus takes -c instead of stdin, this should work, too
Code:
su - oracle -c "sqlplus '/ as sysdba' -c 'shutdown immediate' " >> ${log} 2>&1

# 6  
Old 07-06-2013
Hi all,

Thanks for your help.

Below has worked for me:
Code:
su - oracle -c "echo 'shutdown immediate' | sqlplus '/ as sysdba' " >> ${log} 2>&1


The 2nd one didn't work but ok 1st one has worked.

Thanks & regards.

Last edited by Franklin52; 07-06-2013 at 04:29 PM.. Reason: Please use code tags
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

No init messages display during startup/shutdown

This question is more in the line of how init messages get sent to a console during startup/shutdown. My problem has to do with exporting a VM from AWS to KVM (and a retry on virtual box). I am looking for a understanding on how init messages are sent to a device and what controls them My two... (0 Replies)
Discussion started by: jtkells
0 Replies

2. AIX

Auto startup and shutdown in AIX

Hi All, I would like to schedule auto IPL (shutdown and start-up) by using a shell script. Can you please give me some idea? want to test on my lab box first. shell script should bring AIX LPAR down and then need to start/activate the LPAR after 30 min any idea is highly... (3 Replies)
Discussion started by: System Admin 77
3 Replies

3. Shell Programming and Scripting

Automatic shutdown and startup of Tomcat in Solaris

Dear Experts , I want to stop and Start tomcat at the time of shutdown and startup of our server . I was trying to stop tomcat with following command # su - dm -c "/export/home/Finder/FinderWeb/jakarta-tomcat-3.3.1a/bin/shutdown.sh" but i am getting following error. Please suggest .... (1 Reply)
Discussion started by: Amit.saini333
1 Replies

4. UNIX for Dummies Questions & Answers

Script to force Oracle database shutdown when shutdown immediate does not work

I have Oracle 9i R2 on AIX 5.2. My Database is running in shared server mode (MTS). Sometimes when I shutdown the database it shutsdown cleanly in 4-5 mints and sometimes it takes good 15-20 minutes and then I get some ora-600 errors and only way to shutdown is by opening another session and... (7 Replies)
Discussion started by: aixhp
7 Replies

5. AIX

Startup/shutdown scripts in AIX

hi, If we place Sxx (startup script) and Kxx(shutdown script) in /etc/rc.d/rc2.d,then it would start and stop automatically(assume they are linked to other script that actually starts/stops). is there really a link needed here to /etc/rc.d/init.d? if not,what is the use of this directory..?... (1 Reply)
Discussion started by: to_bsr
1 Replies

6. Solaris

Startup and shutdown a server

Are rc scripts executed serially or all at the same time. Is there a way to see this happen? A log file or the syslogd? This is Solaris 10. (2 Replies)
Discussion started by: djehresmann
2 Replies

7. UNIX for Dummies Questions & Answers

Where is the shutdown/startup log?

Having difficulty trying to locate startup and shutdown messages. I had a bunch of servers shutdown over the weekend (due to a scheduled power outage) and upon reboot a lot of the filesystems weren't mounted and several processes weren't started... I checked /var/adm/messages and can't locate... (2 Replies)
Discussion started by: jamie_collins
2 Replies

8. Shell Programming and Scripting

Shell script to invoke db startup/shutdown

Hi all, I have a shell script which does db shutdown ..the script snippet which does this is as follows: function call_sql_plus { ${SQLPLUS:-sqlplus} -s /nolog <<EOF EXIT; EOF if then echo "Error occurred while calling sqlplus " ... (3 Replies)
Discussion started by: KrishnaSaran
3 Replies

9. SuSE

How to record shutdown/startup messages

The wtmp file records all logins and logouts. Its format is exactly like utmp except that a null user name indicates a logout on the associated terminal. Furthermore, the terminal name "~" with user name "shutdown" or "reboot" indicates a system shutdown or reboot and the pair of terminal names... (1 Reply)
Discussion started by: Laksmi
1 Replies

10. AIX

Startup/Shutdown scripts

I understand that by putting in entries into the /etc/inittab file. We can actually call the our scripts during startup. mkitab "start_server:2:once:sh /scripts/startserver.sh" Would the system wait for startserver.sh finish executing before it goes to another entry? and how long would it... (1 Reply)
Discussion started by: vincente
1 Replies
Login or Register to Ask a Question

Featured Tech Videos