Re: Multiple Instances on Same Database.

From: Bob Schmitz <bschmitz_at_execpc.com>
Date: Fri, 2 Mar 2001 11:55:42 -0600
Message-ID: <w7Rn6.3720$7e6.1470238@homer.alpha.net>

Yes you can create multiple instances on the same host machine. However, to run effectivly, you need to make sure that you have enough resources,i.e., memory disk, etc. I am providing a script you can use to create the repository database used for Oracle's Designer tools:

set termout on
set echo on
spool /home/oracle/dba/config/create_dba.log; connect internal
startup nomount pfile=/u01/app/oracle/admin/dba/pfile/initdba.ora

create database "dba"
controlfile reuse

logfile group 1  ('/u11/oradata/dba/redolog_01a.dbf',
                  '/u12/oradata/dba/redolog_01b.dbf') size 5M,
        group 2  ('/u11/oradata/dba/redolog_02a.dbf',
                  '/u12/oradata/dba/redolog_02b.dbf') size 5M,
        group 3  ('/u11/oradata/dba/redolog_03a.dbf',
                  '/u12/oradata/dba/redolog_03b.dbf') size 5M,
        group 4  ('/u11/oradata/dba/redolog_04a.dbf',
                  '/u12/oradata/dba/redolog_04b.dbf') size 5M
maxlogfiles     32

maxlogmembers 2
datafile '/u11/oradata/dba/system_01.dbf' size 275M maxdatafiles 255
maxinstances 1
noarchivelog
character set US7ASCII
national character set US7ASCII
@/u01/app/oracle/product/8.1.7/rdbms/admin/catalog.sql

ALTER TABLESPACE SYSTEM
DEFAULT STORAGE ( INITIAL 1024K NEXT 1024K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0);
ALTER TABLESPACE SYSTEM
MINIMUM EXTENT 0K; CREATE TABLESPACE RBS
DATAFILE '/u11/oradata/dba/rbs01.dbf' SIZE 50M

DEFAULT STORAGE (INITIAL        1M
                 NEXT           1M
                 MINEXTENTS     2
                 MAXEXTENTS     50
                 PCTINCREASE    0)

ONLINE;

CREATE PUBLIC ROLLBACK SEGMENT R01 TABLESPACE RBS STORAGE ( OPTIMAL 2M );
CREATE PUBLIC ROLLBACK SEGMENT R02 TABLESPACE RBS STORAGE ( OPTIMAL 2M );
CREATE PUBLIC ROLLBACK SEGMENT R03 TABLESPACE RBS STORAGE ( OPTIMAL 2M );
CREATE PUBLIC ROLLBACK SEGMENT R04 TABLESPACE RBS STORAGE ( OPTIMAL 2M );

ALTER ROLLBACK SEGMENT R01 ONLINE;
ALTER ROLLBACK SEGMENT R02 ONLINE;

ALTER ROLLBACK SEGMENT R03 ONLINE;
ALTER ROLLBACK SEGMENT R04 ONLINE; create tablespace temp

        datafile '/u11/oradata/dba/temp01.dbf'
        size 50M
        default storage (initial 512K next 512K minextents 1 maxextents 100

pctincrease 0);

create tablespace users

        datafile '/u11/oradata/dba/users01.dbf'
        size 10M
        default storage (initial 512K next 512K minextents 1 maxextents 20

pctincrease 0);

create tablespace tools

        datafile '/u11/oradata/dba/tools01.dbf'
        size 10M
        default storage (initial 512K next 512K minextents 1 maxextents 20

pctincrease 0);

create tablespace constant_grow_indexes

        datafile '/u12/oradata/dba/constant_grow_indexes01.dbf'
        size 5M
        default storage (initial 100K next 100K minextents 1 maxextents 50

pctincrease 0);

create tablespace constant_grow_tables

        datafile '/u12/oradata/dba/constant_grow_tables01.dbf'
        size 10M
        default storage (initial 100K next 100K minextents 1 maxextents 100

pctincrease 0);

create tablespace dependency_indexes

        datafile '/u13/oradata/dba/dependency_indexes01.dbf'
        size 5M
        default storage (initial 100K next 100K minextents 1 maxextents 50

pctincrease 0);

create tablespace dependency_tables

        datafile '/u13/oradata/dba/dependency_tables01.dbf'
        size 5M
        default storage (initial 100K next 100K minextents 1 maxextents 50

pctincrease 0);

create tablespace diagram_indexes

        datafile '/u14/oradata/dba/diagram_indexes01.dbf'
        size 5M
        default storage (initial 100K next 100K minextents 1 maxextents 50

pctincrease 0);

create tablespace diagram_tables

        datafile '/u14/oradata/dba/diagram_tables01.dbf'
        size 10M
        default storage (initial 100K next 100K minextents 1 maxextents 50

pctincrease 0);

create tablespace lob_data

        datafile '/u15/oradata/dba/lob_data01.dbf'
        size 5M
        default storage (initial 100K next 100K minextents 1 maxextents 50

pctincrease 0);

create tablespace rapid_grow_indexes

        datafile '/u12/oradata/dba/rapid_grow_indexes01.dbf'
        size 32M
        default storage (initial 100K next 100K minextents 1 maxextents 327

pctincrease 0);

create tablespace rapid_grow_tables

        datafile '/u13/oradata/dba/rapid_grow_tables01.dbf'
        size 32M
        default storage (initial 100K next 100K minextents 1 maxextents 327

pctincrease 0);

create tablespace system_meta_indexes

        datafile '/u14/oradata/dba/system_meta_indexes01.dbf'
        size 24M
        default storage (initial 100K next 100K minextents 1 maxextents 245

pctincrease 0);

create tablespace system_meta_tables

        datafile '/u15/oradata/dba/system_meta_tables01.dbf'
        size 24M
        default storage (initial 100K next 100K minextents 1 maxextents 245

pctincrease 0);

create tablespace temporary_indexes

        datafile '/u14/oradata/dba/temporary_indexes01.dbf'
        size 10M
        default storage (initial 512K next 512K minextents 1 maxextents 20

pctincrease 0);

create tablespace temporary_tables

        datafile '/u15/oradata/dba/temporary_tables01.dbf'
        size 10M
        default storage (initial 512K next 512K minextents 1 maxextents 20

pctincrease 0);

create tablespace version_indexes

        datafile '/u14/oradata/dba/version_indexes01.dbf'
        size 10M
        default storage (initial 100K next 100K minextents 1 maxextents 100

pctincrease 0);

create tablespace temporary_tables

        datafile '/u15/oradata/dba/version_tables01.dbf'
        size 10M
        default storage (initial 100K next 100K minextents 1 maxextents 100

pctincrease 0);

alter user sys temporary tablespace temp; alter user system temporary tablespace temp;

@/u01/app/oracle/product/8.1.7/rdbms/admin/catproc.sql connect system/manager;
@/u01/app/oracle/product/8.1.7/rdbms/admin/catdbsyn.sql @/u01/app/oracle/product/8.1.7/sqlplus/admin/pupbld.sql spool off

--
-- Script is finished !!!
--
exit



"Ashadul Khan" <ashadul_at_starpower.net> wrote in message
news:97lqva$1re$1_at_bob.news.rcn.net...


> I'm running Oracle 8.0.5 on Solaris 2.7. Is there any way I can create

> another instance in same machine or is it possible to run multiple

 instances


> in same machine? Please let me know the steps on how to create a second

> oracle instances.

>

>

Received on Fri Mar 02 2001 - 11:55:42 CST