majid
<majidnakit@yaho An: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
o.com> Kopie:
Gesendet von: Thema: How to create a new oracle
database from SVRMGRL??
[EMAIL PROTECTED]
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
--- [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:
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).
