Ensuring that your Oracle database is properly configured

Before you install Enterprise Reporter, you need to ensure that your Oracle database is properly configured for use with Enterprise Reporter. To ensure that the database is properly configured, you can run a script that ships with Enterprise Reporter.

To ensure that your Oracle database is properly configured

  1. Log on to the host on which you want to install and configure Enterprise Reporter.

  2. Open the following directory:

    Solaris

    installer_location/sol_sparc/command_central_enterprise_reporter/scripts/Support/OracleInstanceCheck/

    Windows

    installer_location\win\command_central_enterprise_reporter\Support\OracleInstanceCheck\

    where installer_location is one of the following:

    • The directory in which you unzipped or extracted the .zip or tar file

    • The location of your DVD-ROM drive

  3. If the Oracle database runs on a remote host, copy the following file to the Oracle host:

    Solaris

    oracleinstancecheck.pl

    Windows

    oracleinstancecheck.vbs

  4. Open an operating system console.

  5. In the directory where the script resides, type the following command:

    Solaris

    perl oracleinstancecheck.pl --tns TNS_name -- username username --password password --oracle_home Oracle_Home

    Windows

    CScript "oracleinstancecheck.vbs" TNS_name username password "Oracle_Home"

    where:

    TNS_name

    is the TNS name for the Oracle database instance

    username

    is the user name to use for connecting with the Oracle database instance

    password

    is the password for the provided user name

    Oracle_Home

    is the Oracle Home directory

    The script's output lists any settings that do not meet requirements. Correct any issues before you proceed with installation.