Software Applications
| Section | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
...
...
|
...
...
|
Contents
...
...
Product Details
A summary of the specifics of the product.
...
The Oracle client is not install on lab or classroom computers.
...
Installation Instructions
College Owned Equipment
To set up an instantclient installation of Oracle 11g that has the same components as the Carleton "basic" installation of Oracle 10g, the first three "packages" listed below are needed:
Instant Client Package
Description
Notes
Basic Lite
Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10.2 only)
SQL*Plus*
Additional libraries and executable for running SQL*Plus with Instant Client
ODBC Supplement*
Additional libraries for enabling ODBC applications with Instant Client (Not all platforms)
ODAC*
Includes ODP.NET, Oracle Services for MTS, Oracle Providers for ASP.NET, Oracle Provider for OLE DB, and OO4O with Oracle Instant Client
Optional packages are marked with a *.
...
- If there is another version of an Oracle client on this computer, remove it first. Because there is usually no uninstaller available in Control Panel->Add or Remove Programs, just delete the directories "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 the Services management console (services.msc), 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.
- Create the directory "C:\Program Files\Oracle11" and unzip all the .ZIP archives listed above into this directory. (Windows Explorer can open a .ZIP archive like a folder 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, move all the files and folders out of that instantclient_11_xx subdirectory up into the main "C:\Program Files\Oracle11" directory.
- Create the directory "C:\Program Files\Oracle11\Network\Admin"
- Copy the three Carleton *.ora files, "tnsnames.ora, ldap.ora, and sqlnet.ora" into 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.
- Create the directory "C:\Program Files\Oracle11\bin"
- Copy all '.dll' files that you extracted into "C:\Program Files\Oracle11" directory in to C:\Program Files\Oracle11\bin
- 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. Or you can use the Windows UI; In Control Panel->System->, find the Advanced tab (under Advanced system settings on Windows 7), choose the Environment Variables button (toward the bottom). In the System variables (bottom) list, scroll down to the Path variable, select it, and choose Edit. Remove any existing Oracle directories from the Path (they are usually at the front), and put these new directories as the first in the Path: C:\Progra~1\Oracle11\bin;C:\Progra~1\Oracle11; then choose OK.
Back at the Environment Variables dialog, select the New button under the System variables (bottom) list, and create these two new variables with the indicated values (no blanks):
TNS_ADMIN C:\Progra~1\Oracle11\Network\Admin
ORACLE_HOME 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.
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.
...
The installation would be the same on a personal computer. Remember that a restricted VPN connection would be required to access Carleton data.
...
Who To Call
BSR Advance CS and its companion applications are supported by Central Records staff Carla Thomas, Tony Pierre, and Denise Flicek. Within ITS, Oracle database systems administration is done by Richard Goerwitz, who can answer many Oracle questions (like how do the three *.ora files work). Sande Nissen in ITS will package any Oracle 11g client installations that are needed, for distribution through the KBOX user portal.
...