How to restart Oracle in a TWO_TASK setup

Description

How do you restart Oracle in a TWO_TASK setup, where there's a separate database server?

Resolution

Oracle restart needs to be preceded by aleph_shutdown and followed by aleph_startup.  See the article " Proper way to restart Oracle on an Aleph server " in this regard.   As described in that article, in an "All-in-One" setup, Oracle can be restarted using util o/1/2 .

**Restart of Oracle in a TWO_TASK setup is best performed by the DBA or sysadmin.**  But the basic commands which would be entered on the Oracle server are shown below.  Note: you need to be user oracle to do this.

> $ sqlplus / as sysdba
SQL> shutdown immediate

> $ sqlplus / as sysdba
SQL> startup

• Article last edited: 8-Mar-2018