Professional Web Applications Themes

Create 9.2.0 database manually - Oracle Server

"Timmy Sin" <tswsin> wrote in message news:auh5c6$gd2$1news.hk.linkage.net... > Hi all, > > I want to have a very clean 9.2.0 database (without any unnecessary objects) > and choose to create it manually instead of using dbca. I've prepared the > following script to create the database. I would like to know if there is > any other administration scripts (apart from the three scripts shown) that I > have to run for the proper functioning of the database. Any comment on the > script is also welcomed. > ##################################### > CREATE DATABASE test > MAXINSTANCES 1 > MAXLOGHISTORY 1 > ...

  1. #1

    Default Re: Create 9.2.0 database manually


    "Timmy Sin" <tswsin> wrote in message
    news:auh5c6$gd2$1news.hk.linkage.net...
    > Hi all,
    >
    > I want to have a very clean 9.2.0 database (without any unnecessary
    objects)
    > and choose to create it manually instead of using dbca. I've prepared the
    > following script to create the database. I would like to know if there is
    > any other administration scripts (apart from the three scripts shown) that
    I
    > have to run for the proper functioning of the database. Any comment on the
    > script is also welcomed.
    > #####################################
    > CREATE DATABASE test
    > MAXINSTANCES 1
    > MAXLOGHISTORY 1
    > MAXLOGFILES 5
    > MAXLOGMEMBERS 5
    > MAXDATAFILES 100
    > CHARACTER SET UTF8
    > NATIONAL CHARACTER SET UTF8
    > LOGFILE GROUP 1 ('/database/oradata/test/dbfile/test_redo_11.rdo',
    > '/database/oradata/test/dbfile/test_redo_12.rdo') SIZE
    10M,
    > GROUP 2 ('/database/oradata/test/dbfile/test_redo_21.rdo',
    > '/database/oradata/test/dbfile/test_redo_22.rdo') SIZE
    10M,
    > GROUP 3 ('/database/oradata/test/dbfile/test_redo_31.rdo',
    > '/database/oradata/test/dbfile/test_redo_32.rdo') SIZE
    10M
    > DATAFILE '/database/oradata/test/dbfile/test_system_01.dbf'
    > SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M
    > DEFAULT TEMPORARY TABLESPACE temp
    > TEMPFILE '/database/oradata/test/dbfile/test_temp_01.dbf'
    > SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M
    > UNDO TABLESPACE undo
    > DATAFILE '/database/oradata/test/dbfile/test_undo_01.dbf'
    > SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M;
    > CREATE TABLESPACE user DATAFILE
    > '/database/oradata/test/dbfile/test_user_01.dbf'
    > SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M;
    > /app/oracle/product/9.2.0/rdbms/admin/catalog.sql
    > /app/oracle/product/9.2.0/rdbms/admin/catproc.sql
    > connect system/manager
    > /app/oracle/product/9.2.0/sqlplus/admin/pupbld.sql
    > exit;
    > ########################################
    >
    > Thank you very much for your comment.
    >
    > Regards,
    > Timmy
    >
    I doubt that you can use UNIFORM allocation for UNDO tablespaces. I checked
    this in 9.0.1 and it gave me an error. Can somebody clarify that this is
    still the same in 9.2?

    TIA
    santosh




    santosh Guest

  2. #2

    Default Re: Create 9.2.0 database manually

    Thanks for your input. I would change the script accordingly. BTW, how about
    the other scripts apart from catalog, catproc and pupbld?

    Thanks.

    Timmy
    "Paul Brewer" <paulpaul.brewers.org.uk> 撰寫於郵件新聞
    :3e0f32c9$1_1mk-nntp-1.news.uk.worldonline.com...
    > "santosh" <santyspam> wrote in message
    > news:aui3vj$7f38d$1ID-84096.news.dfncis.de...
    > >
    > > "Timmy Sin" <tswsin> wrote in message
    > > news:auh5c6$gd2$1news.hk.linkage.net...
    > > > Hi all,
    > > >
    > > > I want to have a very clean 9.2.0 database (without any unnecessary
    > > objects)
    > > > and choose to create it manually instead of using dbca. I've prepared
    > the
    > > > following script to create the database. I would like to know if there
    > is
    > > > any other administration scripts (apart from the three scripts shown)
    > that
    > > I
    > > > have to run for the proper functioning of the database. Any comment on
    > the
    > > > script is also welcomed.
    > > > #####################################
    > > > CREATE DATABASE test
    > > > MAXINSTANCES 1
    > > > MAXLOGHISTORY 1
    > > > MAXLOGFILES 5
    > > > MAXLOGMEMBERS 5
    > > > MAXDATAFILES 100
    > > > CHARACTER SET UTF8
    > > > NATIONAL CHARACTER SET UTF8
    > > > LOGFILE GROUP 1 ('/database/oradata/test/dbfile/test_redo_11.rdo',
    > > > '/database/oradata/test/dbfile/test_redo_12.rdo')
    SIZE
    > > 10M,
    > > > GROUP 2
    > ('/database/oradata/test/dbfile/test_redo_21.rdo',
    > > > '/database/oradata/test/dbfile/test_redo_22.rdo')
    SIZE
    > > 10M,
    > > > GROUP 3
    > ('/database/oradata/test/dbfile/test_redo_31.rdo',
    > > > '/database/oradata/test/dbfile/test_redo_32.rdo')
    SIZE
    > > 10M
    > > > DATAFILE '/database/oradata/test/dbfile/test_system_01.dbf'
    > > > SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M
    > > > DEFAULT TEMPORARY TABLESPACE temp
    > > > TEMPFILE '/database/oradata/test/dbfile/test_temp_01.dbf'
    > > > SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M
    > > > UNDO TABLESPACE undo
    > > > DATAFILE '/database/oradata/test/dbfile/test_undo_01.dbf'
    > > > SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M;
    > > > CREATE TABLESPACE user DATAFILE
    > > > '/database/oradata/test/dbfile/test_user_01.dbf'
    > > > SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M;
    > > > /app/oracle/product/9.2.0/rdbms/admin/catalog.sql
    > > > /app/oracle/product/9.2.0/rdbms/admin/catproc.sql
    > > > connect system/manager
    > > > /app/oracle/product/9.2.0/sqlplus/admin/pupbld.sql
    > > > exit;
    > > > ########################################
    > > >
    > > > Thank you very much for your comment.
    > > >
    > > > Regards,
    > > > Timmy
    > > >
    > > I doubt that you can use UNIFORM allocation for UNDO tablespaces. I
    > checked
    > > this in 9.0.1 and it gave me an error. Can somebody clarify that this is
    > > still the same in 9.2?
    > >
    > > TIA
    > > santosh
    > >
    > >
    > >
    > >
    > It seems so, but I rather think this is a syntax question, rather than
    size
    > of extents. For undo, in any version, I'd be surprised if the extent sizes
    > were other than uniform :-)
    >
    > Out of interest, I tried out the above script (changing paths etc. as
    > appropriate) in 9.2.0.1 on Windows XP.
    >
    > In the init.ora (copying Oracle's example) I put:
    >
    > undo_management=AUTO
    > undo_retention=10800
    > undo_tablespace=UNDO
    >
    > In the create database I then had to put:
    > ...
    > UNDO TABLESPACE undo
    > DATAFILE 'G:\Oracle\oradata\test\test_undo_01.dbf'
    > SIZE 200M;
    >
    > in order to make it work.
    >
    > BTW (to OP) I notice that both members of each logfile
    > group are mounted on the same node....
    > Also, as well as changing passwords for SYS and SYSTEM, I'd suggest
    locking
    > the OUTLN and DBSNMP accounts.
    > Regards,
    > Paul
    >
    >
    >

    Timmy Sin Guest

  3. #3

    Default Re: Create 9.2.0 database manually

    "Timmy Sin" <tswsin> wrote in message news:<av0435$13v$1news.hk.linkage.net>...
    > I mean the sql scripts under ~/app/oracle/product/9.2.0/rdbms/admin. Do I
    > need to run other additional scripts for the proper functioning of my
    > database. I will not use any Java and XML features.
    Yes, you will probably want to run some of these scripts. It depends
    on your application and environment, but for example running
    utlxplan.sql for selected users (script creates explain table), or
    statscre.sql (creates PERFSTAT schema for statspack), would be
    necessary for even testing database.
    However, for basic functionality of database you can live only with
    script mentioned in previous post.

    --
    _________________________________________

    Dusan Bolek, Ing.
    Oracle team leader

    Note: [email]pagesflamesusa.net[/email] has been cancelled due to changes (maybe we
    can call it an overture to bankruptcy) on that server. I'm still using
    this email to prevent SPAM. Maybe one day I will change it and have a
    proper mail even for news, but right now I can be reached by this
    email.
    Dusan Bolek Guest

  4. #4

    Default Re: Create 9.2.0 database manually

    Hi Dusan,

    Thanks for your information. In 9.0.1, I do find the scripts creation
    feature (*.sh and *.sql) in DBCA. However, it seems that the feature has
    been replaced by the seed and non-seed templates (*.dbc and *.dbt) in 9.2.0.

    Regards,
    Timmy

    "Dusan Bolek" <pagesflamesusa.net>
    ???????:1e8276d6.0301020125.53602820posting.googl e.com...
    > "Timmy Sin" <tswsin> wrote in message
    news:<auqs7a$1l2$1news.hk.linkage.net>...
    > > Thanks for your information. However, it seems that the mentioned
    feature
    > > would no longer available since 9.2.0.
    >
    > > > The easy way to do this is to run dbca, specify all parameters and
    > > > then let dbca create the database creation scripts without actually
    > > > creating the database. There will be 1 .sh and 4 to 5 .sql scripts.
    > > > You can edit the creation scripts, if you want to, before running the
    > > > .sh file. This way you will let dbca cross all the t's and dot all the
    > > > i's for you.
    >
    > You can even in 9.2 use dbca to create your scripts for you. However,
    > it seems to me that dbca in 9.2 is extremely stupid while creating
    > these scripts, so I do not recommend this way anymore, because it
    > takes a lot of editing work to correct generated scripts. For
    > experienced DB creator is quicker to write these scripts manually. Of
    > course, the best way is to use saved scripts from previous DB
    > creation. However, I usually can't find these, when it is necessary.
    > :-
    >
    > --
    > _________________________________________
    >
    > Dusan Bolek, Ing.
    > Oracle team leader
    >
    > Note: [email]pagesflamesusa.net[/email] has been cancelled due to changes (maybe we
    > can call it an overture to bankruptcy) on that server. I'm still using
    > this email to prevent SPAM. Maybe one day I will change it and have a
    > proper mail even for news, but right now I can be reached by this
    > email.

    Timmy Sin Guest

  5. #5

    Default Re: Create 9.2.0 database manually

    "Timmy Sin" <tswsin> wrote in message news:<avao12$9hr$1news.hk.linkage.net>...
    > Hi Dusan,
    >
    > Thanks for your information. In 9.0.1, I do find the scripts creation
    > feature (*.sh and *.sql) in DBCA. However, it seems that the feature has
    > been replaced by the seed and non-seed templates (*.dbc and *.dbt) in 9.2.0.
    No, it was not replaced, creation of templates is a new feature from
    8.1.7 (IIRC, maybe 8.1.6), but DB create scripts are still an option.
    It is not default any more, you need to check this one on one of the
    last pages in DBCA.

    --
    _________________________________________

    Dusan Bolek, Ing.
    Oracle team leader

    Note: [email]pagesflamesusa.net[/email] has been cancelled due to changes (maybe we
    can call it an overture to bankruptcy) on that server. I'm still using
    this email to prevent SPAM. Maybe one day I will change it and have a
    proper mail even for news, but right now I can be reached by this
    email.
    Dusan Bolek Guest

Similar Threads

  1. Question create database dynamically
    By saidujjama in forum Brainstorming Area
    Replies: 0
    Last Post: May 11th, 10:26 AM
  2. Create Database
    By lh83 in forum Coldfusion Database Access
    Replies: 0
    Last Post: February 8th, 08:15 AM
  3. Create Database Connection
    By backpages in forum Macromedia Dynamic HTML
    Replies: 1
    Last Post: December 23rd, 06:45 PM
  4. Create a TIMER for a database
    By Jonathan in forum FileMaker
    Replies: 3
    Last Post: October 28th, 07:10 PM
  5. Create a Report from a Database
    By cavagnaro in forum Macromedia Dreamweaver
    Replies: 1
    Last Post: July 10th, 12:12 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139