RE: new instances on Linux different from NT?

From: Kevin Lange <kgel_at_ppoone.com>
Date: Wed, 20 Jun 2001 17:25:04 -0700
Message-ID: <F001.00331033.20010620171019@fatcity.com>

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