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