Oracle

Revision as of 15:32, 19 July 2019 by Mhan (talk | contribs) (→‎CLI commands: Set Oracle DB XE environment variables)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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