CREATE DATABASE Manually ?

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: TNS:protocol 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

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

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

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

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,
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.

Quote:

---

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.

Quote:

---

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

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

Thanks

Quote:

---

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.

Ok...now i got the services started...then this is what i did..my pfile is copied from c:\oracle9i\ora92\admin\pfile\heatdb\initheatdb.ora to c:\oracle9i\ora92\database\heatdb.ora

*********************************************************
SQL> connect / as sysdba
Connected to an idle instance.
SQL>
SQL>
SQL>
SQL> startup nomount
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:\ORACLE9I\ORA92\DATABASE\INITCHEATDB.ORA'

**********************************************************

Why is it saying caouldnot open ?...any ideas...

Thanks a lot for all your help

It is poiting to different pfile, i.e to " 'C:\ORACLE9I\ORA92\DATABASE\INITCHEATDB.ORA'"
where as your pfile is "c:\oracle9i\ora92\database\heatdb.ora"

try

Code:

---

startup nomount pfile=c:\oracle9i\ora92\database\heatdb.ora

---

Thanks Sameer...Still having problems Creating DB...

**************************************************

SQL> startup nomount
ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
SQL> @c:\createdb.sql
CREATE DATABASE heatdb
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL>

***********************************

Any ideas...

thanks

This error can occur if the bdump destinations is incorrect or the database server does not have the correct permissions to write in that directory (alert.log file cannot be written)

regards