Tuesday, November 5, 2013

Note to self 002: Using SQL*Plus on Exalytics

Many times we get the question whether it is allowed to install the Oracle Database Client on an Exalytics In-Memory Machine. The answer to this is a bit difficult: Allowed? Certified? Supported?

It is not certified nor supported, but actually there is already a client installed in

MW_HOME/Oracle_BI1

SQL*Plus you say? Not to worry, there is an Instant Client as well available with the Times Ten software installed on the Exalytics server.

An example of running SQL*Plus from an Exalytics Server to test connectivity basd on the tnsnames.ora located in the the Oracle_BI1 home:


sudo su – oracle
cd /u01/app/oracle/product/TimesTen/tt1122/ttoracle_home/instantclient_11_2
export LD_LIBRARY_PATH=$PWD:$LD_LIBRARY_PATH
export TNS_ADMIN=/u01/app/oracle/product/fmw/Oracle_BI1/network/admin/
./sqlplus <schema>@<tnsname>

This is my narrow view on the world - if anybody reading this has any comments on other scenarios or cannot get the above to work, make sure you leave a comment below!