Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Create an Oracle Database 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.

 145 views

More Questions for you: