4,461
edits
SQL*Plus: Difference between revisions
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=" | <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> | ||