Page Comparison

Software Applications

...

For the latest version available today, this mean three .ZIP archives are needed: instantclient-basiclite-win32-11.2.0.1.0.zip, instantclient-odbc-win32-11.2.0.1.0.zip, instantclient-sqlplus-win32-11.2.0.1.0.zip. These files are currently stored in APPS\Windows\Oracle102\instantclient; they will be moved to an Oracle11 directory on the new archive service as soon as it is available. Also in that directory are Oracle Web pages and the whitepaper related to the use and installation of the instant client.

Here are manual installation instructions for use at Carleton:

This process is a manual installation / setup that will configure the system to work for Carleton.

Preparation

You will need the following files to complete the manual installation. You can either plan to access these via the APPS server from the client's machine, or copy them to a thumb drive to take with you before visiting the client.

1. Visit APPS\Windows\Oracle102\instantclient
2. Copy the following items to the thumb drive, or a local folder on the client's machine:

• • instantclient-basiclite-win32-11.2.0.1.0.zip
  • instantclient-odbc-win32-11.2.0.1.0.zip
  • instantclient-sqlplus-win32-11.2.0.1.0.zip
  • ldap.ora, sqlnet.ora, tnsnames.ora

(These files will be moved to an Oracle11 directory on the new archive service as soon as it is available. Also in that directory are Oracle Web pages and the whitepaper related to the use and installation of the instant client.)

"Installing" Oracle

1. If there is another version of an Oracle client on this computer, remove it first. Because
   If there is usually no uninstaller available in Control Panel ->Add or Remove Programs> Programs and Features, just delete the following directories and their contents:
       "C:\Program Files\Oracle10" and
       "C:\Program Files\Oracle" and their contents.
   (You may not be able to remove one directory because one oci*.dll file is in use; ignore the problem and it will go away in the next step. In )
2. Open the Services management Management console (services.msc) , disable and disable any Oracle services, if there are any. You also need to remove any Oracle directories from the Windows PATH environment variable, which is easiest to do in step X below.
3. Create the directory ": C:\Program Files\Oracle11" and unzip all the
4. Unzip the contents of all three .ZIP archives listed above into this directory.
   (Windows Explorer can open a .ZIP archive like a folder directory and then you can "Extract all files".) These extracted files are probably going to be created under an instantclient_11_xx subdirectory; once the extractions are done, If you accidentally extract the parent directories as well simply move all the files and folders out of that the three "instantclient_11_xx subdirectory up into the main " directories and into "C:\Program Files\Oracle11" directory. 
5. Create the directory "C:  C:\Program Files\Oracle11\Network\Admin"
6. Copy the three Carleton *.ora files , "tnsnames.ora, ldap.ora, and sqlnet.ora" into listed above into the C:\Program Files\Oracle11\Network\Admin directory. You can find these files in the original directory holding the .ZIP archives, or in APPS\Windows\Oracle102.
   These files define how the Oracle client will try to locate database services; their modification is beyond the scope of this article.
7. Create the directory "C:  C:\Program Files\Oracle11\bin"
8. Copy all '.dll' files that you extracted into "C:\Program Files\Oracle11" directory in to "C:\Program Files\Oracle11\bin"

Setting Environment Variables

You need to create two new Windows environment variables and modify another. (You can use the SetX command line utility if you're familiar with it; there's a copy of the utility in that original directory holding the .ZIP archives

...

)

1. Select: Start > Control Panel > System
2. Click on Advanced System Settings (or select the Advanced tab).
3. Click on the Environment Variables button.
4. In the System variables (bottom) list, scroll down to the Path variable, select it, and choose click Edit. Remove
5. Edit the entry to remove any existing Oracle directories from the Path entries ONLY (they are usually at the front), and put these new directories as the first in the Path: in front).
   Do NOT delete the entire entry.
6. Add the following to the start of the Path variable (copy and paste):
   C:\Progra~1\Oracle11\bin;C:\Progra~1\Oracle11;  then choose
7. Click OK.
8. Back at the Environment Variables dialog, select

   Add the following two new system variables using the New button

   under

   at the

   System variables (bottom) list, and create these two new variables with the indicated values (no blanks

   bottom of the screen (under System variables):

   TNS_

   ADMIN                      C

   ADMIN	C:\Progra~1\Oracle11\Network\Admin
   ORACLE_HOME

                   C

   C:\Progra~1\Oracle11

   (in these, we're using the short form of the "C:\Program Files\Oracle11" directory name, to avoid confusing Oracle.)

That's it; installation is done in four easy steps. To make the environment variables changes effective, you have to reboot. After you do, it should become possible to delete that last oci*.dll files from any old C:\Program Files\Oracle10" directory, and then the empty directory itself.

...

1. Click OK.

Notes

This instantclient lacks two important pieces that were present and used with the traditional Oracle client. SQL*Plus Worksheet was used by "a handful of people" at Carleton, but is becoming obsolete. (I believe that Microsoft Access or Excel, along with the advance ODBC data source, can replace it.) And TNSPING was used by all of us to demonstrate that an Oracle client installation worked and that Oracle was correctly installed. Without TNSPING, it becomes more difficult to prove that the instantclient is correctly installed and working: Assuming that the Advance client has also been installed, from an elevated command prompt, run the SQLPlus program using these command line parameters:
     sqlplus.exe username/password@advance
where username is your Oracle (not Advance, not Windows) login and password is your Oracle password. If this succeeds, SQLPlus displays its SQL> prompt, at which you can enter this query to retrieve one record:
     select * from entity where rownum = 1;
Retrieving one record demonstrates that the instantclient is installed correctly and locating Carleton data to which you have read access.

...