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).
- Open a Command Prompt and set the following variable:
Set ORACLE_SID=ISH
- Set ORACLE_HOME as follows:
set ORACLE_HOME=c:\oracle\product\12.1.0\dbhome_1