Running the run_oracle_db_scripts.sql script in a standalone Oracle environment

Before you configure the Oracle environment, you must back up the SPFILE file.

Also, see the detailed information at Running-the-set_system_parameter_oracle_pnet-sql-script.

To set up a standalone Oracle database instance environment

1. From the Infrastructure Management DVD or files copied from the EPD download site, access the custom database scripts appropriate for your operating system:
   <operating system>\Utilities\oracle
2. Create a temporary directory on the computer where the Oracle database is installed.
3. Copy all the files in the \Utilities\oracle directory to the temporary directory you created in step 2 on the computer where the Oracle database is installed.
4. Log on to SQLPlus by entering the following command:
   sqlplus sys/sys_pwd@ORACLE_SERVICE_NAME as sysdba
5. Run the run_oracle_db_scripts.sql script by entering by the following command:
   @run_oracle_db_scripts.sql
   

6. Respond to the prompts to provide the following information:

   • Tablespace name (default name is pnet_ts.)
   • Tablespace size (specify small, medium, or large. A small deployment creates a 15GB tablespace. A medium or large deployments create a 30GB tablespace. The default tablespace size is small.)
   • Directory where you want the tablespace to be created
   • Main user name (default user name is proact)

   • Password for main user (default password is proact)

     Note

     (for Oracle 11.2 only) If you have run the set_system_parameter_oracle_pnet.sql script, you can skip the two prompts documented below and exit the run_oracle_db_scripts.sql script by pressing the Ctrl+C or Ctrl+D keys.

   • (for Oracle 11.2 only) When prompted to restart the database, restart the database as described in Stopping and starting the Oracle database.
   • (for Oracle 11.2 only) sys user name, password, and Oracle SID

   The script creates the Oracle system parameters, tablespaces, and the initial user accounts and permissions.

   Note

   Only one data file is added to the tablespace created by the script. However, if required, you can add additional data files to the same tablespace before the tablespace is filled up. For information about adding additional data files, see Extending the tablespace.

7. Log on to SQLPlus by entering the following command:
   sqlplus sys/sys_pwd@ORACLE_SERVICE_NAME as sysdba

8. Enter the following commands:

   Alter system set memory_max_target=<mem_amount>M scope=spfile
   Alter system set memory_target=<mem_amount>M scope=spfile

   mem_amount is the maximum amount of memory that you can allocate for your Oracle database instance. The memory for each parameter must be set to at least 50% of the total memory available for one Oracle database instance.
   
   For example, if the RAM size of the computer on which Oracle is installed is 4GB, the memory_max_target and memory_target parameters must be set to 2GB as shown:

   Alter system set memory_max_target=2000M scope=spfile;
   Alter system set memory_target=2000M scope=spfile;
9. Restart the database as described in Stopping and starting the Oracle database.

Where to go from here

After you have created and configured the Oracle database instance, that is, tablespace, database user, and INIT parameters, verify the Oracle configuration using the OracleSchemaPreInstallCheck.sql script. 

You can then install the BMC TrueSight Infrastructure Management Server as described in Installing-the-Infrastructure-Management-Server-on-Microsoft-Windows-with-Oracle and Installing-the-Infrastructure-Management-Server-on-Linux-with-Oracle.