Parameter file and scripts to create 9i database manually
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Parameter file and scripts to create 9i database manually

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Use dbassist and save the creation scripts to a file instead of creating the database.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2002
    Posts
    474
    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

  4. #4
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    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)
    TarryBlogging
    --- Everything was meant to be---

  5. #5
    Join Date
    Jan 2002
    Posts
    474
    Anyone had any other suggestions????


  6. #6
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    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

  7. #7
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    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.

  8. #8
    Join Date
    Jan 2002
    Posts
    474
    thanks so mcuh for your email

    Do you have a copy of your parameter file( init)

    thanks

  9. #9
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    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.

  10. #10
    Join Date
    Jan 2002
    Posts
    474
    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
  •  


Click Here to Expand Forum to Full Width