Also need an entry in the /etc/oratab file for the new SID.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 6/20/01, 8:10:19 PM, Kevin Lange <[EMAIL PROTECTED]> wrote regarding RE:
new instances on Linux different from NT?:
> 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodd Holman
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).
