I need oracle tools to diagnose and troubleshoot. This is the easiest, and least intrusive method I’ve found:
- Download and extract the "u01" folder from the Oracle XE RPM installation to /.
- Update your *.ora files here: /u01/app/oracle/product/11.2.0/xe/network/admin/
- 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
- Test it out. Seems to work just fine without having to install the full XE.