Installation Notes
August 2018
Windows User |
The Windows user that installs and licenses SQL Navigator® requires certain write-access privileges and therefore must be a member of either the Administrators group within Windows, or have equivalent privileges. | ||||||||
Installation Wizard |
The Installation wizard offers the following options:
| ||||||||
Install Directory |
If a previous installation of SQL Navigator 4.x or above is detected, its location will be pre-selected by default For LAN Client installations, browse to the network resource containing the LAN Server installation. |
Server-side configuration is not required for general operation of SQL Navigator. It is required for operation of the Explain Plan Tool. The PL/SQL Profiler and Java->PL/SQL Publisher requires server-side support, which is installed on demand.
You can invoke the Server-Side Installation Wizard from the Tools menu. The wizard requires connection as a DBA user so that the SQLNAV user can be created, as well as a number of roles. The wizard permits you to specify a password of your choice for this user. Note that the option "Base SQLNAV Repository" must be selected on at least one occasion to allow the other support features to be installed. All objects installed by the wizard are installed into the SQLNAV schema.
To save SQL statements in the Explain Plan tool, a special table is required in the SQLNAV schema.
Follow these steps:
The PL/SQL Profiler and Java->PL/SQL Publisher requires server-side support, which is installed on demand.
To install support for PL/SQL Profiler
The PL/SQL Profiler (Oracle 8.1.6 and above) requires server-side support provided by Oracle.
Follow these steps:
V$SESSION
V$SESSTAT
V$STATNAME
To install SQL Navigator-specific support for a single schema
|
TIP: You can also install a central set of tables for storage of Profiler data, however this is not recommended, as these tables may grow quite large. To install, follow the steps above to install into any schema, then (connected as that user) run the script PROF_GLOBAL_INSTALL.SQL. |
To install support for Java Publisher
To publish a Java class to PL/SQL the following are required in the user's schema:
These objects are installed on demand in a similar manner to the Profiler objects.
|
Note: To publish a Java class located in a different schema:
|
Recommended configuration for PL/SQL Debugger
Oracle for Windows version 7.3.4 or higher
SQL*Net 32-bit to connect to the database
Refer also to the online help for details about Oracle support for the SQL Navigator Debugger.
Recommended configuration for Oracle Web Development support
Install Oracle Web Toolkit version 2 or higher on database.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center