Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Svrmgrl "connect internal" asks for password??
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
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: kenneth_r_fowler_at_groton.pfizer.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 Mar 07 2001 - 12:53:20 CST
![]() |
![]() |