General discussion

Locked

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:
sqlplus/nolog
Sql>connect internally
password:*******startup nomount pfile=d:\disk1\initprod1.ora
There is an error afterwards!!!!

Is something is missing ???

Thanks

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Web Development Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums