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
1. Click on the standard toolbar to open the Database Login window.
You can also select Session | New Connection.
2. 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.
3. Complete the User/Schema and Password fields.
4. Select a connection method:
Toad 14.2 Getting Started Create and Manage Database Connections 21
Method Description
TNS 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.
LDAP Select the LDAP descriptor in the LDAP Descriptor field.
Notes:
l Toad must be able to access the SQLNET.ora file to use any of the connection methods.
l Toad must be able to access the LDAP.ora file for LDAP connections.
l Toad must be able to access the TNSNames.ora file for TNS connections.
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.
Toad 14.2 Getting Started Create and Manage Database Connections 22
5. 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:
a. Highlight the connection and click Edit Login Record.
b. Select Execute Action upon Connection and specify the Action. The Action displays in the Action field of the connection window. You can also select a parameter file.
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.
Organize Database Connections 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.
Save Connection Passwords 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
Toad 14.2 Getting Started Create and Manage Database Connections 23
Field Description
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.
6. Save the login record.
l To save the record without connecting to the database, click OK
l To save the record and connect to the database, select the Connect checkbox and click OK.
l To save the record and reuse the field values to quickly enter new connections, click Post.