Documentation Center

Validating the Oracle database

The newly imported Oracle database needs some packages, triggers and more to be (re-)compiled for the database to be valid.

Before you begin

To perform this task, the ORACLE_SID and ORACLE_HOME environment variables must be set correctly (this is normally done during the ISOURCE user creation).

Procedure

  1. From a command shell in which where the ORACLE_SID and ORACLE_HOME environment variables are set correctly, enter the following from the command prompt:
    SQLPLUS /NOLOG
  2. Enter the commands to validate the database. Do not use a script file.
    CONNECT SYS/CHANGE_ON_INSTALL AS SYSDBA
    @?/rdbms/admin/utlrp;
    All objects in the database should be valid.