Oracle Database Interview Question:

How To Create an Oracle Database Manually?

Submitted by: Administrator

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.
Submitted by: Administrator