Win32 11gr2 Client Zip 11.2.0.3

Download win3211gr2client.zip launch the oracle client installer by clicking setup.exe. To be able to download the link, you'll need to accept the license agreement. Enter your oracle credentials and click sign in. Home » Articles » 11g » Here. Oracle Database 11g Release 2 (11.2.0.3) RAC On Oracle Linux 6.3 Using VirtualBox. This article describes the installation of Oracle Database 11g release 2 (11.2.0.3 64-bit) RAC on Linux (Oracle Linux 6.3 64-bit) using VirtualBox (4.2.6) with no additional shared disk devices.

1. Oracle 11gr2 Client
2. Win32 11gr2 Client Download

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 meets the minimum hardware requirements:

• 1GB of RAM (plus appropriately sized swap space)
• 4.5GB of disk space for the software installation
• 1GB of disk space for your /tmp directory

More details around the requirements can be found here.

Once you’ve installed and configured Linux appropriately (see my Linux installation post here), make sure that the ‘oracle’ user has correct ownership of the /u01 mount point:

…and that the ‘oracle’ account has a password set.

Package and OS requirements

In this example, I’m meeting the package and Operating System requirements by running the following yum command (as root):

This pre-install package will meet the necessary configuration tasks for you, and whilst the name implies it’s for installing Oracle Database Server 11gR2 software, it’s also a useful starting point to prepare your system for installing other Oracle software 😉

If you don’t install the package bundle above, then you’ll have to meet all of the required prerequisites manually, by working through the Oracle documentation here… which involves a lot more effort…

Also, make sure that the ‘/etc/hosts’ file contains a Fully Qualified Domain Name (FQDN) for your server, for example:

Once that’s done, you’re ready to download the software…

Download the ‘patch’ software

Currently, the Oracle Database 11.2.0.4 files are not available to download from the usual Oracle Technology Network (OTN) area, instead you have to log into My Oracle Support (MOS) and search for patch number ‘13390677’. It’s probably worth mentioning at this point, that the ‘patch’ is a full install, despite the reference – so you don’t need to download Oracle Database 11.2.0.2 files in addition here 😉

Once you’ve searched for the ‘patch’, select the link appropriate to your platform, in this case ‘Linux x86-64’. Apowermirror pc mac. When you click download, there will be a total of 7 zip files available. For a standard installation, you only need zip parts 1 and 2…

• p13390677_112040_platform_1of7.zip (Oracle Database, including Oracle RAC components)
• p13390677_112040_platform_2of7.zip (Oracle Database, including Oracle RAC components)
• p13390677_112040_platform_3of7.zip (Oracle Grid Infrastructure, includes: Oracle ASM, Oracle Clusterware, Oracle Restart)
• p13390677_112040_platform_4of7.zip (Oracle Database Client)
• p13390677_112040_platform_5of7.zip (Oracle Gateways)
• p13390677_112040_platform_6of7.zip (Oracle Examples)
• p13390677_112040_platform_7of7.zip (Deinstall)

Once you’ve downloaded the software, unzip both files to a staging area:

All of the contents from the above will be extracted to a “database” directory.

Start the installer

Open an X-Windows session to the server as the ‘oracle’ user.

Once you’ve met the requirements, and have unzipped the software, you can start the install:

/u01/app/oracle/software/database/runInstaller

Once the GUI starts, respond as follows:

• Configure Security Updates
  • Uncheck ‘I wish to receive security updates via My Oracle Support’
  • Next
  • Confirm with ‘Yes’

• Download Software Updates
  • Skip software updates
  • Next

• Installation Option
  • Install database software only (you can opt to create a database instance at the same time, but I’m keeping the two separate here)
  • Next

• Grid Installation Options
  • Single instance database installation
  • Next

• Product Languages
  • Select any additional required languages and move across, otherwise leave just the default ‘English’ selected
  • Next

• Database Edition
  • Enterprise Edition (4.5GB) (…or as appropriate depending on which edition you’re licensed for!)
  • Next

• Installation Location
  • Oracle Base: /u01/app/oracle
  • Software Location: /u01/app/oracle/product/11.2.0.4
  • Next

• Create Inventory (first Oracle installation only)
  • Inventory Directory: /u01/app/oraInventory
  • oraInventory Group Name: oinstall

• Operating System Groups
  • Database Administrator (OSDBA) Group: dba
  • Database Operator (OSOPER) Group (Optional): dba
  • Next

• Prerequisites checks
  • All prerequisite checks should complete successfully here, if not, then obviously they will need addressing before proceeding

• Summary
  • Check everything is correct!
  • Click Install

Run the root.sh script(s)

When prompted, run the following as root:

/u01/app/oraInventory/orainstRoot.sh (first Oracle installations only)

/u01/app/oracle/product/11.2.0.4/root.sh

Finally, back to the GUI, click close to finish, and you’re all done 🙂

Update environment settings

Once the installation has finished, add the appropriate environment variables to your ‘oracle’ user profile.

For example, add this to your existing .bash_profile: Bentley staad pro v8i installation guide.

Reload your profile with the new variables:

Now you’re ready to create your database 🙂

Apply the latest PSU (11.2.0.4.1) – optional

At the time of writing this post, the latest Patch Set Update (PSU) was released in January 2014, that being patch 17478514 for PSU level 11.2.0.4.1.

Download the appropriate PSU from MOS, along with the latest 11.2 OPatch release:

Unzip the OPatch utility to your new ORACLE_HOME, and verify the version number:

Unzip the PSU contents to a staging area:

Check for any potential patch conflicts (which for a new installation, there shouldn’t be!):

Apply the PSU patch:

As per MOS note 1448337.1, you can safely ignore OPatch warnings if they’re like the ones above.

Check the inventory to verify the patch has been registered correctly:

Related posts:
Creating an Oracle 11g Database using DBCA (non-ASM) Babasaheb purandare books in marathi pdf.

References:
Oracle Database Installation Guide 11g Release 2 (11.2) for Linux

The following instructions are for 64-bit Windows. For 32-bit Windows instructions, see ARCHIVED: At IU, how do I download and install the Oracle Database 11g Release 2 client for 32-bit Windows?

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

At Indiana University, to download the Oracle Database 11g Release 2 client for 64-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 Network ID.

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 client Oracle Database client directly from Oracle's website:

1. Go to Oracle Database 11g Release 2 for Microsoft Windows (x64).
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 (x64)', click win64_11gR2_client.zip to download the client. This file requires 609 MB of free space on your hard drive.

   You may be prompted to enter a valid OTN username and password. Once you have done 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 win64_11gR2_client.zip file.
6. In Windows, navigate to the file, right-click it, and then select Extract all.
7. Select or create 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.

   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:

1. Go to Oracle Client 11g R2 64-bit.
2. Click Log in for access. If prompted, enter your IU Network ID username and passphrase, and then click LOGIN.
3. Under 'DOWNLOADS', click Oracle11gR2Client64bit.exe. This file requires 609 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 Oracle11gR2Client64bit.exe.
6. By default, the IUware installer will create a c:IUware OnlineOracle11gR2 Client 64bit 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 double-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.

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. To select a different language, in the box on the left, click your preferred language, and then click > 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 the installer defaults to an existing Oracle Home, 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:

• System Identifier (SID) of the database:oed1prd
• Full service name of the database:oed1prd.world (recommended)
• Port number:1521
• Hostname of computer where database is located:dbserv.uits.indiana.edu

If you use the IU Data Warehouse, for configuration information, see Oracle client configuration information for theIU Data Warehouse below.

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, which is the database SID followed by an extension (e.g., oed1prd.uits.indiana.edu), and then click Next. If you do not know the full service name, check with the database administrator.
5. Select TCP, and then click Next.
6. Enter the hostname (for oed1prd, the hostname is dbserv.uits.indiana.edu). Unless otherwise specified, leave 1521 as the port number, and 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. UITS recommends using oed1prd.world for the name of the new net service. Enter the name, and then click Next.
   Entering a service name without a domain (e.g., oed1prd instead of oed1prd.world) can cause connection problems. You may reuse the service name you entered in step 4 above (e.g., oed1prd.uits.indiana.edu).
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 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

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 > Net Configuration Assistant.
2. Select Local Net Service Name Configuration, and then click Next.
3. Select Add, and then click Next.
4. Enter the service name, which is the database SID followed by an extension (e.g., oed1prd.uits.indiana.edu), and then click Next. If you do not know the service name, check with the database administrator.
5. Select TCP, and then click Next.
6. Enter the hostname (for oed1prd, the hostname is dbserv.uits.indiana.edu). Unless otherwise specified, leave 1521 as the port number, and 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. UITS recommends using oed1prd.world for the name of the new net service. Enter the name, and then click Next.
   Entering a service name without a domain (e.g., oed1prd instead of oed1prd.world) can cause connection problems. You may reuse the service name you entered in step 4 above (e.g., oed1prd.uits.indiana.edu).
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

To connect to Oracle with SQL*Plus:

Oracle 11gr2 Client

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 for the database connection (e.g., username@oed1prd.world or username@oed1prd.uits.indiana.edu).
3. Click Enter. When prompted, enter your password, and then click Enter again.

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

Starting SQL Developer the first time

The first time you open SQL Developer, you must specify the path to the Java executable file (java.exe). After connecting 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 Open Database Connectivity (ODBC) to connect to remote databases must have 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 inOraClient11g_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 oed1prd database on dbserv.uits.indiana.edu:

   Field	Explanation	Example
   Data source name	User-specified name by which you will refer to this ODBC data source	oed1prd_ora
   Description	Not required; just a phrase reminding you why you created this ODBC data source	Oracle ODBC for Oed1prd DB on dbserv.uits.indiana.edu
   TNS Service name	The Oracle Net service name you created for the database to which you want to connect
   Username	Leave 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

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

Win32 11gr2 Client Download

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