CREATE DATABASE Manually ?

[vr76413]

Hello all..

Iam trying to create DB Manually instead of DBCA. this is what i have done...

Win2K and Oracle9.2

1) set ORACLE_SID=heatdb

2) created initheatdb.ora file , included all relevent info like db_block_size....etc. and saved that file in
c:\oracle9i\ora92\admin\heatdb\pfile

3)Created a sql script that includes info about CREATE Database Script

***********************************just a sample*********
CREATE DATABASE heatdb
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
DATAFILE 'c:/oracle9i\ora92\oradata\heatdb\system01.dbf' SIZE 325M REUSE
************************************* just a sample ********

4) then i went to DOS prompt....and issued the following Command
*****************************************************
C:\>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Jan 7 16:37:44 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect / as sysdba
ERROR:ORA-12560: TNSrotocol adapter error

SQL>
*******************************************************


So my questios are
1) how can i create a Database manually, by running the script which i created in STEP 3. Its not conencting me into the database
2) Am i doing the right Way ?..
3) is there any alternate way we can create DB manually ?


Thanks for all your help

Ron

[jmodic]

Before anything else, you have to create (and start) Oracle database service if you are in Windows enviroment. Check the ORADIM utility in manuals...

[marist89]

http://www.akadia.com/services/solar..._sol920.tar.gz

[marist89]

Sorry, didn't see you were on Windoz. In that case, http://www.akadia.com/services/ora_w2k_install_9i.html

[davey23uk]

what is sometimes useful is running dbca thwn saving the create scripts instead of running them, then you can see what needs to be done to start a full database on your platform

[rotem_fo]

Hi,
you need to use ORADIM utility to create a service for your instance:
oradim -new -sid heatdb -pfile c:\oracle9i\ora92\admin\heatdb\pfile\initheatdb.ora -startmode a

set ORACLE_SID=heatdb
sqlplus /nolog


now create the database.

Cheers.

[abhaysk]

Originally posted by jmodic
Before anything else, you have to create (and start) Oracle database service if you are in Windows enviroment. Check the ORADIM utility in manuals...

Just to add the quote...

After u create a service, if u have existing database running ,
then u need to set ENIVRONMENTAL VARILABLES to created SID...
Or Configure Listener,TNS names & give connect string to connect to the IDLE Instance created.

Abhay.

[Orca777]

Originally posted by davey23uk
what is sometimes useful is running dbca thwn saving the create scripts instead of running them, then you can see what needs to be done to start a full database on your platform

Hi, that's the way !
i always do it in this manner
after getting the complete scripts, you can modify them
and start the creating of the db.
Orca

[vr76413]

how do we save the script in DBCA utility ?.....

Thanks

[abhaysk]

Originally posted by vr76413
how do we save the script in DBCA utility ?.....

Thanks

Due last step of using DBCA u have 2 options

1)Check box for create database.
2)Check box for save as scripts.

check opt 2 and finish.

Abhay.