Oracle Best Practices

From AquaWiki
Jump to navigation Jump to search

This page will contain good practices to be referenced by CARDS pages

Graceful Shutdown[edit]

Although the DB will more than likely shutdown without issue/corruption, running the following will alleviate risk.

   $ sqlpus
   SQL> CONNECT SYS@CARDS AS SYSDBA
   Enter password: <password>
   SQL> SHUTDOWN IMMEDIATE

Helpful Links[edit]

   https://sqlfordevs.com/ebook
   https://docs.oracle.com/cd/E11882_01/server.112/e41085.pdf