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

forgot couple things, add this database to your oratab and added it to your tnsnames.ora

Joan Hsieh wrote:
>
> 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).