A default locale will be assumed if no variables are set. Set Oracle globalization variables required for your locale. Remove any other Oracle directories from PATH.įor example, add c:\instantclient11_2 to the beginning of PATH. The environment may be configured using SET commands in a Windows command prompt or made permanent by setting Environment Variables in System Properties.įor example, to set environment variables in Windows 2000 using System Properties, open System from the Control Panel, click the Advanced tab and then click Environment Variables.Īdd the directory containing the Instant Client files to the PATH system environment variable. See the Oracle Database Globalization Support Guide for more information.Ĭonfiguring SQL*Plus Instant Client on Windows For 11.2.0.1, /usr/bin/sqlplus is a symbolic link to the SQL*Plus binary at /usr/lib/oracle/11.2.0.1/client/bin/sqlplus.
If you install multiple versions of SQL*Plus, you may need to change the symbolic link /usr/bin/sqlplus to the version of SQL*Plus matching the libraries in LD_LIBRARY_PATH. If not, remove any other Oracle directories from PATH, or put /usr/bin before other SQL*Plus executables in PATH, or use an absolute or relative path to start SQL*Plus.įor example, to set PATH in the bash shell:
To test, enter which sqlplus which should return /usr/bin/sqlplus.
Make sure the sqlplus executable installed from the RPM is the first found in your PATH. Remove any other Oracle directories.įor example, to set LD_LIBRARY_PATH on Solaris in the Bourne or Korn shells: The sub-directory structure enables multiple versions of Instant Client to be available.Īdd the name of the directory containing the Instant Client libraries to LD_LIBRARY_PATH. The RPMs downloaded from OTN install into Oracle specific sub-directories in the /usr file system. To see it, you may need to minimize any other application windows that are open.Configuring SQL*Plus Instant Client on Linux (from RPMs) It may take a minute for the "Oracle Client Installer" window to appear. Windows may present an "Open File - Security Warning" dialog box.
Enter an administrator username and password to proceed. Windows may prompt you for an administrator username and password.To launch the Oracle Client Installer, go to the destination folder, open the client directory, and then double-click setup.exe (the Oracle setup file).Select a destination folder for the extracted files, and then perform the extraction.In Windows, navigate to the file, right-click it, and then select Extract all.If you do not have an OTN username and password, see the instructions for getting one above. Once you have done so, you will see the "File Download" dialog box.
You will be prompted to accept Oracle's license agreement and enter a valid OTN username and password. This file requires 1 GB of free space on your hard drive.