SQL*Plus: Difference between revisions
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> | ||
Latest revision as of 14:04, 26 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
Connect to the database
$ 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>