Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to create a new oracle database from SVRMGRL??

Re: How to create a new oracle database from SVRMGRL??

From: Joan Hsieh <joan.hsieh_at_tufts.edu>
Date: Wed, 05 Feb 2003 06:53:10 -0800
Message-ID: <F001.005443E2.20030205065310@fatcity.com>


Majid,

  1. Create ini.ora, link this ini.ora to your oracle_home/dbs
  2. startup nomount pfile=$ORACLE_HOME/dbs/initestdb.ora

create database TESTDB

    maxdatafiles 1021
    maxinstances 1
    maxlogfiles 8
    maxlogmembers 4
    character set WE8ISO8859P15
    datafile

        '/testdb/system01.dbf' size 400M     logfile

        '/redo1/testdb/log01.dbf'         size 20M,
        '/redo1/testdb/log02.dbf'         size 20M,
        '/redo1/testdb/log03.dbf'         size 20M;

3. run
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql

4. Create rollback tablespace 
5. Create your rollback segment
6. Create all your tablespaces
7. enjoy

Joan

majid wrote:
>
> 1)how can I create a new database frm SVRMGRL ?
>
> 2)can I have more than one database running in
> oracle8i?
>
> thanks
> --- JayK_at_ibsplc.com wrote:
> > You can use DBCA(Database Config Assistant) to
> > create a new Oracle DB or
> > issue the
> > commands starting from Create database ..... from
> > SVRMGRL.
> >
> >
> >
> >
> >
> > majid <majidnakit_at_yahoo.com>
> > Sent by: root_at_fatcity.com
> > 02/04/03 08:43 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > cc:
> > Subject: How to create a new oracle
> > database ????
> >
> >
> > Hi, I am new to oracle, I just installed oracle8i in
> > windows2000, durring the installation I called the
> > default database "test", I wrote a small java class
> > using the JDBC, everything is working fine, my
> > question please :
> >
> > 1)can I create another database in oracle (leave the
> > database "test")so I will have two databases in
> > oracle
> > ?
> >
> > 2)How can I create a database ?
> >
> > Thanks, your help is appreciated.
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up
> > now.
> > http://mailplus.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: majid
> > INET: majidnakit_at_yahoo.com
> >
> > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> > hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
> >
> >
> >
> >
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: majid
> INET: majidnakit_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: joan.hsieh_at_tufts.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Feb 05 2003 - 08:53:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US