-
Title
How to manually create the Foglight External Oracle database repository. -
Description
How to manually create the Foglight Oracle database repository.
-
Cause
This is method setting the external database up manually after the Foglight 5 install has completed can be recommended to insure the proper Oracle database permissions are regulated as well as connection. It's easier to address any database related errors at this level.
-
Resolution
When you get to step 10, the Foglight Database Configuration Section during the initial Foglight 5 install, choose the later option for manual. This method will copy the database config files needed for the manual installation of the database.
When the installation completes, review the Manual Database Configuration section in the Foglight_Unix_externalOracle guide to setup the database.Have your DBA run the first two scripts below logged in as user 'sys as sysdba'.
Then the remaining two scripts are run logged in as user 'foglight'.Please also reference the attached Performance Tuning Guide should your DBA decided to create tablespaces.
The scripts described below do not create tablespaces. If you need to create new tablespaces, you must do so manually first, before running the scripts. See the
Performance Tuning Field Guide for more information about Oracle Tablespaces.
When you manually configure an Oracle database using the scripts described below, a new user is created in your database. The scripts create the required permissions for this user.---------------
Installation and Setup Guide
Note Check with your database administrator to correctly assign tablespace names.
It is recommended that you create a Foglight label for Data, Index, and Objects.
----------------1 Run SQL*Plus by specifying the following from the command line:
sqlplus <username>/<password>
The SQL prompt appears.-------------------------------
Step 2a & 2b scripts must be run under an account with root privileges (for example, sys as sysdba) since you require system access to
execute it.
------------------------------
2 Run the .sql scripts by issuing the following commands in the order shown below:
a SQL> START <foglight_home>/scripts/sql/oracle_drop_db.sql
b SQL> START <foglight_home>/scripts/sql/oracle_create_db.sql
------------------------------
Step 2c & 2d scripts must be run using the Foglight Database Account User ID that you set in step 1 of Step 10: Foglight Database Configuration. The default Foglight Database Account User ID is 'foglight'.
c SQL> START <foglight_home>/scripts/sql/oracle_create_schema.sqld SQL> START <foglight_home>/scripts/sql/oracle_populate_db.sql
-
Attachments