본문 바로가기

Database/ORACLE

[Oracle] DB&Listener Startup/Stop Script

반응형

### orauser Permission ###

1. startup Script

# vi db_start.sh
#!/bin/sh

sqlplus /nolog << !MYDB
conn /as sysdba
startup
exit
!MYDB

lsnrctl start LI_MYDB

저장

# chmod 744 db_start.sh



2. stop Script

# vi db_stop.sh
#!/bin/sh

lsnrctl stop LI_MYDB

sqlplus /nolog << !MYDB
conn /as sysdba
shutdown immediate
exit
!MYDB

저장

# chmod 744 db_stop.sh

 

반응형