Basic Oracle Concepts and Programming Question:
How To Create an Oracle Database Manually?
Answer:
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.
► 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.
| Previous Question | Next Question |
| How To Create an Oracle Database? | How To Select an Oracle System ID (SID)? |