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
