There is no task related to ORADIM80. You simply reset your ORACLE_SID and
then create the database. To access it you just need to have entries in
your Listener and TNSNames.
-----Original Message-----
Sent: Wednesday, June 20, 2001 7:16 PM
To: Multiple recipients of list ORACLE-L
I'm trying to figure out how to create new instances on Red Hat
Linux. Can anyone tell me the Linux commands that correspond to the
following:
When I create a new instance under NT, I do this:
set ORACLE_SID=newsid
c:\ORANT\bin\oradim80 -new -sid newsid -intpwd newsid
-startmode auto -pfile f:\ORANTdb\newsid\init.ora
c:\ORANT\bin\oradim80 -startup -sid newsid -starttype
srvc,inst -usrpwd newsid -pfile f:\ORANTdb\newsid\init.ora
c:\ORANT\bin\svrmgr30 @f:\ORANTdb\newsid\run1.sql
c:\ORANT\bin\svrmgr30 @f:\ORANTdb\newsid\run2.sql
where run1.sql is:
spool c:\ORANT\database\spoolmain
set echo on
connect INTERNAL/newsid
startup nomount pfile=f:\ORANTdb\newsid\init.ora
CREATE DATABASE newsid
LOGFILE 'f:\ORANTdb\newsid\log1.ora' SIZE 1024K,
'f:\ORANTdb\newsid\log2.ora' SIZE 1024K
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'f:\ORANTdb\newsid\Sys1.ora' SIZE 50M
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1;
spool off
and run2.sql is:
spool c:\ORANT\database\spoolmain
set echo on
connect INTERNAL/newsid
ALTER DATABASE DATAFILE 'f:\ORANTdb\newsid\Sys1.ora' AUTOEXTEND ON;
CREATE ROLLBACK SEGMENT SYSROL TABLESPACE "SYSTEM" STORAGE
(INITIAL 100K NEXT 100K);
ALTER ROLLBACK SEGMENT "SYSROL" ONLINE;
@c:\ORANT\Rdbms80\admin\catalog.sql;
@c:\ORANT\Rdbms80\admin\catproc.sql
@c:\ORANT\Rdbms80\admin\caths.sql
spool off
Thanks,
Tim
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gardner
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
