2nd instance

From: Debor19071 <debor19071_at_aol.com>
Date: 1996/06/29
Message-ID: <4r3fv4$r86_at_newsbf02.news.aol.com>

Subject: Re: How to startup a new, 2nd instance of the X-Organization: America Online, Inc. (1-800-827-6364) References: <4qcqk4$abp_at_pgs-gw.hstn.expl.pgs.com> In-Reply-To: <4qcqk4$abp_at_pgs-gw.hstn.expl.pgs.com>

You create the second instance AND the second database - they go together - you will need to edit your TNSNAMES.ora, LISTENER.ORA, ORATAB files in UNIX and Windows front end. If you can get ahold of the new Oracle Unix Administration manual for 7.3 - there are examples of these - you add a line in ORATAB for the new database instance. CLONE all the required DDL for the database, tablespaces - and make appropriate modifications

The first one you run would be to create the DATABASE (under INTERNAL) the second one you would run is to create the TABLESPACES - Here's a list of what you should do::

Here are steps

 PRODUCTION ORACLE INSTANCE/DATABASE (NAME: PROD)Deb Dawicki - Revised 5/2/96
1. clone DDL from TWH for database and modify for PROD (/usr1/oracle/dbs/crdbTWH.sql)
2. clone DDL from TWH for tablespaces and modify for PROD (/usr1/oracle/dbs/crdb2TWH.sql)
3. clone init.ora from TWH and MODIFY for PROD (check each parm - mirror for medium SITE) (/usr1/oracle/dbs/initTWH.ora AND initTWH_0.ora)
4. control files are created at time of database creation

5. modify listener.ora and tnsnames.ora (both on UNIX in
/usr1/oracle/network/admin and on each workstation (tnsnames.ora only)
in directory /orawin/network/admin )

6. modify /usr1/oracle/bin/dbstart, /usr1/oracle/bin/dbshut,
/usr1/oracle/bin/dbdie, /usr/local/bin/run-backup (existing cold backup
- below for hot backup)

7. clone DDL on WINDOWS for PROD - create new directory called c:\ptc\sql\prod with each file related to each table as is now (i.e. NEW_<tbl abbrev>.sql)

8. turn ARCHIVING ON

9. set up hot backup script 10. After userids, and instance started, MAKE SURE to CHECK to see if you need to run the following catalog

scripts connected to the new instance as SYS  !!!     check 


/usr1/oracle/rdbms/admin/CATAUDIT.SQL     check 

/usr1/oracle/rdbms/admin/CATBLOCK.SQL     check 

/usr1/oracle/rdbms/admin/CATDBSYN.SQL     check 

/usr1/oracle/rdbms/admin/CATEXP.SQL     check 

/usr1/oracle/rdbms/admin/CATLDR.SQL     check 

/usr1/oracle/rdbms/admin/CATPROC.SQL  *** IMPORTANT ***     check 

/usr1/oracle/rdbms/admin/CATSTAT.SQL     check 

/usr1/oracle/rdbms/admin/CATSNAP.SQL     check 

/usr1/oracle/rdbms/admin/DBMSSTDX.SQL     check 

/usr1/oracle/rdbms/admin/DBMSALRT.SQL     check 

/usr1/oracle/rdbms/admin/DBMSLOCK.SQL     check 

/usr1/oracle/rdbms/admin/DBMSMAIL.SQL     check 

/usr1/oracle/rdbms/admin/DBMSOTPT.SQL     check 

/usr1/oracle/rdbms/admin/DBMSPIPE.SQL     check 

/usr1/oracle/rdbms/admin/DBMSSNAP.SQL     check 

/usr1/oracle/rdbms/admin/DBMSUTIL.SQL     check 

/usr1/oracle/rdbms/admin/UTLBSTAT.SQL     check 

/usr1/oracle/rdbms/admin/UTLCHAIN.SQL     check 

/usr1/oracle/rdbms/admin/UTLDIDXS.SQL     check 

/usr1/oracle/rdbms/admin/UTLDTREE.SQL     check 

/usr1/oracle/rdbms/admin/UTLESTAT.SQL     check 

/usr1/oracle/rdbms/admin/UTLEXCPT.SQL     check 

/usr1/oracle/rdbms/admin/UTLLOCKT.SQL     check 

/usr1/oracle/rdbms/admin/UTLMAIL.SQL     check 

/usr1/oracle/rdbms/admin/UTLMONTR.SQL     check 

/usr1/oracle/rdbms/admin/UTLOIDXS.SQL     check 

/usr1/oracle/rdbms/admin/UTLSAMPL.SQL     check 

/usr1/oracle/rdbms/admin/UTLSIDXS.SQL     check 


/usr1/oracle/rdbms/admin/UTLXPLAN.SQL     check   

Example of Create Database DDL:

REM * Set terminal output and command echoing on; log output of this script.
REM *
#set termout on

EXAMPLE of creating tablespaces DDL

spool c:\spool\crdb2rtl.lis
prompt "Connecting as system"
CONNECT system/oradba_at_rtl;

create tablespace ptc_data_rtl datafile

        '/usr1/oracle/dbs/ptc_data_RTL.dbf' size 40M default storage (

	initial		 20M
	next		 20M
	pctincrease	   0
	minextents	   2

);

REM * Alter SYS and SYSTEM users.
REM * grant resource on ptc_data_rtl to chris, shirley, deborah, dawicki, twh;

REM alter user system default tablespace tools temporary tablespace temp;

REM * For each DBA user, run DBA synonyms SQL script. Don't forget that EACH
REM * DBA USER created in the future needs dba_syn.sql run from its account.
REM *
REM connect system/manager
REM _at_/usr1/oracle/rdbms/admin/catdbsyn.sql

spool off

#set echo on
spool /usr1/oracle/dbs/crdbRTL.lst

REM * Start the <sid> instance (ORACLE_SID here must be set to <sid>). REM *
connect internal
startup nomount pfile=/usr1/oracle/dbs/initRTL_0.ora

REM * Create the <dbname> database.  
REM * SYSTEM tablespace configuration guidelines:
REM *   General-Purpose ORACLE RDBMS		    5Mb
REM *   Additional dictionary for applications	10-50Mb 
REM * Redo Log File configuration guidelines:
REM *   Use 3+ redo log files to relieve ``cannot allocate new log...''

waits.
REM * Use ~100Kb per redo log file per connection to reduce checkpoints. REM *
create database "RTL"

    maxinstances 8
    maxlogfiles 32
    character set "US7ASCII"
    datafile

        '/usr1/oracle/dbs/systRTL.dbf' size 50M     logfile

	'/usr1/oracle/dbs/log1RTL.dbf'	size 500k,
	'/usr1/oracle/dbs/log2RTL.dbf'	size 500k,
	'/usr1/oracle/dbs/log3RTL.dbf'	size 500k;

disconnect
spool off

• Headers --------------------------------

Received on Sat Jun 29 1996 - 00:00:00 CEST