Oracle Database Server settings
Procedure
If the HCL®
AppScan® Source
Database component was selected for installation in the Server Component Selection page - and
Install database into existing Oracle <version> Server was selected
in the Database selection page - the Oracle Database Server panel displays. In this page,
specify:
- Oracle Home: Specify the location of your Oracle installation.
- Oracle TNS Location: This is the location where the tnsnames.ora file is located. By default, this is <oracle_home>\network\admin (where <oracle_home> is the location of your Oracle installation.
- Oracle Service Name/SID: Specify the connection string or TNS
Alias, for example
//<hostname>:<port>/<OracleServiceName>
. Specifying a TNS Alias requires AppScan Enterprise Server configuration. See Oracle TNS Alias configuration for details. - System User Name: Specify the Oracle user that will be used to
perform the installation. This user name must have authority to create other users. The
default value is
system
- System Password: Specify the password for the System User Name user.
- Test Connection: Click this button to verify that the database settings and credentials that have been provided are correct.
- AppScan User Name: Specify the AppScan Source
Database user to create. The default value is
ounce
. - AppScan Password: Specify the password for the AppScan
User Name user. The default value is
ounce
. - Direct Data Load check box: If selected, the initial AppScan Source data will be loaded via Oracle Direct Load. This check box is selected by default.
- Sysdba User: If the Direct Data Load check
box is selected, specify a user with
sysdba
privileges. The default value issysdba
. - Sysdba Password: Specify the password for Sysdba User.
- Path to SqlPlus: Specify the path on disk to the
sqlplus executable. This will be used to run sql
scripts during the installation. The default value is
sqlplus
. An absolute path is not necessary if the sqlplus executable exists on the system path. - Path to Sqlldr: Specify the path on disk to the
sqlldr executable. This will be used to load data during the
installation. The default value is
sqlldr
. An absolute path is not necessary if the sqlldr executable exists on the system path.
Important: After the installation completes with these settings, a new schema and
AppScan Source
Database user is automatically installed to your Oracle database. The AppScan Source
Database user does not need to be created manually.
Note:
- After completing an installation that includes the installation of the AppScan Source Database schema and data to an existing Oracle database, please see <data_dir>\logs\core_exceptions.log (where <data_dir> is the location of your AppScan Source program data, as described in Installation and user data file locations) to verify that no installation errors occurred.
- If you are connecting the AppScan Enterprise Server to an Oracle database, you must set the character set to UTF-8 (including AL32UTF8) when creating the database (this is typically not the default character set).
- The AppScan Source installation requires, but does not install, the Oracle Instant Client (OCI) libraries. See Installing the Oracle Client (OCI) libraries for more information.
- If you specify a TNS Alias as the Oracle Connection String, you
may see this error in the core_exceptions.log file:
Unable to process the database transaction. Error: ORA-12154
(the message may be accompanied by error text from the Oracle database). To resolve this, complete one of these tasks:- Copy the Oracle tnsnames.ora file to <install_dir>\bin (where <install_dir> is the location of your AppScan Source installation).
- Open <data_dir>\config\ounce.ozsettings (where <data_dir> is the location of your
AppScan
Source program data, as described in Installation and user data file locations). In the file, locate the
tns_admin
setting and change its value to point to the directory that contains the Oracle tnsnames.ora file. Save the changes to the file.
Click Next to advance to the next installation panel.