SQL Navigator
What objects are install during installation of "Server-Side Installation", how do I install them?
The Server Side Install refers to creating certain objects on your database, which are required for particular features of SQL Navigator to be available. You do not need to do the Server Side Install if you do not need the option provided by it. (i.e. Base SQLNav Repository, Explain Plan Support, Team Programming, Third Party Version Control, and SQL Navigator Tuner Objects)
To install the server-side components:
1. From the Tools menu, run the SQL Navigator Server Side Installation Wizard.
2. If upgrading from a previous version of SQL Navigator, choose the Remove option before installing, then run the Wizard again to install the new version.
3. When prompted, select the installation scripts you want to run. The following are brief descriptions of the installation script options. (For more detailed information about the installation scripts, see the sample scripts in the Install subdirectory.)
------------------------------------------------------------------------------------------------------------------------------------------------------------------
Base SQLNAV Repository:
This script - which is required - creates a user named SQLNAV with the role SQLNAV_ADMIN. It also creates the schema and other basic server side objects SQL Navigator needs to run. See sample script crtuser.sql.
Explain Plan Support:
This script places an Explain Plan table in the SQL Navigator schema. The Explain Plan function won't work without it. See sample script crtsqltb.sql.
Team Programming:
This script adds basic version control support for sites that do not have the Version Control Option. This basic support includes tables that enable SQL Navigator users to lock access to objects while editing them. See sample script crtcheck.sql. Note: For true version control support, install the "Third Party Version Control" script (see below) - not this one.
Third Party Version Control:
Select this option if you are using the SQL Navigator Version Control Option. This script adds support needed for SQL Navigator to interoperate with third party Version Control systems (Microsoft Visual Source Safe, Intersolv PVCS). See sample script vcs.sql.
Arguments View:
Install this script only if you are running Oracle 7.3.0 or earlier. This script adds support needed for SQL Navigator to retrieve arguments for Stored Programs. It is essential for the correct operation of the debugger. See sample script crtview.sql.Note You must be connected as SYS to run this script.
SQL Navigator Tuner Objects:
This script adds objects to support the SQL Navigator Tuner/Xpert Options, and is required for the use of those options.
------------------------------------------------------------------------------------------------------------------------------------------------------------------
4. You need to log on as a user with DBA privileges to select a database and tablespace to install the objects. You will need to log on as this same user if you wish to uninstall the objects and note that this user will be granted the SQLNAV_ADMIN role during this installation.
5. After successful connection to the database, enter the password for the SQLNAV user, which is created to hold the objects.
6. To begin the install process click Install. After this process you will be prompted to view the install script. This should show successful for each script execution. If this is not successful you may not have functionality of certain options in SQL Navigator. If you find all successful with a failed to connect message at the end check the following:
a. Verify that you have ADMIN rights to your machine if on WIN NT
b. Check in your registry under HKEY_LOCAL_MACHINE/SOFTWARE/QUEST SOFTWARE/SQLab Developer and make sure that the Value: SQLab Developer under this key has the value data of the path to your SQL Navigator Tuning Module (this is where you installed the tuning module on your machine)
7. When the installation is complete, click Finish.
