Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> new instances on Linux different from NT?
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).Received on Wed Jun 20 2001 - 18:11:34 CDT