while running catproc.sql

Dear Seniors,

Right now am Creating an Database Manually.
i created and for the compleation i run these following files
catalog.sql
&
catproc.sql

while running the CATPROC.SQL
.
.
.
ERROR:
ORA-03114: not connected to ORACLE

ERROR:
ORA-03114: not connected to ORACLE

ERROR:
ORA-03114: not connected to ORACLE

ERROR:
ORA-03114: not connected to ORACLE

Enter value for wpi_file_var:

i dont know what i have to enter ,, ?????

Please help me,,
and let me know is my database is created well,, is there any problem for this here after..:confused:

you did it wrong - your database is broken - start again

What it means,, i ran it very clearly

create database natur
logfile group 1 'D:/oracle/product/10.2.0/oradata/natur/redo1.log' size 10m,
group 2 'D:/oracle/product/10.2.0/oradata/natur/redo2.log' size 10m,
group 3 'D:/oracle/product/10.2.0/oradata/natur/redo3.log' size 10m
datafile 'D:/oracle/product/10.2.0/oradata/natur/system.dbf' size 20m autoextend on
next 2m maxsize 30m
sysaux datafile 'D:/oracle/product/10.2.0/oradata/natur/sysaux.dbf' size 10m autoextend on
next 1m maxsize 20m
undo tablespace UNDOTBS1 datafile 'D:/oracle/product/10.2.0/oradata/natur/undo.dbf' size 10m
default temporary tablespace temp tempfile 'D:/oracle/product/10.2.0/oradata/natur/temp.dbf' size 10m


This creation commands did well after this i ran

D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN/catalog.sql
this also ran well,
then i ran this catprog
D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN/catproc.sql

here comes the problem,, its not a problem it may be a file missing,,
please help me,,i want to run this database,,, its a must one

you lost connection, thats why you have the no connection error

start again and use dbca

Thank u very much,,

Can u please post how to create a database in manual,, please tell me in ur own way..

(if u free just post it)

Quote:

---

Originally Posted by honeyonair

Dear Seniors,

Right now am Creating an Database Manually.
i created and for the compleation i run these following files
catalog.sql
&
catproc.sql

while running the CATPROC.SQL
.
.
.
ERROR:
ORA-03114: not connected to ORACLE

ERROR:
ORA-03114: not connected to ORACLE

ERROR:
ORA-03114: not connected to ORACLE

ERROR:
ORA-03114: not connected to ORACLE

Enter value for wpi_file_var:

i dont know what i have to enter ,, ?????

Please help me,,
and let me know is my database is created well,, is there any problem for this here after..:confused:

---

Enter value for wpi_file_var: eee
SP2-0310: unable to open file "D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN/eee.sql"

this is what happened when i enter ee

look, its obvious you have no idea what you are doing

use dbca to create you database

Now its running fine:D

u are correct, its connection was broken,, now i stared again and running well,,

thank u for u a kind polite reply:)