Oracle upstart: differenze tra le versioni
Jump to navigation
Jump to search
(Creata pagina con "==Upstart== Categoria:Database Categoria:Oracle Categoria:OpenSource") |
Nessun oggetto della modifica |
||
Riga 1: | Riga 1: | ||
==Upstart== |
==Upstart== |
||
<pre> |
|||
# description "start and stop oracle instance" |
|||
start on runlevel [3] |
|||
stop on runlevel [!3] |
|||
console log |
|||
chdir /home/oracle |
|||
setuid oracle |
|||
setgid oinstall |
|||
expect fork |
|||
env ORACLE_BASE=/u01/app/oracle |
|||
env ORACLE_SID=ORCL |
|||
env ORAENV_ASK=NO |
|||
script |
|||
. oraenv |
|||
echo startup | sqlplus '/ as sysdba' |
|||
lsnrctl start LISTENER |
|||
echo 'ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;' | sqlplus '/ as sysdba' |
|||
end script |
|||
pre-stop script |
|||
. oraenv |
|||
echo 'ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;' | sqlplus '/ as sysdba' |
|||
echo 'shutdown immediate' | sqlplus '/ as sysdba' |
|||
lsnrctl stop LISTENER |
|||
end script |
|||
</pre> |
|||
[[Categoria:Database]] |
[[Categoria:Database]] |
Versione attuale delle 20:11, 19 nov 2019
Upstart
# description "start and stop oracle instance" start on runlevel [3] stop on runlevel [!3] console log chdir /home/oracle setuid oracle setgid oinstall expect fork env ORACLE_BASE=/u01/app/oracle env ORACLE_SID=ORCL env ORAENV_ASK=NO script . oraenv echo startup | sqlplus '/ as sysdba' lsnrctl start LISTENER echo 'ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;' | sqlplus '/ as sysdba' end script pre-stop script . oraenv echo 'ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;' | sqlplus '/ as sysdba' echo 'shutdown immediate' | sqlplus '/ as sysdba' lsnrctl stop LISTENER end script