Actions

Difference between revisions of "Oracle"

From Han Wiki

(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 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