Create DB using 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
***********************************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

 

[Turkbear]

What database do you expect it to connect to, the one it is trying to create? ( nice trick)

Look into the docs of the ORADIM command.

 

[vr76413]

thanks Turkbear..

Yes...iam tryng to connect to the database which iam trying to create ....am i wrong ?.....please et me know what i need to do ?..

Thanks
Ron

 

[Turkbear]

How can you connect to something that does not exist?

As I noted,please read the docs for using the ORADIM.EXE command to pre-create the instance - then connect to that instance as sysdba and run the script.

 

[ngibbs]

Have you started a listener. If not then you need one. lsnrctl status will tell you if you have a default listener started and lsnrctl start will start a default listener.

I'm assuming that you have set instance name and service names parameters in your parameter file so that dynamic service registration can work.

Hope this helps