These instructions apply to Microsoft Windows only. When you install Oracle database software (try installing Enterprise edition), by default it also installs Oracle client. So if you have installed Oracle database software in your machine and want to connect to your local database you simply invoke the Oracle Client and given the necessary login credentials and you are in. You do not have to worry much about setting up your sql*net configuration as the installation process should usually take care of that if you chose to do so.
But for people who want to access an Oracle database that is not local and in a remote machine then you must need to install Oracle client in your machine. Even if You do not want to use SQL*Plus but want to use TOAD or SQL Developer or something like that, you still need Oracle client. Because internally these database access/development tools use Oracle clients software to connect to the target database.
So the most important thing to remember is, you must need Oracle client software in your machine if you want to connect to a remote Oracle database.
Installing Oracle client is not difficult. You just need to be a bit careful. The step by step instructions below should help you to install an Oracle Client in your machine. These instructions assume that you have downloaded the Oracle client software that you desire to install and unzipped the zip file into some folder.
To make the instructions easy to understand I’ll explain what I did here:
1. Downlaoded Oracle Client Software from Oracle (zip file win32_11gR1_client.zip). This file is almost 500MB.
2. Unzipped win32_11gR1_client.zip into C:\win32_11gR1_client folder. A sub folder called “Client” is created under folder “c:\win32_11gR1_client”. Within the Client sub folder there is a file called setup.exe, this is the file I’ll run.
3. I want to install my Oracle Client in my D: disk drive.
System Requirement: Oracle client is not so much of a heavy software but still it needs significant amount of disk space. So make sure that you have at least 1GB free in your disk drive where you want to install your client.
1
Open Windows Explorer and navigate to c:\win32_11gR1_client\client
2
Run setup.exe (double click on it).
3
Wait until the following screen is displayed
Click Next on this screen
4
Select Administrator and then click Click Next button
5
Enter d:\oracle for Oracle Base
Click Next button
6
Click Next button again on this screen.
7
Click Install
8
The installation will now start as shown below.
Wait until the installation is 100% complete
9
The installation process will now try to configure Oracle Net Configuration.
Do not do anything. Wait until you get the following screen
10
Click Next
11
Click Finish
12
Click Exit
13
Click Yes
14
Done
No comments:
Post a Comment