Oracle: Difference between revisions
add the location of the XE services description |
→CLI commands: Set Oracle DB XE environment variables |
||
| Line 16: | Line 16: | ||
<source lang="console"> | <source lang="console"> | ||
$ /etc/init.d/oracle-xe-18c restart | $ /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 14: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