Oracle Client 11.2 0.4 Download 64 Bit Windows

Posted on

Then when you installed the 32-bit Oracle database client, the installer placed the path to the database client (for example, c: Oracle product 11.2.0 client1 bin) at the start of the Windows system PATH. When EnterpriseOne runs, it looks for database drivers in each directory from start to finish in the PATH.

SQL*Plus Instant Client is a standalone product with all the functionality of SQL*Plus command-line. It connects to existing remote Oracle databases, but does not include its own database. It is easy to install and uses significantly less disk space than the full Oracle Database Client installation required to use SQL*Plus command-line.

SQL*Plus Instant Client is available on platforms that support the OCI Instant Client. See the Oracle Call Interface Programmer's Guide for more information on the OCI Instant Client.

To install SQL*Plus Instant Client, you need two packages:

  1. Select Patch 13390677: 11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER for the 32-bit version of your platform (even if your platform is 64-bit). The File Download screen appears.
  2. Select Patch 13390677: 11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER for the 32-bit version of your platform (even if your platform is 64-bit). The File Download screen appears.
  • SQL*Plus Instant Client package.

  • Either the Basic OCI Instant Client package, or the lightweight OCI Instant Client package.

Choosing the SQL*Plus Instant Client to Install

SQL*Plus Instant Client can be installed in two ways:

  • Download the packages from the Oracle Technology Network (OTN).

  • Copy the same files that are in the packages from an Oracle Database 11g Client Administrator installation.

Both the SQL*Plus and OCI packages must be from the same Oracle Database version, for example, 11.1.0.6.

Basic Instant Client

SQL*Plus Instant Client using the Basic OCI package works with any NLS_LANG setting supported by the Oracle Database. It supports all character sets and language settings available in the Oracle Database.

Lightweight Instant Client

SQL*Plus Instant Client using the lightweight OCI package displays error messages in English only and supports only specific character sets. It is significantly smaller than SQL*Plus Instant Client using the Basic OCI package.

Valid values for NLS_LANG parameters with the lightweight Instant Client are:

  • language can be any valid language supported by the Oracle Database, however, error messages are only reported in English.

  • territory can be any valid territory supported by the Oracle Database.

  • charset is one of the following character sets:

    • US7ASCII

    • WE8DEC

    • WE8MSWIN1252

    • WE8ISO8859P1

    • UTF8

    • AL16UTF16

    • AL32UTF8

For example:

See the Oracle Database Globalization Support Guide, and NLS_LANG Environment Variable for more information about NLS settings.

Lightweight SQL*Plus Instant Client Error with Unsupported Character Set

0.4

Attempting to start SQL*Plus Instant Client with an unsupported character set will fail with the following error:

Installing SQL*Plus Instant Client by Downloading from OTN

The OTN downloads for Linux are RPM packages. The OTN downloads for UNIX and Windows are zip files.

The SQL*Plus Instant Client package should never be installed on an ORACLE_HOME.

Installing SQL*Plus Instant Client from Linux RPM Packages

  1. Download the RPM packages containing the SQL*Plus Instant Client package, and the OCI package from the OTN Instant Client page at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html. Both packages must be from the same version such as 11.1.0.6.

  2. Use rpm -i for the initial install of the RPM packages, or rpm -u to upgrade to a newer version of the packages.

  3. Configure SQL*Plus Instant Client. See Configuring SQL*Plus Instant Client.

Installing SQL*Plus Instant Client from the UNIX or Windows Zip Files

  1. Download the zip files containing the SQL*Plus Instant Client package, and the OCI package from the OTN Instant Client page at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html. Both packages must be from the same version such as 11.1.0.6.

  2. Create a new directory, for example, /home/instantclient11_2 on UNIX or c:instantclient11_2 on Windows.

  3. Unzip the two packages into the new directory.

  4. Configure SQL*Plus Instant Client. See Configuring SQL*Plus Instant Client.

List of Files Required for SQL*Plus Instant Client

Tables E-1, E-2 and E-3 list the required files from each of the SQL*Plus and OCI packages. The files from only one of the OCI packages are required. Other files installed that are not listed here can be ignored, or can be removed to save disk space.

Table D-1 Instant Client Files in the SQL*Plus Package

Linux and UNIXWindowsDescription

sqlplus

sqlplus.exe

SQL*Plus executable

libsqlplus.so

not applicable

SQL*Plus library

libsqlplusic.so

orasqlplusic11.dll

SQL*Plus data shared library


Table D-2 Instant Client Files in the Basic OCI Package

Linux and UNIXWindowsDescription

libclntsh.so.11.1

oci.dll

Client code library

libociei.so

oraociei11.dll

OCI Instant Client data shared library

libnnz11.so

orannzsbb11.dll

Security library


Table D-3 Instant Client Files in the Lightweight OCI Package

Linux and UNIXWindowsDescription

libclntsh.so.11.1

oci.dll

Client code library

libociicus.so

oraociicus11.dll

OCI Instant Client data shared library (English only)

libnnz11.so

orannzsbb11.dll

Security library


Installing SQL*Plus Instant Client from the 11g Client Release Media

  1. Run the installer on the Oracle Database 11g Client Release media and choose the Administrator option.

  2. Create a new directory, for example, /home/instantclient11_2 on UNIX and Linux, or c:instantclient11_2 on Windows.

  3. Copy the SQL*Plus Instant Client and the OCI Instant Client files to the new directory. All files must be copied from the same ORACLE_HOME.

    See Installing SQL*Plus Instant Client on UNIX or Linux or Installing SQL*Plus Instant Client on Windows for a list of the files to copy.

  4. Configure SQL*Plus Instant Client. See Configuring SQL*Plus Instant Client.

Installing SQL*Plus Instant Client on UNIX or Linux

To install SQL*Plus Instant Client using the Basic OCI package on UNIX and Linux, copy the following files:

To install SQL*Plus Instant Client using the lightweight OCI package on UNIX and Linux, copy the following files:

Installing SQL*Plus Instant Client on Windows

To install SQL*Plus Instant Client using the Basic OCI package on Windows, copy the following files:

To install SQL*Plus Instant Client using the lightweight OCI package on Windows, copy the following files:

Configuring SQL*Plus Instant Client

The SQL*Plus Instant Client executable should only be used with the matching version of the OCI Instant Client.

Note that no ORACLE_HOME or ORACLE_SID environment variables need to be set.

Configuring SQL*Plus Instant Client on Linux (from RPMs)

The RPMs downloaded from OTN install into Oracle specific sub-directories in the /usr file system. The sub-directory structure enables multiple versions of Instant Client to be available.

  1. Add the name of the directory containing the Instant Client libraries to LD_LIBRARY_PATH. Remove any other Oracle directories.

    For example, to set LD_LIBRARY_PATH on Solaris in the Bourne or Korn shells:

  2. Make sure the sqlplus executable installed from the RPM is the first found in your PATH. To test, enter which sqlplus which should return /usr/bin/sqlplus. 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.

    For example, to set PATH in the bash shell:

    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. 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.

  3. Set Oracle globalization variables required for your locale. A default locale will be assumed if no variables are set. See the Oracle Database Globalization Support Guide for more information.

    For example:

Configuring SQL*Plus Instant Client on Linux (from Client Media or Zip File) and UNIX

  1. Add the name of the directory containing the Instant Client files to the appropriate shared library path LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH. Remove any other Oracle directories.

    For example on Solaris in the Bourne or Korn shells:

  2. Add the directory containing the Instant Client files to the PATH environment variable. If it is not set, then an absolute or relative path must be used to start SQL*Plus. Remove any other Oracle directories from PATH. For example:

  3. Set Oracle globalization variables required for your locale. A default locale will be assumed if no variables are set. See the Oracle Database Globalization Support Guide for more information.

    For example:

Configuring SQL*Plus Instant Client on Windows

The environment may be configured using SET commands in a Windows command prompt or made permanent by setting Environment Variables in System Properties.

For 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.

  1. Add the directory containing the Instant Client files to the PATH system environment variable. Remove any other Oracle directories from PATH.

    For example, add c:instantclient11_2 to the beginning of PATH.

  2. Set Oracle globalization variables required for your locale. A default locale will be assumed if no variables are set. See the Oracle Database Globalization Support Guide for more information. For example, to set NLS_LANG for a Japanese environment, create a user environment variable NLS_LANG set to JAPANESE_JAPAN.JA16EUC.

    If you have installed the lightweight Instant Client, see Lightweight Instant Client for information about supported NLS_LANG settings.

Connecting to a Database with SQL*Plus Instant Client

SQL*Plus Instant Client is always 'remote' from any database server. To connect to a database you must specify the database using an Oracle Net connection identifier.

An example using an Easy Connection identifier to connect to the HR schema in the MYDB database running on mymachine is:

Alternatively you can use a Net Service Name:

Net Service Names can be stored in a number of places, including LDAP. The use of LDAP is recommended to take advantage of the new features of Oracle Database 11g. See the Oracle Database Net Services Reference for more information.

If you want to use Net Service Names configured in a local Oracle Net tnsnames.ora file, then set the environment variable TNS_ADMIN to the directory containing the tnsnames.ora file. For example, on UNIX, if your tnsnames.ora file is in /home/user1 and it defines the Net Service Name MYDB2:

If TNS_ADMIN is not set, then an operating system dependent set of directories is examined to find tnsnames.ora. This search path includes looking in the directory specified by the ORACLE_HOME environment variable for network/admin/tnsnames.ora. This is the only reason to set the ORACLE_HOME environment variable for SQL*Plus Instant Client. If ORACLE_HOME is set when running Instant Client applications, it must be set to a directory that exists.

This example assumes the ORACLE_HOME environment variable is set, and the $ORACLE_HOME/network/admin/tnsnames.ora or ORACLE_HOMEnetworkadmintnsnames.ora file defines the Net Service Name MYDB3:

The TWO_TASK (on UNIX) or LOCAL (on Windows) environment variable can be set to a connection identifier. This removes the need to explicitly enter the connection identifier whenever a connection is made in SQL*Plus or SQL*Plus Instant Client. This UNIX example connects to the database known as MYDB4:

On Windows, TNS_ADMIN and LOCAL may be set in the System Properties. See Configuring SQL*Plus Instant Client on Windows.

AS SYSDBA or AS SYSOPER Connections with SQL*Plus Instant Client

To connect AS SYSDBA or AS SYSOPER to perform DBA tasks, you need to set up an Oracle password file on the database server using the database's orapwd utility. Once this is configured, your SQL*Plus Instant Client connection string might look something like:

See the Oracle Database Administrator's Guide for information on Oracle password files.

Uninstalling Instant Client

The SQL*Plus Instant Client package can be removed separately from the OCI Instant Client. After uninstalling the SQL*Plus Instant Client package, the remaining OCI Instant Client libraries enable custom written OCI programs or third party database utilities to connect to a database.

Oracle Client 11.2 0.4 Download 64 Bit Windows 8 1

Uninstalling SQL*Plus Instant Client

  1. For installations on Linux from RPM packages, use rpm -e only on the SQL*Plus Instant Client package

    or

    For installations on UNIX and Windows, and installations on Linux from the Client Release media, manually remove the following SQL*Plus specific files:

    Table D-4 Instant Client Files in the SQL*Plus Package

    UNIXWindowsDescription

    sqlplus

    sqlplus.exe

    SQL*Plus executable

    libsqlplus.so

    not applicable

    SQL*Plus library

    libsqlplusic.so

    orasqlplusic11.dll

    SQL*Plus data shared library


  2. Reset environment variables and remove tnsnames.ora if necessary.

Uninstalling the Complete Instant Client

  1. For installations on Linux from RPM packages, use rpm -qa to find the SQL*Plus Instant Client and Basic OCI package names and run rpm -e to remove them

    or

    For installations on UNIX and Windows, and installations on Linux from the Client Release media, manually delete the directory containing the SQL*Plus executable and Oracle libraries.

    See Installing SQL*Plus Instant Client from the 11g Client Release Media for a list of the files you copied to the directory.

  2. Reset environment variables such as PATH, SQLPATH, LD_LIBRARY_PATH and TNS_ADMIN.

  3. Remove tnsnames.ora if necessary.

This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.

Downloading Oracle Database 11g Release 2 for 32-bit Windows

Oracle 11g Release 2 is not compatible with Windows 10. Windows 10 users should download the Oracle 12.1 client instead. Scroll down to 'Oracle Database Client (12.1.0.2.0) for Microsoft Windows (32-bit)' and click winnt_12102_client32.zip to download the 32-bit Oracle 12.1 client.

At Indiana University, to download the Oracle Database 11g Release 2 client for 32-bit Windows, use either of the following methods:

  • Download directly from Oracle's website: This method requires a valid OTN (Oracle Technology Network) username and password. If you do not have a valid OTN username and password, visit Oracle Database Software Downloads. At the top, click Sign In/Register, and then follow the on-screen instructions.
  • Download from IUware: This method requires a valid IU username and passphrase.

For either download method, you must be logged into your computer as an administrator. (Normally, you should refrain from running your Windows computer as an administrator; see About the principle of least privilege)

Downloading the client directly from Oracle's website

To download the Oracle Database client directly from Oracle's website:

  1. Go to Oracle Database 11g Release 2 for Microsoft Windows (32-bit).
  2. Click OTN License Agreement, read the license agreement, and then close the window.
  3. Select Accept License Agreement. You will see a notification thanking you for accepting the OTN License Agreement and permitting you to download the software.
  4. Under 'Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit)', click win32_11gR2_client.zip to download the client. This file requires 698 MB of free space on your hard drive.

    Before continuing, you may be prompted to enter a valid OTN username and password. After doing so, you will see the 'File Download' dialog box. If you do not have an OTN username and password, see the instructions for getting one above.

  5. Save the win32_11gR2_client.zip file.
  6. In Windows, navigate to the file, right-click it, and then select Extract all.
  7. Select a destination folder for the extracted files, and then perform the extraction.
  8. To launch the Oracle Client Installer, go to the destination folder, open the client directory, and then double-click setup.exe (the Oracle 11g setup file).

    At this point:

    • Windows may prompt you for an administrator username and password. Enter an administrator username and password to proceed.
    • Windows may prompt you with an 'Open File - Security Warning' dialog box. Click Run to proceed.

    It may take a minute for the 'Oracle Client Installer' window to appear. To see it, you may need to minimize any other application windows that are open.

When you are ready to install the Oracle client, follow the instructions in the next section.

Downloading the client from IUware

To download the Oracle Database client from IUware:

11.2
  1. Go to OracleClient 11g R2 32-bit.
  2. Click Log in for access:
    • If you're not already logged into the IU CentralAuthentication Service (CAS), enter your IU username and passphrase, and then click LOGIN.
    • If you're already logged into IU CAS, proceed to the next step.
  3. Under 'Downloads', click Oracle11gR2Client32bit.exe - 698MB. This file requires 698 MB of free space on your hard drive.
  4. In the 'File Download - Security Warning' dialog box, click Save, select a destination folder, and then click Save.
  5. To open the IUware installer, go to the destination folder, and then double-click Oracle11gR2Client32bit.exe.
  6. By default, the IUware installer will create a c:IUwareOnlineOracle11gR2 Client 32bit directory for installing the necessary files. To save the files to a different folder, click Browse, and then find and select the desired folder. To continue, click Install.
  7. The Oracle Database Client installation should start automatically after the IUware installer finishes extracting files to the specified folder. If it does not, go to that folder, and then click setup.exe.

    It may take a minute for the 'Oracle Client Installer' window to appear. To see it, you may need to minimize any other application windows that are open.

When you are ready to install the Oracle client, follow the instructions in the next section.

Installing the Oracle client

This installation requires 705 MB of space.

If you have an Oracle Home environment variable set on your computer, remove it before starting the installation (it interferes with setting some paths for the installation).

Oracle Client 11.2 0.4 Download 64 Bit Windows 10

  1. The Oracle client installer will display the 'Select Installation Type' dialog box. Unless you want a different type of installation, select Custom, and then click Next.
  2. The 'Select Product Languages' dialog box will appear with English already selected. If you want to select another language, in the box on the left, click your preferred language and > so the language appears in the box on the right. After selecting the language, click Next.
  3. In the 'Specify Installation Location' dialog box, the installer provides default file locations for you, but you can enter alternative paths in the available boxes (or click Browse to navigate to alternative locations).
    • The first file location is for the Oracle Base directory (for files related to configuration and software). Choose or create a directory (e.g., c:Oracle11gR2).
    • The second file location is for the Oracle Home directory (for software files). You should place this directory within your selected Oracle Base directory (e.g., c:Oracle11gR2product11.2.0client_1).

    Do not use an existing Oracle Home directory. If an existing Oracle Home is selected by default, choose a different location.

    To continue, click Next.

  4. In the 'Available Product Components' dialog box, select the following components:
    • Oracle Java Client
    • SQL*Plus
    • Oracle JDBC/THIN Interfaces
    • Oracle Call Interface (OCI)
    • Oracle Net
    • Oracle Programmer
    • Oracle SQL Developer (optional)
    • Oracle Connection Manager
    • Oracle ODBC Driver
    • Oracle Objects for OLE
    • Oracle Provider for OLE DB
    • Oracle Data Provider for .NET
    • Oracle Providers for ASP.NET

    To continue, click Next.

    The SQL*Plus GUI application and SQL*Plus Worksheet are no longer available in Oracle 11g. SQL*Plus is now just a command shell tool. You may want to investigate SQL Developer as an alternative.
  5. In the 'Perform Prerequisite Checks' dialog box, the installer verifies whether your environment meets the minimum requirements for installing and configuring the products you selected. Fix any flagged items before proceeding. If the check is successful, the installation automatically proceeds to the next dialog box.
  6. Verify the installation information in the 'Summary' dialog box, and then click Finish.
  7. The 'Install Product' dialog box will prepare, copy, and set up files, and configure the installation. It will proceed to the next dialog box.
  8. The 'Finish' dialog box should show the message 'The installation of Oracle Client was successful'. Click Close.
  9. To finish the installation, follow the instructions for Configuring Oracle Net below. If you choose to configure the Oracle Net client at a later time, use the instructions in Adding new database services at that time.

Configuring Oracle Net

To configure Oracle Net, you will need to know the System Identifier (SID) of the database to which you are connecting, the full service name of the database, the port number, and the hostname of the computer hosting the database. If necessary, ask your database administrator for this information before continuing.

The following instructions assume you are using the IUGP Oracle research instance:

  • SID:iugp
  • Service name:sid.iu.edu
  • Port:1521
  • Hostname:rdc03.uits.iu.edu

If you are using the IU Data Warehouse, refer to the Oracle client configuration information for the IU Data Warehouse below.

If you have the TNS_ADMIN environment variable set on your workstation and have a tnsnames.ora file stored there, following these instructions will update that file instead of the tnsnames.ora file in your Oracle Home network administrator directory.
  1. If you cannot see the 'Oracle Net Configuration Assistant: Welcome' dialog box, move the 'Configuration Assistants' dialog box.
  2. In the 'Oracle Net Configuration Assistant: Welcome' dialog box, make sure Perform typical configuration is not selected, and then click Next.
  3. In the 'Oracle Net Configuration Assistant: Naming Methods Configuration' dialog box, make sure the 'Selected Naming Methods' box has Local Naming, and then click Next.
  4. Enter the full service name (e.g., iugp.iu.edu), and then click Next. If you do not know the full service name, contact the High Performance Systems group to check with the database administrator.
  5. Select TCP, and then click Next.
  6. Enter your hostname (for the iugp SID, the hostname is rdc03.uits.indiana.edu). Unless otherwise specified, leave 1521 as the port number. Then, click Next.
  7. Select Yes, perform test, and then click Next.

    If the login test fails, select Change Login, enter your user information, and then try again.

    When the test is successful, click Next.

  8. The UITS High PerformanceSystems group recommends using iugp.iu.edu as the name for the new net service. Enter the name, and then click Next.
    Entering a service name without a domain (e.g., iugp instead of iugp.iu.edu) can cause connection problems.
  9. If you want to configure another net service name, select Yes, and then repeat steps 4 through 8 above. Otherwise, select No, and then click Next.
  10. Once you have configured all of your net service names, click Next twice, and then click Finish.
  11. In the 'Finish' dialog box, you will see 'The installation of Oracle Client was successful'. Click Close.

After following these steps, you are finished setting up the Oracle client. You may want to continue with one of the following sections:

Adding new database services

If you have the TNS_ADMIN environment variable set on your workstation and have a tnsnames.ora file stored there, following these instructions will update that file instead of the tnsnames.ora file in your Oracle Home network administrator directory.

To configure your Oracle client to connect to an Oracle database on a remote computer:

  1. From the Start menu, select All Programs > Oracle- OraClient11g_home1 > Configuration and Migration Tools > NetConfiguration Assistant.
  2. Select Local Net Service Name Configuration, and then click Next.
  3. Select Add, and then click Next.
  4. Enter the full service name (e.g., iugp.iu.edu), and then click Next. If you do not know the full service name, contact the High Performance Systems group to check with the database administrator.
  5. Select TCP, and then click Next.
  6. Enter your hostname (for the iugp SID, the hostname is rdc03.uits.iu.edu). Unless otherwise specified, leave 1521 as the port number. Then, click Next.
  7. Select Yes, perform a test, and then click Next.

    If the login test fails, select Change Login, enter your user information, and then try again.

    When the test is successful, click Next.

  8. The UITS High Performance Systems group recommends using iugp.iu.edu as the name for the new net service. Enter the name, and then click Next.
    Entering a service name without a domain (e.g., iugp instead of iugp.iu.edu) can cause connection problems.
  9. If you want to configure another net service name, select Yes, and then repeat steps 4 through 8 above. Otherwise, select No, and then click Next.
  10. Once you have configured all of your net service names, click Next, and then click Finish.

Connecting to Oracle with SQL*Plus

The SQL*Plus graphical application and SQL*Plus Worksheet are no longer available in Oracle 11g.

To connect to Oracle with SQL*Plus:

  1. From the Start menu, select All Programs > Oracle - OraClient11g_home1 > Application Development > SQL*Plus.
  2. At the command prompt, enter your Oracle username followed by @ and the net service name you configured (e.g., [email protected]).
  3. Click Enter. When prompted, enter your password, and then click Enter again.
  4. If this is your first time connecting to the database, you will be prompted to enter a new password. If prompted, enter a new password, click Enter, re-enter your new password, and then click Enter again.

After you've completed these steps, you will be in the SQL*Plus command-line environment.

If you want to reset your password, at the command prompt, enter password. When prompted, enter your current password, then your new password, and then your new password again. SQL*Plus will confirm a successful password change.

Starting SQL Developer the first time

The first time you open SQL Developer, you must specify the path to the Java executable (java.exe). After connecting for the first time, you will no longer need to set the path to java.exe.

To specify the path to java.exe:

  1. From the Start menu, select All Programs > Oracle - OraClient11g_home1 > Application Development > SQL Developer.
  2. The 'Oracle SQL Developer' dialog box will prompt you to enter the full pathname for java.exe. Click Browse to find the file.

    The executable is most likely in your ORACLE_HOME directory in the jdkbin subdirectory; for example:

  3. When you find the path to the file, click OK. SQL Developer should start.

Configuring and locating an ODBC data source

Programs that use ODBC to connect to remote databases need a way to identify the type of database and the host to which they are connecting. This is managed with an ODBC data source that associates a name with its database connection information. For Oracle, the database connection information is the name of the Oracle Net service you specified when you configured the Oracle client.

  1. From the Start menu, click All Programs > Oracle - OraClient11g_home1 > Configuration and Migration Tools > Microsoft ODBC Administrator.
  2. Enter a Windows administrator username and password.
  3. At the top of the 'ODBC Data Source Administrator' window, select System DSN, and then click Add.
  4. From the list of drivers, select Oracle in OraClient11g_home1, and then click Finish.
  5. In the window that appears, enter your information, and then click OK.

    For example, to create an Oracle ODBC data source for the iugp database on rdc03.uits.iu.edu:

    • For 'Data source name', enter iugp_ora.
    • For 'Description', enter something to remind you why you created this ODBC data source (e.g., 'Oracle ODBC for IUGP DB on rdc03.uits.iu.edu').
    • For 'TNS service name', enter the Oracle Net service name you created for the database to which you are connecting (e.g., iugp.iu.edu).
    • Leave the 'Username' field blank; you will be prompted for your username when you make an ODBC connection to the database.
  6. The ODBC data source you added will now appear in your System DSN list. Click OK to finish your ODBC configuration.

Oracle client configuration information for the IU Data Warehouse

The following information is intended for IU Data Warehouse users only.

Use the following configuration information when configuring OracleNet to connect to the IU Data Warehouse:

  • Development (dss1dev):
    • Database service name:dss1dev.uits.indiana.edu
    • Hostname:iedssdev.uits.indiana.edu
    • Port:1521 (default)
    • Net service name:dss1dev.uits.indiana.edu
  • Test (dss1tst):
    • Database service name:dss1tst.uits.indiana.edu
    • Hostname:esdbd99.uits.iupui.edu
    • Port: 1521 (default)
    • Net service name:dss1tst.uits.indiana.edu
  • Production (dss1prd):
    • Database service name:dss1prd.uits.indiana.edu
    • Hostname:esdbd100.uits.indiana.edu
    • Port:1521 (default)
    • Net service name:dss1prd.uits.indiana.edu

Getting help

If you need help connecting to your Oracle database, email the High Performance Systems group.