Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Startup and shutdown script

Login to Discuss or Reply to this Discussion in Our Community

 
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
B Component Startup and Shutdown Scripts

Smilie
This User Gave Thanks to chakrapani For This Post:
MadeInGermany
# 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