Quote Originally Posted by skbn136
Hi Oracle Professionals,

Hope you could clarify my basic doubt about creating database manually.

I have a test oracle database server with a sample database. My objective is to create a new database manually. My questions are:

1. Each database is handeled by a new instance. How I can create a new instance for this new database before I execute my script for creation of database

Thanks in advance

skbn
Step 1: Decide on Your Instance's System Identifier (SID)
Step 2: Create the Initialization Parameter File
Step 3: Connect to and Start the Instance
Step 4: Issue the CREATE DATABASE Statement
Step 5: Run Scripts to Build Data Dictionary Views
Step 6: Run Scripts to Install Additional Options
Step 7: Create a Server Parameter File
Step 8: Back Up the Database
Step 9: Create Additional Tablespaces