If there is a 64-bit Oracle DATABASE running on this same server, then do nothing and leave the database and its client alone. AND you can install the 32-bit ODP.NET client in a new ORACLEHOME directory different from the database ORACLEHOME.
Oracle 11g Release 2 is not compatible with Windows 10. Windows 10 users should instead. Scroll down to 'Oracle Database Client (12.1.0.2.0) for Microsoft Windows (64-bit)' and click winx6412102client.zip to download the 64-bit Oracle 12.1 client.At Indiana University, to download the Oracle Database 11g Release 2 client for 64-bit Windows, use either of the following methods:. This method requires a valid OTN (Oracle Technology Network) username and password.
If you do not have a valid OTN username and password, visit. At the top, click Sign In/Register, and then follow the on-screen instructions. This method requires a valid IU.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 )Downloading the client directly from Oracle's websiteTo download the client Oracle Database client directly from Oracle's website:. Go to. 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 (x64)', click win6411gR2client.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.
Save the win6411gR2client.zip file. In Windows, navigate to the file, right-click it, and then select Extract all. Select or create 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.At this point:. Windows may prompt you for an 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. Downloading the client from IUwareTo download the Oracle Database client from:.
Go to. Click Log in for access. If prompted, enter your IU Network ID username and passphrase, and then click LOGIN. Under 'DOWNLOADS', click Oracle11gR2Client64bit.exe. This file requires 609 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 Oracle11gR2Client64bit.exe. 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. 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. 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.
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. 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. 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.0client1).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.
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.NETTo 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 below. If you choose to configure the Oracle Net client at a later time, use the instructions in at that time.
Configuring Oracle NetTo 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.eduIf you use the IU Data Warehouse, for configuration information, see below. 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).
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 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:. The SQL.Plus graphical application and SQL.Plus Worksheet are no longer available in Oracle 11g.To connect to Oracle with SQL.Plus:. From the Start menu, select All Programs Oracle - OraClient11ghome1 Application Development SQL.Plus. At the command prompt, enter your Oracle username followed by @ and the net service name you configured for the database connection (e.g., [email protected] or [email protected]).
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 timeThe 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:. From the Start menu, select All Programs Oracle - OraClient11ghome1 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 ORACLEHOME directory in the jdkbin subdirectory; for example:c:Oracle11gR2product11.2.0client1jdkbinjava.exe. When you find the path to the file, click OK. SQL Developer should start. Configuring and locating an ODBC data sourcePrograms 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.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |