Web Development

General discussion


create oracle database manually

By Shanghai Sam ·
Dear all,

I have created oracle database through configuration assistant but I have got a problem creating oracle database manually.

First i create oracle service in dos prompt: oradim -new -sid prod1 -intpwd oracle
-startmode auto -pfile h:\disk1\initprod1.ora

and then set oracle_SID=PROD1

prepare pfile and then with script:

create database PROD1
logfile group 1 ('d:\disk2\logPROD1_1a.rdo','d:\disk2\logPROD1_1b.rdo' ) SIZE 10K,
group 2 ('d:\disk2\logPROD1_2a.rdo','d:\disk2\logPROD1_2b.rdo' ) SIZE 10K
datafile 'd:\disk1\sysprod1_1.ora' SIZE 10M
maxdatafiles 30
character set WE8ISO8859P1;

Afterward type following command is dos mode:
Sql>connect internally
password:*******startup nomount pfile=d:\disk1\initprod1.ora
There is an error afterwards!!!!

Is something is missing ???


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums