Creating Database Manually

Printable View

08-09-2006, 09:11 PM
skbn136

Creating Database Manually

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
08-09-2006, 09:12 PM
slimdave

What's your version? It got a lot more simple in 10g, I believe.
08-10-2006, 08:55 AM
davey23uk

i also believe he getting mixed up in terms of instance and database - in oracle a database = an instance (in its simplest terms)
08-10-2006, 10:24 AM
graham_o

Davey, I can't believe you just said that, you know better than that.

try this link... http://download-uk.oracle.com/docs/c...t.htm#CNCPT005
08-10-2006, 10:28 AM
Thomasps

Quote:

Originally Posted by graham_o

Davey, I can't believe you just said that, you know better than that.

He said it in "simplest terms"
08-10-2006, 10:31 AM
graham_o

Just winding him up Thomas, disappointed he didn't bite though. :)
08-10-2006, 10:34 AM
davey23uk

graham, try reading this - more suited at your level I believe

http://www.amazon.com/gp/product/076...lance&n=283155

please come back when you wanna play with the big boys
08-10-2006, 10:38 AM
graham_o

Nice one Dave, I knew you wouldn't be able to resist it. Isn't that the book we got you for your leaving do?
08-10-2006, 10:43 AM
davey23uk

nah you got me a kite, a christina calendar and some joke golf balls :-)
08-11-2006, 03:35 AM
reydp

sometimes, it's better to ask questions here humbly like "Patrick the star" does with Squidward. :)
05-16-2007, 08:55 AM
thomking

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