Description

What's the proper sequence to use for restarting Oracle on an Aleph server?

Resolution

You need to shut down Aleph, restart Oracle, and then restart Aleph....

> cd $alephe_root
> csh -f  aleph_shutdown > & aleph_shutdown.mmdd.log &

When aleph_shutdown is done, it will say "shutdown complete", or, more likely, "Shutdown did not complete: the following processes are still running".  You will typically see "yaxproxy" and "sru_server" processes, which aleph_shutdown doesn't stop.  It's OK to leave these running.  If there are other processes, they should be killed at this point. 

Then do util o/1/2 to "Close Oracle Server".  Reply "yes" in response to the question "Do you want to restart Oracle Server after closing?"

That will restart Oracle and the database. When it's done, it will prompt you with "Enter CR to continue... ".  Press Enter.

Then do:

> cd $alephe_root
> csh -f  aleph_startup > & aleph_startup.mmdd.log &

When aleph_startup is done, it will say "All done".

NOTE1:  Apache doesn't have to be restarted.  It can be left running while Aleph and Oracle are restarted.  

NOTE2:  The preceding applies to an "All-in-One" server.  In a TWO_TASK situation, where there's a separate Oracle server, aleph_shutdown and aleph_startup would be run on the application server as shown above.  The restart of Oracle would need to be run on the database server and is described in the article " How to restart Oracle in a TWO_TASK setup ", and is best performed by a sysadmin or DBA, if available.

• Article last edited: 12-Jun-2018