TOAD Connect

 

- Info:

- This tutorial shows how to use TOAD to connect to ORACLE DB.

- Connection is done using data from TNSNAMES.ORA located at:

C:\Installed\Programming\OracleExpress\app\oracle\product\10.2.0\server\NETWORK\ADMIN

 

- Procedure:

- Open C:\oracle\ora92\network\ADMIN\tnsnames.ora Paste from tnsnames.ora

- Start C:\Program Files\Quest Software\TOAD\TOAD.exe

- Database:

XE

- User:

myUser

- Password:

myPassword

 

tnsnames.ora

XE =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = vori)(PORT = 1522))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = XE)

    )

  )