Version 19.11.0.0.0
- Win32 11gr2 Client Zip 11.2.0.3 Denon Avr 2310 Firmware Update Ariel Compressors Manual Kumkum Serial Video Songs Download Star Wars Edge Of The Empire Character Generator For Mac Prince Rare Music Adobe Acrobat Imposition Plugin For Acrobat Adobe Wada Raha Pyar Se Pyar Ka 48kbps Aladdin Hasp Key Driver Windows 8 64 Bit.
- Oracle Database 11gR2 (11.2.0.4) installation on Oracle Linux 6.4. In this post, I’m installing the Oracle Database 11g Release 2 (11.2.0.4) software on Oracle Linux 6.4, along with optional instructions on how to apply the latest Patch Set Update (PSU) to your new Oracle home. First and foremost, before you start, make sure your Linux server.
- Download win3211gr2client.zip launch the oracle client installer by clicking setup.exe. How to download & install oracle database 11g release 2. Click on downloads and select oracle database express edition 11g release 2 for windows x32 to start the download.
Base - one of these packages is required
Enter your oracle credentials and click sign in. Download win3211gr2client.zip launch the oracle client installer by clicking setup.exe. Oracle 11g release 2 is not compatible with windows 10. Every enterprise needs to securely maintain their data.
Name | Download | Description |
---|---|---|
Basic Package | All files required to run OCI, OCCI, and JDBC-OCI applications (77,699,059 bytes) (cksum - 779533051) The 19c Basic package requires the Microsoft Visual Studio 2017 Redistributable. | |
Basic Light Package | Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support (37,455,023 bytes) (cksum - 3314189442) The 19c Basic package requires the Microsoft Visual Studio 2017 Redistributable. |
Tools - optional packages
Name | Download | Description |
---|---|---|
SQL*Plus Package | The SQL*Plus command line tool for SQL and PL/SQL queries (886,533 bytes) (cksum - 1288122467) | |
Tools Package | Includes Data Pump, SQL*Loader and Workload Replay Client (1,095,201 bytes) (cksum - 222494501) |
Development and Runtime - optional packages
Name | Download | Description |
---|---|---|
SDK Package | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,504,919 bytes) (cksum - 3588513517) | |
JDBC Supplement Package | Additional support for Internationalization under JDBC (1,583,367 bytes) (cksum - 4070511683) | |
ODBC Package | Additional libraries for enabling ODBC applications (788,814 bytes) (cksum - 367354370) | |
Precompiler Package | Precompiler Downloads | Additional files for Pro*C and Pro*COBOL |
Version 18.5.0.0.0
Base - one of these packages is required
Name | Download | Description |
---|---|---|
Basic Package | All files required to run OCI, OCCI, and JDBC:OCI applications (74,140,828 bytes) (cksum - 297900794) | |
Basic Light Package | Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support (35,549,981 bytes) (cksum - 1491364376) |
Tools - optional packages
Name | Download | Description |
---|---|---|
SQL*Plus Package | The SQL*Plus command line tool for SQL and PL/SQL queries (884,077 bytes) (cksum - 3590737221) | |
Tools Package | Includes Data Pump, SQL*Loader and Workload Replay Client (950,904 bytes) (cksum - 3310954301) |
Development and Runtime - optional packages
Name | Download | Description |
---|---|---|
SDK Package | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,502,950 bytes) (cksum - 330016902) | |
JDBC Supplement Package | Additional support for Internationalization under JDBC (1,580,553 bytes) (cksum - 4009011077) | |
ODBC Package | Additional libraries for enabling ODBC applications (748,991 bytes) (cksum - 2563637832) | |
Precompiler Package | Precompiler Downloads | Additional files for Pro*C and Pro*COBOL |
Version 12.2.0.1.0
Base - one of these packages is required
Name | Download | Description |
---|---|---|
Basic Package | All files required to run OCI, OCCI, and JDBC:OCI applications (71,881,824 bytes) (cksum - 3943816961) The 12.2 Basic package requires the Microsoft Visual Studio 2013 Redistributable. | |
Basic Light Package | Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support (33,952,164 bytes) (cksum - 3100478757) The 12.2 Basic Light package requires the Microsoft Visual Studio 2013 Redistributable. |
Tools - optional packages
Name | Download | Description |
---|---|---|
SQL*Plus Package | The SQL*Plus command line tool for SQL and PL/SQL queries (869,596 bytes) (cksum - 3936688114) | |
Tools Package | Includes Data Pump, SQL*Loader and Workload Replay Client (953,250 bytes) (cksum - 3613837252) |
Development and Runtime - optional packages
Name | Download | Description |
---|---|---|
SDK Package | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,477,702 bytes) (cksum - 4177145789) | |
JDBC Supplement Package | Additional support for Internationalization under JDBC (1,575,019 bytes) (cksum - 3111443322) | |
ODBC Package | Additional libraries for enabling ODBC applications - Updated 9/22/2017 (730,779 bytes) (cksum - 2384457566) | |
Precompiler Package | Precompiler Downloads | Additional files for Pro*C and Pro*COBOL |
Version 12.1.0.2.0
Name | Download | Description |
---|---|---|
Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (67,410,370 bytes) (cksum - 530881682) The 12.1 Basic package requires the Microsoft Visual Studio 2010 Redistributable. | |
Instant Client Package - Basic Lite | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (33,851,306 bytes) (cksum - 3971707995) The 12.1 Basic Light package requires the Microsoft Visual Studio 2010 Redistributable. | |
Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,573,642 bytes) (cksum - 2509633653) | |
Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (805,513 bytes) (cksum - 2478532846) | |
Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,951,770 bytes) (cksum - 722480528) | |
Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (505,668 bytes) (cksum - 41700632) | |
Instant Client Package - WRC | Workload Replay Client used to replay workload for RAT's DB Replay Feature (15,225 bytes) (cksum - 2411353204) | |
Precompiler Package | Precompiler Downloads | Additional files for 'proc' binary and related files to precompile a Pro*C application and demo |
Version 11.2.0.4.0
Name | Download | Description |
---|---|---|
Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (51,477,933 bytes) | |
Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (20,258,449 bytes) | |
Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,565,746 bytes) | |
Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (757,034 bytes) | |
Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,114,946 bytes) | |
Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (740,921 bytes) | |
Instant Client Package - WRC | Workload Replay Client used to replay workload for RAT's DB Replay Feature (12,962 bytes) | |
Precompiler Package | Precompiler Downloads | Additional files for 'proc' binary and related files to precompile a Pro*C application and demo |
Version 11.1.0.7.0
Name | Download | Description |
---|---|---|
Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (46,734,555 bytes) | |
Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (17,667,999 bytes) | |
Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,562,261 bytes) | |
Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (789,617 bytes) | |
Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,068,348 bytes) | |
Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (728,899 bytes) | |
Instant Client Package - WRC | Workload Replay Client used to replay workload for RAT's DB Replay Feature (6,009 bytes) | |
Precompiler Package | Precompiler Downloads | Additional files for 'proc' binary and related files to precompile a Pro*C application and demo |
Version 10.2.0.5
Name | Download | Description |
---|---|---|
Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (34,846,661 bytes) | |
Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10,670,287 bytes) | |
Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,474,417 bytes) | |
Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (729,651 bytes) | |
Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (875,897 bytes) | |
Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (727,190 bytes) |
Version 10.1.0.5
Name | Download | Description |
---|---|---|
Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (31,926,105 bytes) | |
Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (4,637,410 bytes) | |
Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (269,139 bytes) | |
Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (765,019 bytes) | |
Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (666,571 bytes) |
Downloading Oracle Database 11g Release 2 for 32-bit Windows
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:
- Go to Oracle Database 11g Release 2 for Microsoft Windows (32-bit).
- Click OTN License Agreement, read the license agreement, and then close the window.
- Select Accept License Agreement. You will see a notification thanking you for accepting the OTN License Agreement and permitting you to download the software.
- 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.
- Save the
win32_11gR2_client.zip
file. - In Windows, navigate to the file, right-click it, and then select Extract all.
- Select a destination folder for the extracted files, and then perform the extraction.
- 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:
- Go to OracleClient 11g R2 32-bit.
- 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.
- Under 'Downloads', click Oracle11gR2Client32bit.exe - 698MB. This file requires 698 MB of free space on your hard drive.
- In the 'File Download - Security Warning' dialog box, click Save, select a destination folder, and then click Save.
- To open the IUware installer, go to the destination folder, and then double-click Oracle11gR2Client32bit.exe.
- 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. - 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.
Oracle Home
environment variable set on your computer, remove it before starting the installation (it interferes with setting some paths for the installation).- 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.
- 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.
- 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 selectedOracle Base
directory (e.g.,c:Oracle11gR2product11.2.0client_1
).
Do not use an existing
Oracle Home
directory. If an existingOracle Home
is selected by default, choose a different location.To continue, click Next.
- The first file location is for the
- 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. - 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.
- Verify the installation information in the 'Summary' dialog box, and then click Finish.
- The 'Install Product' dialog box will prepare, copy, and set up files, and configure the installation. It will proceed to the next dialog box.
- The 'Finish' dialog box should show the message 'The installation of Oracle Client was successful'. Click Close.
- 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.
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.- If you cannot see the 'Oracle Net Configuration Assistant: Welcome' dialog box, move the 'Configuration Assistants' dialog box.
- In the 'Oracle Net Configuration Assistant: Welcome' dialog box, make sure Perform typical configuration is not selected, and then click Next.
- 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.
- 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. - Select TCP, and then click Next.
- Enter your hostname (for the
iugp
SID, the hostname isrdc03.uits.indiana.edu
). Unless otherwise specified, leave1521
as the port number. Then, click Next. - 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.
- 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 ofiugp.iu.edu
) can cause connection problems. - 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.
- Once you have configured all of your net service names, click Next twice, and then click Finish.
- 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
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:
- From the Start menu, select All Programs > Oracle- OraClient11g_home1 > Configuration and Migration Tools > NetConfiguration Assistant.
- Select Local Net Service Name Configuration, and then click Next.
- Select Add, and then click Next.
- 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. - Select TCP, and then click Next.
- Enter your hostname (for the
iugp
SID, the hostname isrdc03.uits.iu.edu
). Unless otherwise specified, leave1521
as the port number. Then, click Next. - 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.
- 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 ofiugp.iu.edu
) can cause connection problems. - 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.
- Once you have configured all of your net service names, click Next, and then click Finish.
Connecting to Oracle with SQL*Plus
To connect to Oracle with SQL*Plus:
- From the Start menu, select All Programs > Oracle - OraClient11g_home1 > Application Development > SQL*Plus.
- At the command prompt, enter your Oracle username followed by
@
and the net service name you configured (e.g.,username@iugp.iu.edu
). - Click Enter. When prompted, enter your password, and then click Enter again.
- 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
:
Oracle 11gr2 Client
- From the Start menu, select All Programs > Oracle - OraClient11g_home1 > Application Development > SQL Developer.
- 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 thejdkbin
subdirectory; for example: - 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.
Win32_11gr2_client.zip
- From the Start menu, click All Programs > Oracle - OraClient11g_home1 > Configuration and Migration Tools > Microsoft ODBC Administrator.
- Enter a Windows administrator username and password.
- At the top of the 'ODBC Data Source Administrator' window, select System DSN, and then click Add.
- From the list of drivers, select Oracle in OraClient11g_home1, and then click Finish.
- 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 onrdc03.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.
- For 'Data source name', enter
- 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
Win32 11gr2 Client Download
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
- Database service name:
- Test (dss1tst):
- Database service name:
dss1tst.uits.indiana.edu
- Hostname:
esdbd99.uits.iupui.edu
- Port:
1521
(default) - Net service name:
dss1tst.uits.indiana.edu
- Database service name:
- Production (dss1prd):
- Database service name:
dss1prd.uits.indiana.edu
- Hostname:
esdbd100.uits.indiana.edu
- Port:
1521
(default) - Net service name:
dss1prd.uits.indiana.edu
- Database service name:
Getting help
If you need help connecting to your Oracle database, email the High Performance Systems group.