Toad can connect to one or more databases. You can create, store, change, and organize these connections all from one convenient location.
You create, store, view, and edit database connections from the Database Login window.
To open the Database Login window
From the main Toad menu, select Session | New Connection.
To connect to a database server (referred to simply as database), Toad requires that you have the following:
The Oracle client installation generally includes connection configuration files that are used to facilitate communication between your computer and the database. Toad uses the following connection configuration files, depending on the connection type you select.
Oracle connection files
Connection File | Description |
---|---|
SQLNET.ora |
Specifies configuration details for Oracle's networking software, such as trace levels, the default domain, session characteristics, and the connection methods that can be used to connect to a database (for example, LDAP and TNSNAMES). If a method is not listed, you cannot use it. Toad uses the SQLNET.ora file for all connection methods, and consequently you must be able to access this file for any connection method. |
TNSNames.ora |
Defines database address aliases to establish connections to them. Toad must be able to access the TNSNames.ora file for TNS connections. |
IFILE |
Toad supports the IFILE directive within TNS Names files. The IFILE directive allows you to link to an external TNS Names file and dynamically include its contents along with the contents of your local TNS Names list. You can include TNS files up to three levels deep in order to organize and manage TNS entries within your company. You can open an IFILE reference by right-clicking the reference and then selecting Open in Other Editor. |
LDAP.ora |
Defines directory access information using Lightweight Directory Access Protocol (LDAP). Toad must be able to access the LDAP.ora file for LDAP connections. |
Use the Database Login window to create and edit database connections.
Note: Toad does allow you to enter the connection information directly in the Database Login window, but this method forces you to connect to the database, and you cannot enter some of the additional connection information until after you connect.
To connect to an Oracle Cloud Database, see the online help. You must set it up so you connect from Toad to the cloud database by establishing an SSH tunnel and then directing the Toad connection through the tunnel.
To create or edit a connection
Click on the standard toolbar to open the Database Login window.
You can also select Session | New Connection.
On the Database Login toolbar, click (Create New Connection) to create a connection, or select a connection then click
(Edit Login Record) to edit an existing record. The Add Login Record or Edit Login Record window is shown.
Complete the User/Schema and Password fields.
Method | Description |
---|---|
Select a database in the Database field. Toad uses the listings in your TNSNames.ora file to populate the list. You must use TNS when connecting to an Oracle Cloud database. | |
Direct |
Enter the Host, Port, and either the Service Name or SID of the database to which you want to connect. You must use Service Name rather than SID to connect to an Oracle 12c Pluggable database. |
Select the LDAP descriptor in the LDAP Descriptor field. | |
Notes:
If Toad cannot connect to one of these files, a red X displays beside the editor button for that file. For example, the following image indicates that Toad cannot access the LDAP.ora file. You would have to resolve the issue before you could make an LDAP connection.
|
Complete the remaining fields as necessary.
Field | Description |
---|---|
Connect as |
Select the connection privilege level field. |
Color |
You can use connection colors to help you distinguish between open connections. Color Code the User Interface per Connection |
Connect Using |
Select the Oracle home. Default Oracle homes can be assigned for a connection or for Toad. When a default Oracle home is assigned to a particular connection, any time you make that connection from the connection grid, Toad automatically uses that Oracle home. When a default Oracle home is assigned to Toad, Toad automatically uses that Oracle home any time you create a connection to a new database. See Select a default Oracle Home in the online help for more information about how Toad manages Oracle homes. |
Alias |
Enter a description or Toad based alias or nickname for the connection. By default the alias only displays in the connections grid, but you can have Toad display the alias instead of the database name. To enable this option, select View | Toad Options | Windows and select the Use alias instead of database checkbox. |
Execute Action upon Connection |
An Action in the Automation Designer can be automatically executed upon making a connection:
See Automation Designer Overview in the online help for more information about how to automate frequently used tasks. Notes: Toad only executes actions upon connection when you execute through the user interface. Toad does not execute actions when it is executed through command line. |
Custom Columns |
Complete the custom fields, if you have defined any. |
Save Password |
Select to have Toad remember the password for only this connection. Note: If Save passwords is selected in the Database Login window (to save passwords for all current and future connections), then this field is selected by default. |
Auto Connect |
Select to have Toad automatically make the selected connection on startup. |
Favorite |
Select this checkbox to mark the connection as one of your favorites. You can have the Database Login window only display your favorites by selecting Show favorites only at the bottom of the window. |
Read Only | Select this checkbox to make the connection read only, meaning that you cannot make any changes to the database. This option is especially helpful when you want to access data for a production database but you do not want to accidentally make any changes. |
Save the login record.
To save the record and reuse the field values to quickly enter new connections, click Post.
You can have Toad save all passwords automatically or individually save passwords for selected connections.
Passwords are saved in an encrypted file named Connections.xml. The encryption is tied to the currently logged in user profile, and it supports roaming profiles and Citrix installations.
Important: To save a connection password, you must connect to the database first.
Note: If the Save Password field is disabled, your ability to save passwords may have been removed during installation. See the Toad for Oracle Installation Guide for more information.
To save all passwords automatically
Click on the standard toolbar to open the Database Login window.
You can also select Session | New Connection.
To save passwords for individual connections
Click on the standard toolbar to open the Database Login window.
You can also select Session | New Connection.
Select the connection in the connection grid.
Note: If the connection is not listed in the connection grid, ensure that the Show favorites only and Show selected home only fields are cleared. If it still does not display, connect to the database again.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center