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 > > --- [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> > > > Sent by: [EMAIL PROTECTED] > > > 02/04/03 08:43 AM > > > Please respond to ORACLE-L > > > > > > > > > To: Multiple recipients of list ORACLE-L > > > <[EMAIL PROTECTED]> > > > 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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
