RE: new instances on Linux different from NT?

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 <kgel_at_ppoone.com> 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: tgardner_at_codeHorse.com

> 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: 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.com
> --
> Author: Kevin Lange
> INET: kgel_at_ppoone.com

> 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: 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.com
--
Author: Rodd Holman
  INET: rodney.holman_at_lodgenet.com

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: 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).