4,348
edits
SQL*Plus: Difference between revisions
add Connect to the database
add enable automatic shutdown and startup |
add Connect to the database |
||
| Line 7: | Line 7: | ||
SQL> SHUTDOWN IMMEDIATE | SQL> SHUTDOWN IMMEDIATE | ||
</source> | </source> | ||
Start the database. | Start the database. | ||
| Line 14: | Line 15: | ||
SQL> ALTER PLUGGABLE DATABASE ALL OPEN; | SQL> ALTER PLUGGABLE DATABASE ALL OPEN; | ||
</source> | </source> | ||
Enable automatic shutdown and startup. | Enable automatic shutdown and startup. | ||
| Line 20: | Line 22: | ||
$ systemctl daemon-reload | $ systemctl daemon-reload | ||
$ systemctl enable oracle-xe-18c | $ 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> | ||