Something I forgot to mention in the original post...
I am trying to create test databases (one for Oracle 8.1.6 and one for
Oracle 8.1.7). The database creation scripts and the parameter files are
created from templates and thus all parameters are pretty much equivalent
except in places where they obviously need to differ (dbname etc). Here is
an example...
$ dba816
dba816 $ cdpfile
/Volumes/app/oracle/admin/dba816/pfile
dba816 $ ls *.ora
configdba816.ora initdba816.ora initdba816_0.ora
dba816 $ cat initdba816.ora
ifile = /Volumes/app/oracle/admin/dba816/pfile/configdba816.ora
rollback_segments =
(r01,r02,r03,r04,r05,r06,r07,r08,r09,r10,r11,r12,r13,r14,r15,r16)
db_file_multiblock_read_count = 32
db_block_buffers = 3200
shared_pool_size = 9000000
processes = 200
dml_locks = 500
log_buffer = 163840
compatible = 8.1.6.0.0
audit_trail = true
timed_statistics = true
max_dump_file_size = 10240
log_archive_start = true
job_queue_interval = 60
job_queue_processes = 2
global_names = true
db_domain = groton.pfizer.com
db_name = dba816
dba816 $ cat configdba816.ora
control_files = (/ora1/oradata/dba816/ctrl/dba816_control1.ctl,
/ora2/oradata/dba816/ctrl/dba816_control2.ctl)
background_dump_dest = /Volumes/app/oracle/admin/dba816/bdump
core_dump_dest = /Volumes/app/oracle/admin/dba816/cdump
user_dump_dest = /Volumes/app/oracle/admin/dba816/udump
log_archive_dest = /Volumes/app/oracle/admin/dba816/arch
log_archive_format = "ora_dba816_%t_%s.arc"
db_block_size = 8192
dba816 $ cdcreate
/Volumes/app/oracle/admin/dba816/create
dba816 $ ls *.sql
crdb1dba816.sql crdb2dba816.sql
dba816 $ cat crdb1dba816.sql
set termout on
set echo on
spool /Volumes/app/oracle/admin/dba816/create/crdb1dba816.out
connect internal
startup nomount
pfile=/Volumes/app/oracle/admin/dba816/pfile/initdba816_0.ora
create database "dba816"
maxdatafiles 255
maxinstances 8
maxlogfiles 32
maxloghistory 1000
maxlogmembers 4
character set "US7ASCII"
datafile
'/ora1/oradata/dba816/data/dba816_system01.dbf' size 200M
logfile
group 1 ('/ora1/oradata/dba816/redo/dba816_redo1_1.rdo',
'/ora2/oradata/dba816/redo/dba816_redo1_2.rdo') size 10M,
group 2 ('/ora1/oradata/dba816/redo/dba816_redo2_1.rdo',
'/ora2/oradata/dba816/redo/dba816_redo2_2.rdo') size 10M,
group 3 ('/ora1/oradata/dba816/redo/dba816_redo3_1.rdo',
'/ora2/oradata/dba816/redo/dba816_redo3_2.rdo') size 10M;
disconnect
spool off
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fowler, Kenneth R
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
