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 is sysdba.
  • 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.