Installation of Oracle Database Client Software

Leave a reply

Installation of Oracle Client 11g

1. Download the Oracle Client software from the Oracle site.

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

Note: I am downloading 32 bit software. Please download as you requirement.

2. First accept the license agreements and then start download the Oracle Client Software:

1.png3. Unzip the Win32 bit client software.

3. Install the setup of the client:

2

4.Select the administrator option and click next.

3

5. Default language is already selected, Go to Next

5.png

6. Choose the location of Oracle Home where you want to install.

6.png

7. After pre check done, Click Next.

7

8. Click Finish to install Oracle Client.

8.png

9. Installation started for oracle client.

9

10. Installation is completed.

10.png
 
11. Copy/Create the tnsnames.ora and sqlnet.ora files.

Example of TNS Entry:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IXC1-LP48ZJ622.FNFIS.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)


12. Test with TNSPING command that tns entries is correct

tnsping XE

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

w
Cancel

Connecting to %s