How To Create an Oracle Database Manually
Q
How To Create an Oracle Database Manually? - Oracle DBA FAQ - Creating New Database Instance Manually
✍: FYIcenter.com
A
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, 4436👍, 0💬
Related Topics: