Friday 14 June 2013

Linux How-to Create a Database for Oracle 11g R2 Easy Visual-Guide

The Guide Show Visually How-to Create a Database on Oracle 11g R2 by the Database Configuration Assistant.

And the Screenshots of the Steps Involved are included here to shows you Visually How to Make an Oracle 11g DB.

How-to Create a Database Oracle 11g R2 1
  1. Before to Create a Database You Need to Create a Listener

    How-to Create and Run a Listener on Oracle 11g Database:

    Create and Run a Listener for Oracle 11g
  2. Open a Terminal Window
  3. Login as oracle User
    su oracle
  4. Starting the Database Configuration Assistant
    cd $ORACLE_HOME/bin
    ./dbca
    Can't Open Display + No Protocol Specified Troubleshootings
  5. Click on Next
    How-to Create a Database Oracle 11g R2 2
  6. Click on Next
    How-to Create a Database Oracle 11g R2 3
  7. Click on Next
    How-to Create a Database Oracle 11g R2 4
  8. Insert the Database Name and the SID then Click on Next

    Here is the Link 2 How-to Correctly Set Oracle SID

    SID for Oracle 11g
  9. Click on Next
    How-to Create a Database Oracle 11g R2 6
  10. Select "Use the Same Administrative Password", Insert Pass and Click on Next
    How-to Create a Database Oracle 11g R2 7
  11. Click on Next
    How-to Create a Database Oracle 11g R2 8
  12. Click on Next
    How-to Create a Database Oracle 11g R2 9
  13. Click on Next
    How-to Create a Database Oracle 11g R2 10
  14. Select the "Character Sets" Tab, Select "Use Unicode" and Click on Next
    How-to Create a Database Oracle 11g R2 11
  15. Click on Next
    How-to Create a Database Oracle 11g R2 12
  16. Click on Finish to Start the Creating Database Process
    How-to Create a Database Oracle 11g R2 13
  17. Save a Copy of Create Database Summary by "Save as an HTML file"
    How-to Create a Database Oracle 11g R2 14
  18. After the Database is Created
    How-to Create a Database Oracle 11g R2 15a Take Note of Database Essential Parameters
    How-to Create a Database Oracle 11g R2 15b
  19. How-to Getting-Started Managing by SQLPlus 11g R2 Database:

    Getting-Started on Oracle 11g Database