Can someone send me an example of the parameter and the scripts of how to create the 9i database manually????
my email is MYORACLEBACKUP@YAHOO.COM
Use dbassist and save the creation scripts to a file instead of creating the database.
Thanks for your help as always,
this could be a silly question for you but I need some help. you mentioned on your post that save the create scripts instead of creating the database, where can you find the save create scripts??? I don't see that option, it only tell me to create the database and that's the only option.
It's funny because until 8i you could on the last step of customising the dbca either create a db or save info to a batch file!
So at the last step creating the db is your only option in 9i???
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be
Anyone had any other suggestions????
Hi Here is the sample script to create the db...
I created the db using this...
Note you have to run catalog and catproc after that..
also create the tools,users tablespaces...
startup nomount pfile=/apps/oracle/admin/9IDB/pfile/init9IDB.ora
create database "9IDB"
character set "US7ASCII"
'/****/system.dbf' size 400M
undo tablespace undorbs datafile
'/****/undo.dbf' size 516M
default temporary tablespace temp tempfile
'/****/temp.dbf' size 100m
extent management local uniform size 50k
group 1 ('/****/log_1a.log',
'/db/****/log_1b.log') size 10m,
group 2 ('/****/log_2a.log',
'/db/****/****/log_2b.log') size 10m,
group 3 ('/****/log_3a.log',
'/****/log_3b.log') size 10m;
for the parameters you can use old 8i file and modify to the requirement..
hope this help you.
Hi this is more important ....
You know 9i creates the rollback segments automatically..
for that you need to add the values as below in parameter file...for management...
thanks so mcuh for your email
Do you have a copy of your parameter file( init)
Use the 8i file...and required features as shown ..
my file has 3pages..made for portal configurations stuff like that....let us know if you have any issues.
could you please send me an email so I can ask you question.
I have problem with the create scripts you have sent, my email is firstname.lastname@example.org
Click Here to Expand Forum to Full Width