Database One-click Exit script

Often use virtual machine to do Oracle experiment, close the database at the end of the experiment, exit the database, switch to the root account, beating the shutdown command, is very cumbersome.

A shell script was written to enable one-click Exit. Specific as follows:

First, write the script

[Email protected] ~]$ vim 1.sh

#!/bin/bashsqlplus/as sysdba <<eof >/home/oracle/shutdown.log 2>&1shutdown immediatequitEOFexpect <<eof >/dev/null 2>&1 spawn suexpect "Password:" Send "123456\r" expect "#" send "init 0\r" expect eofeof

Second, modify the permissions of the script

[Email protected] ~]$ chmod 755 1.sh

[[Email protected] ~]$ MV 1.sh SD-->> renamed 1.sh to SD

[Email protected] ~]$ mv SD $ORACLE _home/bin

This way, when you need to exit, you can tap the SD command directly in the host environment

Database One-click Exit script