How to restart Oracle in a TWO_TASK setup
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local
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