Configure the Database

Create a Database

Configuration

Create a Listener

 

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