Please Login or Register
Advanced search

134 - Use SQLPLUS on Linux x86_64

Submitted by admin on Tue, 01/19/2010 - 11:19

If you want to use just SQLPLUS, you do not have to install Oracle Client Software.
It is gonna be very easy to use it.

1. Download an instant client

   Download Oracle Instant Client from http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/... Instant Client Package
   - "Basic" and "Instant Client Package"

   Like :

   oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm
   oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.x86_64.rpm

2. Install rpm packages into Linux

# rpm -ihv oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm

# rpm -ihv oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.x86_64.rpm

3. Path & SQLPLUS

  Make sqlplus runnable from anywhere ( set new PATH or copy to defined PATH)
  If you are using x86_64 Linux, please type the following.

# which sqlplus64 (or locate sqlplus64)

/usr/bin/sqlplus64

It has made a synbolic link in /usr/bin ("sqlplus64 -> /usr/lib/oracle/11.2/client64/bin/sqlplus")

 4.  Test SQLPLUS

# sqlplus64 user/passwd@'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=IP or hostname)(Port=port))(CONNECT_DATA=(SID=sid)))'

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 19 11:19:36 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

Now you can access Oracle Database !