Oracle: Difference between revisions
add link to SQL*Plus |
→CLI commands: Set Oracle DB XE environment variables |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
[[SQL*Plus]] | [[SQL*Plus]] | ||
The XE services are defined in the configuration in <span class="package">/opt/oracle/product/18c/dbhomeXE/network/admin/tnsnames.ora</span> | |||
= CLI commands = | = CLI commands = | ||
| Line 7: | Line 10: | ||
<source lang="console"> | <source lang="console"> | ||
$ systemctl restart oracle-xe-18c | $ systemctl restart oracle-xe-18c | ||
</source> | |||
or | |||
<source lang="console"> | |||
$ /etc/init.d/oracle-xe-18c restart | |||
</source> | |||
== Set Oracle DB XE environment variables == | |||
<source lang="console"> | |||
$ export ORACLE_SID=XE | |||
$ export ORACLE_ASK=NO | |||
. /opt/oracle/product/18c/dbhomeXE/bin/oraenv | |||
</source> | </source> | ||
= Links = | = Links = | ||
Latest revision as of 15:32, 19 July 2019
The XE services are defined in the configuration in /opt/oracle/product/18c/dbhomeXE/network/admin/tnsnames.ora
CLI commands
Restart
$ systemctl restart oracle-xe-18c
or
$ /etc/init.d/oracle-xe-18c restart
Set Oracle DB XE environment variables
$ export ORACLE_SID=XE
$ export ORACLE_ASK=NO
. /opt/oracle/product/18c/dbhomeXE/bin/oraenv