SQL*Plus: Difference between revisions
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> | ||
Revision as of 23:03, 21 June 2019
- Last tested on Oracle 18.4.0.0.0, CentOS 7.6.1810 (2019-06-21)
Shutdown the database.
$ sqlplus / as sysdba
SQL> SHUTDOWN IMMEDIATE
Start the database.
SQL> STARTUP
SQL> ALTER PLUGGABLE DATABASE ALL OPEN;
Enable automatic shutdown and startup.
$ systemctl daemon-reload
$ systemctl enable oracle-xe-18c