Install to an existing Oracle database

This task topic describes the procedure for installing the AppScan® Source Database schema and data to an existing Oracle database. In order to create the Oracle schema, the AppScan Source installer must be run on the same machine on which the Oracle database is installed - or on a machine where the full Oracle client is installed (the installer must be able to access the Oracle sqlplus and sqlldr utilities).

About this task

Note: AppScan Source server components, such as the AppScan Source Database, are not supported on macOS.

Procedure

Install the AppScan Enterprise Server according to the installation instructions provided with it. See AppScan Enterprise Server overview to learn more about the server.
Locate the HCL® AppScan Source product zip file (in your AppScan Source media pack - or the electronic image that you downloaded as part of an AppScan Source eAssembly at FlexNet Operations).
Extract the image to a local drive. In the resulting directory:
- Microsoft™ Windows™: Run AppScanSrc_Installer.exe
- Linux™: On 32-bit systems, run setup.bin. For 64-bit systems, see Installing AppScan Source results in error "Graphical installers are not supported by the vm".
- macOS: Open setup.dmg and then run the setup.command script
Detailed information about launching the installation wizard can be found at Starting the installation wizard.
In the Component Selection installation panel, select Server Component Selection and then ensure that AppScan Source Database is selected. Click Next to advance to the next installation panel.
In the Server Connection panel, choose one of these options:
- I will connect to an AppScan Server instance: Selecting this option allows you to test the remote AppScan Enterprise Server to ensure that it is available for connection to AppScan Source. To test the server connection, complete these fields:
  - AppScan Enterprise Server: Specify the hostname for your remote AppScan Enterprise Server instance in the existing URL format.
  - Product Administrator: Specify your AppScan Enterprise Server administrator user ID.
  - Password: Specify the password for your AppScan Enterprise Server administrator user ID.
  When the server settings have been entered, click Test Connection to ensure that the server will be available for connection to AppScan Source.
- Let me proceed without specifying a server: Select this option to proceed without specifying a server.
Important:
- If the Enterprise Server that you will connect to is enabled for NIST 800-131a compliance, you cannot test a connection to the server. In this case, proceed without specifying a server. After the installation of AppScan Source and the Enterprise Server are complete, follow the instructions for Registering the AppScan Source Database with AppScan Enterprise Server, ensuring that the Force TLSv1.2 option is applied.
- If your AppScan Enterprise Server has been set up with Common Access Card (CAC) authentication, select Let me proceed without specifying a server and then use the appscanserverdbmgr_cac utility for all server connection settings and tests.
Click Next to advance to the next installation panel.
In the Installation Target Specification page, specify the installation directory. The default directories, by operating system, are:
- 32-bit versions of Microsoft Windows:
```
<SYSTEMDRIVE>:\Program Files\HCL\AppScanSource
```
- 64-bit versions of Microsoft Windows:
```
<SYSTEMDRIVE>:\Program Files (x86)\HCL\AppScanSource
```
- Linux: If you are the root user, the Installation Wizard installs your software in /opt/hcl/appscansource. If you are not the root user, you can install the AppScan Source for Development Eclipse plug-in - which installs to <home_directory>/AppScan_Source by default.
- macOS: /Applications/AppScanSource.app
Important:
- The installation directory name can only contain English characters. Folders with names containing non-English characters are not permitted.
- If you are installing on Windows, you must have Administrator privileges to install AppScan Source components.
- If you are installing on Linux, you must have root privileges to install AppScan Source server components.
Click Next to advance to the next installation panel.
If the HCL AppScan Source Database component was selected for installation in the Server Component Selection page, the database selection panel displays. In this page, select the Install database into existing Oracle <version> Server radio button and then click Next to advance to the next installation panel.
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.
In the language pack selection panel, choose the language packs to install. When you install a language pack, the AppScan Source user interface will display in that language when it runs on an operating system that is running that locale.
By default, English is selected (and cannot be deselected). If the installation wizard is displaying a national language other than English (in other words, a language other than English was selected in the installation wizard welcome panel), that language will also be selected in this panel (however, it can be deselected).
After you have selected the language packs that you want to install, click Next to advance to the next installation panel.
Note: If you do not install a specific language pack, you will not be able to add that language post-installation.
Review and accept the terms of the license agreement and then click Next to continue.
Review the summary of installation options before proceeding. If you want to change your selections, click Previous to return to the previous pages. When you are satisfied with your installation choices, click Install. The installer copies files to the hard disk drive.
For Linux server installations only: After copying files, you must identify the daemon user. Select Create User 'ounce' or Run with Existing User, either to create the default user, ounce, or run with an existing user. (The installation validates that the user exists. Note that the selected user must have a valid shell.)
During the installation, clicking Cancel at any time results in the uninstallation of all components.
In the HCL AppScan Enterprise Server Configuration panel, specify the settings that will allow a solidDB® database to connect to the AppScan Enterprise Server. By default, this installation panel pre-fills with entries that assume the database and server are installed on the same machine, with default settings. To configure the AppScan Source Database with the AppScan Enterprise Server, select the Configure the AppScan Enterprise Server now check box and complete these settings:
- AppScan Enterprise Server: Specify the URL for your AppScan Enterprise Server instance.
- User ID: Specify your AppScan Enterprise Server administrator user ID. If the server is configured for Windows authentication, enter the Windows user ID that was used when your account was added to the server (the user ID must be in the format <host name>\<user id>).
- Password: Specify the password for your AppScan Enterprise Server user ID.
- Database Host Name: Specify the host name for the machine on which you have installed the AppScan Source Database.
  Note: The entry in this field should always be the fully-qualified host name of the machine on which the installer is running. This value should be pre-filled in this field at install time and should only be changed if the value has pre-filled incorrectly.
Click Next to advance to the next installation panel.

Note: If you will be using an Oracle database, ensure that Configure the AppScan Enterprise Server now is not selected and then click Next. This installation panel is not used for registering an Oracle database with the Enterprise Server. Instead, configure the database connection post-installation using a utility that is included with AppScan Source. Information about this can be found at Registering the AppScan Source Database with AppScan Enterprise Server . This utility can also be used to configure a solidDB connection instead of using this installation panel.
In the Installation Complete panel, you can initiate product activation immediately after exiting the installation wizard by selecting Launch HCL AppScan Source License Manager. Click Done to complete the standard installation and exit the Installation Wizard.
In the License Manager utility:
1. To apply a license file, click Import and then browse to your downloaded AppScan Source license.
2. To apply a floating license, click Configure license servers and then click Add. Enter the information for the host machine that contains the floating license.
See Activating the software for additional activation instructions.