SQL*Plus: Difference between revisions

138 bytes added ,  21 June 2019
add enable automatic shutdown and startup
m add testedon
add enable automatic shutdown and startup
Line 3: Line 3:
Shutdown the database.
Shutdown the database.


<source lang="sql">
<source lang="console">
$ sqlplus / as sysdba
$ sqlplus / as sysdba
SQL> SHUTDOWN IMMEDIATE
SQL> SHUTDOWN IMMEDIATE
Line 13: Line 13:
SQL> STARTUP
SQL> STARTUP
SQL> ALTER PLUGGABLE DATABASE ALL OPEN;
SQL> ALTER PLUGGABLE DATABASE ALL OPEN;
</source>
Enable automatic shutdown and startup.
<source lang="console">
$ systemctl daemon-reload
$ systemctl enable oracle-xe-18c
</source>
</source>