Downloading the Oracle 11gr2 Client (steps you may have missed)

Posted: July 16, 2014 in Basic Necessities
Tags:

Welcome back, Oracle fans!

 

When you get a new laptop, one of the first tools an Oracle DBA needs is the Oracle Client. Here are a few steps that will make your life easier before and after downloading the client.

 

1) Map network drive to your tnsnames.ora file.  http://windows.microsoft.com/en-us/windows/create-shortcut-map-network-drive#1TC=windows-7

2) Go online and install 11gr2 client (as administrator).  http://www.oracle.com/technetwork/database/enterprise-edition/downloads/ 

3) Set environment variable

START-->System and Security-->System-->Advanced System Settings-->Environment Variables-->System Variables

Select new.

Enter TNS_ADMIN. In the value column, set it to the tnsnames.ora file location you set in step 1.

These steps seem simple and they are. If you skip steps one or three, you may be wondering why your Oracle development tool of choice can’t find your databases.

 

I hope this helps,

Jason

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s