Validating the 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

You first need to make sure that ORACLE_SID and ORACLE_HOME variables are set correctly (this is normally done during the ISOURCE user creation).

  1. Open a Command Prompt and set the following variable:

    Set ORACLE_SID=ISH

  2. Set ORACLE_HOME as follows:
    set ORACLE_HOME=c:\oracle\product\12.1.0\dbhome_1

Procedure

  1. Start SQLPLUS /NOLOG from a shell where the ORACLE_SID and ORACLE_HOME variables are set correctly. At the command prompt, type:
    SQLPLUS /NOLOG
  2. Enter the following statements 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.