4,629
edits
add Connect to the database
add shutdown and start the database |
add Connect to the database |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Testedon|2019-06-21|Oracle 18.4.0.0.0, CentOS 7.6.1810}} | |||
Shutdown the database. | Shutdown the database. | ||
<source lang=" | <source lang="console"> | ||
$ sqlplus / as sysdba | $ sqlplus / as sysdba | ||
SQL> SHUTDOWN IMMEDIATE | SQL> SHUTDOWN IMMEDIATE | ||
</source> | </source> | ||
Start the database. | Start the database. | ||
| Line 11: | Line 14: | ||
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> | |||
Connect to the database | |||
<source lang="console"> | |||
$ sqlplus system@"chara/XEPDB12" | |||
SQL*Plus: Release 18.0.0.0.0 - Production on Wed Jun 26 15:02:51 2019 | |||
Version 18.4.0.0.0 | |||
Copyright (c) 1982, 2018, Oracle. All rights reserved. | |||
ERROR: | |||
ORA-01017: invalid username/password; logon denied | |||
Enter user-name: system | |||
Enter password: | |||
Last Successful login time: Fri Jun 21 2019 23:16:57 -06:00 | |||
Connected to: | |||
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production | |||
Version 18.4.0.0.0 | |||
SQL> | |||
</source> | </source> | ||