Configure the Database

Feature Data Objects API

 
Configure the Database
 
 
 

Run the utlrp.sqlscript.

  1. Switch user to oracle.
  2. Source the oraenvscript: . /usr/local/bin/oraenv. The script prompts for values for ORACLE_SID and ORACLE_HOME. The output looks like:
    ORACLE_SID = [oracle] ? r10103
    ORACLE_HOME = [/home/oracle] ? /app/oracle/product/10.1.0/Db_2
  3. $ sqlplus “/ AS SYSDBA”
  4. @?/rdbms/admin/utlrp.sql