| Manually creation of DB [message #62731] |
Wed, 11 August 2004 01:28  |
sailaja
Messages: 11
Registered: October 1999
|
Junior Member |
|
|
Dear All
Anybody can help me out to create manaullay db on 9i on Mircosoft platform.
Thanks & Best Regards
|
|
|
|
|
|
| Re: Manually creation of 9i DB on 2000 prof. [message #62734 is a reply to message #62733] |
Wed, 11 August 2004 02:08  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
Follow these steps
1)Create a structure using OMF( Oracle Managed Files)
2)Create the PFILE
3)Create a service (Oradim utility)
4)Create the Password File (orapwd utility)
5) Startup the instance in NOMOUNT stage
6) Run the create database script
7)Run the Scripts CATALOG.SQL,CATPROC.SQL,PUPBLD.SQL
You can get the sample files at $ORACLE_HOMEadminsample
Vivek
|
|
|
|
| Reply to vivek, regarding Manually creation of 9i DB on 2000 prof. [message #62735 is a reply to message #62734] |
Wed, 11 August 2004 02:29 |
sailaja
Messages: 11
Registered: October 1999
|
Junior Member |
|
|
Thank you very much vivek for ur assistance.
I run from 1 to 5 step properly,
Instance created properly.
I am facing problem after 5th step.
I use this command at SQL prompt:
startup nomount pfile='E:oracleadminpfileinit.ora'
I am getting error : controlfile cannot be create.
Please help me from this problem.
Thank you.
|
|
|
|
|
|
|
|
| Re: Reply to vivek, regarding Manually creation of 9i DB on 2000 prof. [message #62740 is a reply to message #62739] |
Wed, 11 August 2004 05:26 |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
This is a sample script.. u must have forgotten to give the logfile gp/members.. atleast 2 grps are required having minimum 1 member each..
Vivek
create database mydb
controlfile reuse
datafile 'D:oracleoradatamydbsystem01.dbf' size 100m
logfile group 1('D:oracleoradatamydbdisk1rloggp1f1.log','D:oracleoradatamydbdisk2rloggp1f2.log') size 1m,
group 2('D:oracleoradatamydbdisk1rloggp2f1.log','D:oracleoradatamydbdisk2rloggp2f2.log') size 1m
default temporary tablespace temp
tempfile 'D:oracleoradatamydbtemp.dbf' size 2m
UNDO TABLESPACE UNDOTBS DATAFILE 'D:oracleoradatamydbUNDO01.DBF' SIZE 20M
maxlogfiles 32
maxlogmembers 3
maxloghistory 1
maxinstances 1
maxdatafiles 254
Character set US7ASCII
National character set AL16UTF16;
|
|
|
|
| Re: Manually creation of 9i DB on 2000 prof. [message #62742 is a reply to message #62733] |
Wed, 11 August 2004 06:08 |
Diana
Messages: 17
Registered: February 1999
|
Junior Member |
|
|
hi ,
I have installed Oracle 9i Client in my machine.
I want to create a database manually on my machine.
I saw ur previous query,could u just explain me again how to do it and how to create a structure using OMF.
Thx,
Diana
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
