When dbRadar starts the connect screen will appear:
Starting with version 1.4.0 Oracle client libraries are supplied with the application. To make a connection with an oracle databases you need to set ORACLE_HOME or TNS_ADMIN env variable so that the client can find the tnsnames.ora file. Only DB2 client libraries need to be installed to have access to the database. Choose the connection you want from the driver combo box and fill in the text boxes with the appropriate information. Ex for Oracle connections:
Driver - the driver that creates the connection
Database Name - the name of the database we want to connect(for Oracle - connect string)
Username - the user who will make the connection
Password - the password for the user
Connection Mode - (only for Oracle) :Normal, Sys_Dba, Sys_Oper
Hostname - the name or IP address of the database server we want to connect to. (Not needed for Oracle). Based on this address we can monitor the remote server
Port - the port for the server database.
Use this port if the database process is running on a different port than the default one.
Oracle Applications - if the Oracle database is running Oracle Applications 11.0 or 11.5 the sysdba can monitor users and kill sessions.
An upcoming version will allow you to view concurrent requests.
Unix login - asks you for the username and password of a valid user that has shell access on the server. This way you can monitor the load of the server and all running processes.
The remote server needs to be Linux, HP-UX or Sun OS and have rexecd (512 port) daemon process running so you can have access to those informations.
The connections are logged so when you connect next time you don't have to fill in all the information for the connection.
Just choose the appropriate one from the list of connections:
If the connection is successful the worksheet is open and the user can use any DDL or DML that the target database supports.
dbRadar uses the MDI approach for representing all of its child windows.
This means that the user can open as many windows as he wants, close and navigate through them.
From the File menu the user can Print, Save and Load any text files into the worksheet and execute them as SQL scripts. The user can drop the actual connection with the database and start a new one from the File menu. In the worksheet the user can cut, copy and paste any text using the appropriate key (CTRL-X, CTRL-C, CTRL-V) combination or by choosing the edit menu after the text has selected.
The Database menu offers the user the ability to open a new worksheet or a new system load window. To switch from one window to another use the Window menu.
