After selecting the menu you will be presented with the following dialog.
The filling out of this dialog is pretty straight forward.
Previous connections | This list contains the previous connection made, selecting an entry from this list will set all the values to the right to the correct values to connect to this database again. |
Connection provider | The type of connection to create. Usually Oracle, but MySQL is also supported on some platforms. |
Username | The username with which to connect to the database |
Password | The password to use for the connection, this defaults to manager. You can also configure TOra to remember your last used password in the options dialog. |
Use SQL*Net | This is perhaps the most difficult setting. This indicates whether to connect locally to the database or use SQL*Net. If you check this box the connection is made through the Oracle listener, otherwise a local connection usually using shared memory or named pipes is made. This is only available for Oracle connections. |
Hostname | The host on which the database resides. This is only available for non Oracle connections. |
Database | What database to connect to, the listbox is filled with the values available in your tnsnames.ora file. |
Connection Mode | The type of connection to make, usually normal always suffices here. But sometimes during database administration SYS_DBA or SYS_OPER is needed. If you don't know what these mean you probably shouldn't be using them. |
Also you need to be able to create the plan table if that is not done for you. The plan table (See options for how to select plan table name) must also be available with INSERT and SELECT access. TOra will function without the plan table but off course you will not be able to display any execution plans.