I want to create database manually on oracle 9i.can anyone help me
hi ,
step of manully database
1- in cdrive create a folder (any name xyz)
2- in that xyz folder make 6 folder
pfile,control,data,redo,bdump,udump
3-goto notpad
create pfile all parameter & save as "initxyz.ora" as all file
if u done no the parameter of pfile plz let me so i can send u.
4-go to cmd promet
set oracle_sid=xyz
oradim -new -sid xyz
sqlplus/nolog
conn as sysdba
(connet to idle instances)
startup nomount pfile='c:/xyz/pfile/initxyz.ora'
create database ( write all parameter)
then run scripts 1-catalog.sql 2- catproc.sql
know databnase is open fro work.
plz let me know reply asap
from
sona