How To Create an Oracle Database Manually


How To Create an Oracle Database Manually? - Oracle DBA FAQ - Creating New Database Instance Manually



Based on Oracle's Administrator Guide, there are 11 steps to create a database with the CREATE DATABASE statement:

  • Step 1: Decide on Your Instance Identifier (SID)
  • Step 2: Establish the Database Administrator Authentication Method
  • Step 3: Create the Initialization Parameter File
  • Step 4: Connect to the Instance
  • Step 5: Create a Server Parameter File (Recommended)
  • Step 6: Start the Instance
  • Step 7: Issue the CREATE DATABASE Statement
  • Step 8: Create Additional Tablespaces
  • Step 9: Run Scripts to Build Data Dictionary Views
  • Step 10: Run Scripts to Install Additional Options (Optional)
  • Step 11: Back Up the Database.

Other items in this FAQ collection will follow those steps to help you creating a new database manually from beginning to end.

2007-04-22, 4638👍, 0💬