Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Svrmgrl "connect internal" asks for password??

RE: Svrmgrl "connect internal" asks for password??

From: Fowler, Kenneth R <kenneth_r_fowler_at_groton.pfizer.com>
Date: Wed, 07 Mar 2001 10:53:20 -0800
Message-ID: <F001.002C61CC.20010307102031@fatcity.com>

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: 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US