| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Antwort: How to create a new oracle database from SVRMGRL??
majid
<majidnakit_at_yaho An: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
o.com> Kopie:
Gesendet von: Thema: How to create a new oracle database from SVRMGRL??
root_at_fatcity.com
04.02.2003 16:50
Bitte antworten
an ORACLE-L
>1)how can I create a new database frm SVRMGRL ?
pathes have to exist with the right owner and permissions
as well as init.ora.
If you use dbassist you can create all the scripts.
#!/bin/ksh
ORACLE_SID=yourdb
export ORACLE_SID
/oracle/8.1.6/bin/svrmgrl << EOF
spool /oracle/8.1.6/admin/yourdb/create/crdb1.log
connect internal
startup nomount pfile = "/oracle/8.1.6/admin/yourdb/pfile/inityourdb.ora"
CREATE DATABASE "yourdb"
maxdatafiles 128
maxinstances 8
maxlogfiles 32
character set US7ASCII
national character set US7ASCII
DATAFILE '/oracle/8.1.6/oradata/yourdb/system01.dbf' SIZE 54M AUTOEXTEND ON
NEXT 640K
logfile '/oracle/8.1.6/oradata/yourdb/redo01.log' SIZE 1000K,
'/oracle/8.1.6/oradata/yourdb/redo02.log' SIZE 1000K,
'/oracle/8.1.6/oradata/yourdb/redo03.log' SIZE 1000K;
disconnect
spool off
exit
EOF
>2)can I have more than one database running in
>oracle8i?
jep
>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
>
-- 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: INET: Alex.Apostolopoulos_at_secartis.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).Received on Tue Feb 04 2003 - 11:14:24 CST
 |
 |