Oracle

From Han Wiki
Revision as of 14: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)

Jump to navigation Jump to search

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

Retrieved from "https://wiki.michaelhan.net/index.php?title=Oracle&oldid=3054"