Software Applications
...
| width | 33% |
|---|
...
EIS has access to the Oracle 11 installers
Installing Oracle 11
- Access the installer: Dropbox\ITS\ITS Only\ITS_EIS\Oracle
- In early 2025, the installer is located in the folder called win32_11gR2_client > client
- right-click on Setup.exe and Run As Admin
- You may see a warning that your computer does not meet minimum requirements - proceed anyway
- When prompted to select the installation type, select InstantClient
- When prompted to choose the Software Location, create a new folder at C:\Oracle11 and then select this folder as your installation location
- After the installation has completed, navigate to C:\Oracle11
- Create a new folder called Network (case sensitive)
- Within C:\Oracle11\Network create a new folder called Admin (case sensitive)
- Open a new Eplorer window and havigate back to Access the installer: Dropbox\ITS\ITS Only\ITS_EIS\Oracle
- Open the ldap folder and copy/paste the files there into C:\Oracle11\Network\Admin
- Open Windows Settings > System > About and select the Advanced system settings
- Open Environmental Variables
- In the system variables section, add the following:
- ORACLE_HOME C:\Oracle11
- TNS_ADMIN C:\Oracle11\Network\Admin
In order to use Toad with Oracle 11, you'll also need to install Toad (DVIS has the installers), use one of the /wiki/spaces/itskb/pages/26127178, and open up a ticket with the Firewall group add a firewall exception for the user who will be using Toad. Here is an example ticket.
...
DEPRECIATED CONTENT FROM 2015 BELOW
Software Applications
| Column |
|---|
OverviewThe Oracle 10g client used to be required on client computers running the Sungard BSR Advance C/S client/server database system, because it communicates with an Oracle database. The 10g client installation is described in the /wiki/spaces/TAR/pages/26457135 general article and the /wiki/spaces/TAR/pages/26459440 article. However, with a new version of Advance Web (AWA), an Oracle client is no longer needed. For the companion program SmartCall, a new version of Oracle, version 11g, is required. And version 11g offers an alternative to the big, awkward Oracle Universal Installer (oui.exe) we had to use with 10g. The alternative is what Oracle calls an "instantclient"; its installation is so simple that I'll document it here. |
...
Product Details
A summary of the specifics of the product.
...
The Oracle client is not install on lab or classroom computers.
...
Installation Instructions
...
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 *.
...
- 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.)
...
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.
...