Oracle: Difference between revisions

From Han Wiki
Jump to navigation Jump to search
restart Oracle
 
→‎CLI commands: Set Oracle DB XE environment variables
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
==== Restart ====
[[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 =
 
== Restart ==


<source lang="console">
<source lang="console">
$ systemctl restart oracle-xe-18c
$ systemctl restart oracle-xe-18c
</source>
</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>
= Links =

Latest revision as of 14: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