-
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
Thanks
-
Use dbassist and save the creation scripts to a file instead of creating the database.
Jeff Hunter
-
Jeff,
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.
Thanks
-
Ashley,
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???
Tarry
Tarry Singh
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...
$more crdb9IDB.sql
spool crdb9IDB.lst
startup nomount pfile=/apps/oracle/admin/9IDB/pfile/init9IDB.ora
create database "9IDB"
maxlogfiles 16
maxdatafiles 1022
character set "US7ASCII"
datafile
'/****/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
logfile
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;
disconnect
spool off
for the parameters you can use old 8i file and modify to the requirement..
hope this help you.
Thanigaivasan
-
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...
undo_management=AUTO
undo_tablespace=undorbs
Thanks.
Thanigaivasan.
-
thanks so mcuh for your email
Do you have a copy of your parameter file( init)
thanks
-
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.
Thanks.
Thanigaivasan.
-
thanigai,
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 myoraclebackup@yahoo.com
thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|