Managing the Oracle server

The following sections help you to manage the Oracle server when using Oracle as the database.

Monitoring the Oracle database

After you install the BMC TrueSight Infrastructure Management Server, a remote agentless device is created where Oracle is installed. The following Oracle related monitors under this device are created by default:

• Oracle Query
• Oracle Intelliscope

Install a Integration Service on the Oracle server for tracking the functioning of the remote Oracle server, and BMC recommends you to create some monitors such as the following:

• Disk Space Monitor that monitors the Oracle disk space
• Processes Monitor that monitors the Oracle processes
• Tablespace monitor that will monitor the tablespaces of the Oracle server

Use BMC Performance Manager for Internet Servers to check if the Oracle server is accessible

Stopping and starting the Oracle database

The following procedure explains how to stop and start an Oracle database in the following environments:

• Oracle RAC
• Single Oracle database instance

Stopping and starting the Oracle database in an Oracle RAC environment

The following procedure explains how to stop and start an Oracle database in an Oracle RAC environment.

To stop an Oracle database server on Oracle RAC

1. Log in to the database server as the Oracle DBA Admin user.
2. From a command line, navigate to the path where the .oraenv script is located.
3. Source the .oraenv script:
   $ ../.oraenv
4. Stop the database by entering the following command:
   $ srvctl stop database -d RAC_ORACLE_SERVICE_NAME
5. Confirm that all nodes are stopped by entering the following command:
   $ srvctl status database -d RAC_ORACLE_SERVICE_NAME
   The status of all nodes must be stopped .

To start an Oracle database server on Oracle RAC

1. Log in to the database server as the Oracle DBA Admin user.
2. From a command line, navigate to the path where the .oraenv script is located.
3. Source the .oraenv script:
   $ ../.oraenv
4. Start the database by entering the following command:
   $ srvctl start database -d RAC_ORACLE_SERVICE_NAME
5. Confirm that all nodes are started by entering the following command:
   $ srvctl status database -d RAC_ORACLE_SERVICE_NAME
   The status of all nodes must be running .

Restarting a single Oracle database instance

The following procedure explains how to stop and start a single Oracle database instance:

To restart a single Oracle database instance on Microsoft Windows

1. From a command line, enter the following command:
   set ORACLE_SID= Oracle_SID
2. Enter sqlplus sys/ sys_password as sysdba.
3. Enter shutdown immediate.
   The database shuts down.

4. Enter startup.
   The database starts.

   Note

   Ensure that you restart the BMC TrueSight Infrastructure Management Server after you restart the Oracle database instance.

To restart a single Oracle database instance on a UNIX-based operating system

1. Log in to the database server as the Oracle DBA Admin user.
2. Ensure ORACLE_HOME and ORACLE_SID are correctly defined for the Infrastructure Management instance:
   $ ORACLE_HOME=<oracle_installation_location>; export ORACLE_HOME
$ ORACLE_SID=<tsim_instance_name>; export ORACLE_SID 
3. Connect to the database instance:
   $ sqlplus / as sysdba
4. Shutdown the database instance:
   SQL> shutdown immediate

5. Start the database instance:
   SQL> startup
   
   

   Note

   Ensure that you restart the BMC TrueSight Infrastructure Management Server after you restart the Oracle database instance.

Oracle database backup and restore

BMC recommends that you back up the database regularly. Use any of the following utilities to create a backup of the database and restore the database when necessary:

• BMC Database Recovery Manager for Oracle
• RMAN
• Any other Oracle recommended backup and recovery utility

Assigning a user a permanent Oracle password that will never expire

1. Log in to the database server as the Oracle DBA Admin user.
2. Ensure ORACLE_HOME and ORACLE_SID are correctly defined for the Infrastructure Management Instance/service:
   $ ORACLE_HOME=<oracle_installation_location>; export ORACLE_HOME
$ ORACLE_SID=<tsim_instance/service_name>; export ORACLE_SID 
3. Connect to the Infrastructure Management database instance/service
   $ sqlplus / as sysdba
   • For Oracle RAC:
     sqlplus sys/ sys_pwd@ RAC_ORACLE_SERVICE_NAME as sysdba
   • For a single Oracle database instance:
     sqlplus sys/ sys_pwd@ ORACLE_SERVICE_NAME as sysdba
4. Create a user profile that has an unlimited password by entering the following command:
   CREATE PROFILE ProfileNameLIMIT PASSWORD_LIFE_TIME UNLIMITED FAILED_LOGIN_ATTEMPTS UNLIMITED
   For example: CREATE PROFILE TSIM_PROFILELIMIT PASSWORD_LIFE_TIME UNLIMITED FAILED_LOGIN_ATTEMPTS UNLIMITED
5. Enter ALTER USER userNamePROFILE ProfileName.
   For example: ALTER USER jkahariPROFILE TSIM_PROFILE
   To assign the report user an unlimited password, enter the following command:
   ALTER USER report PROFILE ProfileName.