Oracle SQL: How to use sqlplus without Oracle binaries or using oracle instant client libraries

Once Oracle DB is installed , Normally sqlplus is part of the oracle DB bin path. From the path use ./sqlplus to connect .

In some cases , where DB is not available in the system and still we need to connect to DB. In that case, oracle provides a workaround to connect to the DB.

Download the client from oracle site - Below is the Sample download link given for linux X86 32 bit.

http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html?printOnly=1

instantclient-sqlplus-linux-12.2.0.1.0.zip

Similarly downloads are available for different OS ,chip architectures and DB versions.

Once downloaded, unzip it to a path like "/sw/instantclient_12_2"

Add this path to the PATH and LD_LIBRARY_PATH environment variables.

export PATH=$PATH:/sw/instantclient_12_2
export LD_LIBRARY_PATH=/sw/instantclient_12_2

Below is the sample shell script to connect to the DB using the sqlplus client

 #!/bin/bash
export PATH=$PATH:/sw/instantclient_12_2
export LD_LIBRARY_PATH=/sw/instantclient_12_2
connectstring='DB_USER/DB_Password@(description=(address_list=(address=(protocol=TCP)(host=DB_hostname)(port=DB_portnumber)))(connect_data=(service_name=DB_servicename)))'
query=`echo -e "SELECT date from dual;"`
echo $query
sqlplus -S ${connectstring}<< EOF
$query
exit;
EOF

Hope it help someone !!!!!

Comments

Post a Comment

Popular posts from this blog

Configure, Modify, Rename,Delete a listener for Oracle 11g database

Image
  Steps to configure listener When a client like SQL Developer, toad etc. wants to establish a connection to an Oracle Server, it usually first contacts the listener . The listener then creates a foreground process ( dedicated mode ) or attaches the request to an existing foreground process ( shared mode ). The client then directly communicates with that foreground process . A listener can accept requests for more than one instance. Likewise, more than one listener can accept requests for the same instance (load balancing). 1.         Open terminal and go to the bin folder under ORACLE_HOME  cd /u01/app/oracle/product/11.2.0/dbhome_1/bin ./netca 2.         Since there are no existing listeners we will get only add listener as option. Click on Add option and click next. 3.         Provide the name for the listener (Eg. ORCL, DB11G etc.) 4.         Select the protocol in which the listener will be listening for the connections.
Read more

Oracle DB:Oracle 12C DB installation Error -Failed to access the temporary location

Image
While installing Oracle 12 database in Windows 7, an error "Failed to access the temporary location" occurs. Error: Cause - Failed to access the temporary location.  Action - Ensure that the current user has required permissions to access the temporary location.  Additional Information:  - Framework setup check failed on all the nodes  - Cause: Cause Of Problem Not Available  - Action: User Action Not Available Summary of the failed nodes <>- Version of exectask could not be retrieved from node “<>”  - Cause: Cause Of Problem Not Available  - Action: User Action Not Available Solution:  To get rid of this issue, add share in "Computer Management" 1. In Run (Win symbol+R) , type  compmgmt.msc 2. Under Shared Folders, Shares 3. Right click, Click on "New Share" 4. Click Next 5. Provide "C:\" in the Folder path and  click Next 6. Click Yes to continue  7. Provider "C$" fo
Read more

OSB : DB Adapter-Poll - Delete Logical Records using Oracle Service Bus 12c

Image
In this section, we will see how to use the Logical delete of records from table for polling tables from database.  Note: For creating connection factory, datasource, deployment , DBAdapter for poll and merge please verify my blog page  OSB : DB Adapter-Poll - Delete Physical Records using Oracle Service Bus 12c Here will explain only the essence of logical delete and how the data is picked and processed.  VERSION USED:  SOA SUITE 12C - 12.2.1.3 DB  12C - 12.2.0.1.0 SOURCE SCHEMA - SCOTT  SOURCE TABLE - EMP_UI TARGET SCHEMA - TGT  TARGET TABLE - EMP_UI_TGT Create table and insert records . In this option we have to add one more column for performing the logical delete just by updating the values.  Here we are making logical delete on column "STATUS" by changing poll value from "N" to "Y"  Physically the data will be available in the database but the process wont pick it as the condition mentioned for the pr
Read more