Toad Oracle Remote Database Configuration Steps

Toad Oracle Remote Database Steps to Step configuration

This  Tutorial for Guid  Toad Oracle Remote Database Configuration Steps to Step configuration for windows

Requirements

Toad -  http://www.toadsoft.com/

Oracle Instant Client  - Instant Client Package - Basic

Installing to Windows NT/2000/XP

The first installation we will be performing is to Windows NT/2000/XP.

Just execute the toad installation file and finish the installation

Now you need to extract the instant client zip file . and copy the path

Add this directory to the PATH environmental variable 

Right click on My Computer, go to the advanced tab, and click 'Environment Variables'. Under System variables, find 'Path'. Select it, and click edit.  Paste the copied path or press ctrl-v and click ok

In the same window, under 'User variables ', Click the New button. Call the variable 'TNS_ADMIN'. ctrl-v to paste the directory path into the 'variable value' field. Say OK, and close out the 'My Computer' properties windows

Create a file called 'TNSNAMES.ORA' in your instant client installation directory. In this file designate the connection parameters for your database. Just copy the below code  and paste to inside 'TNSNAMES.ORA' file

Code

Now Replace the DB_ALIAS (Optional)   ,

Replace  ip address(192.168.1.1) to your corresponding oracle server ip address or server name,

Next replace port number , and SID with your settings

now  open  Toad application , and then open a new connection. You should see DB_ALIAS as an option under the database field. Set your username and password,  and click connect