Oracle: Difference between revisions

From Han Wiki
Jump to navigation Jump to search
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 15:32, 19 July 2019

SQL*Plus

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

Links