post image

tnsping & sqlplus On Ubuntu 13.10

Apr 1, 2014 Gethugothemes

I need oracle tools to diagnose and troubleshoot. ¬†This is the easiest, and least intrusive method I’ve found:

  1. Download and extract the "u01" folder from the Oracle XE RPM installation to /.
  2. Update your *.ora files here: /u01/app/oracle/product/11.2.0/xe/network/admin/
  3. Export environment variables:

    export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe export ORACLE_BASE=/u01/app/oracle export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH export PATH=$ORACLE_HOME/bin:$PATH

  4. Test it out. Seems to work just fine without having to install the full XE.

Similar Posts

OpenBSD PF and OpenDNS

At home, I needed a way to prevent anything but OpenDNS from being used for DNS, and needed a rule that would do it in OpenBSD PF. Install and Configure First off, to setup an OpenDNS client on OpenBSD, install the ddclient package via pkg_add ddclient