Mar 5, 2011

Create schemas using RCU 11g

  1.  Install Oracle DB, either XE or Standard.
  2. Make sure sessions parameter is set to at least 500 and processes parameter is set to at least 200. Use following commands to make this sure.
    clip_image001
  3. Restart database.
  4. Run rcu.bat from rcuHome\BIN folder of the extracted rcu distribution. Follow the wizard to setup required schemas.
    clip_image002
    clip_image003
  5. Click ignore when following warning message appears
    clip_image004
  6. Choose appropriate prefix for schemas and select desired component for which schema needs to be created
    clip_image005
  7. Create common/different password for schemas.
    clip_image006
  8. After some more steps Summary screen will appear. Click "Create" to start the create process.
    clip_image007
  9. Finally confirmation screen will appear to let you know if the create went through successfully or failed. clip_image008
  10. Check all the schemas by logging in them using SQL plus.

No comments: