Re: how to start Oracle 8i DB automatically
Date: 14 Jul 2002 22:49:58 -0700
Message-ID: <396cc940.0207142149.e348cb5_at_posting.google.com>
Hi,
# Copyright (c) 1991, 1998 by Oracle Corporation
db_name = "DEMIST"
Here are the contents from my init.ora file!
# -------Installation/Database Size------
# SMALL MEDIUM LARGE
# Block 2K 4500K 6800K 17000K
# Size 4K 5500K 8800K 21000K
###############################################################################
instance_name = DEMIST
service_names = DEMIST
db_files = 1024
control_files = ("E:\Oracle\oradata\DEMIST\control01.ctl",
"E:\Oracle\oradata\DEMIST\control02.ctl",
"E:\Oracle\oradata\DEMIST\control03.ctl")
open_cursors = 100
max_enabled_roles = 30
db_file_multiblock_read_count = 8
db_block_buffers = 3423
shared_pool_size = 9349120
large_pool_size = 614400
java_pool_size = 0
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 50
parallel_max_servers = 5
log_buffer = 32768
#audit_trail = true # if you want auditing
max_dump_file_size = 10240 # limit trace file size to 5M each
# Uncommenting the line below will cause automatic archiving if
archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
# log_archive_start = true
# log_archive_dest_1 = "location=E:\Oracle\oradata\DEMIST\archive"
# log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
#rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )
# Global Naming -- enforce that a dblink has same name as the db it
connects to
global_names = true
# Uncomment the following line if you wish to enable the Oracle Trace
product
# to trace server activity. This enables scheduling of server
collections
# from the Oracle Enterprise Manager Console.
# Also, if the oracle_trace_collection_name parameter is non-null,
# every session will write to the named collection, as well as
enabling you
# to schedule future collections from the console.
# oracle_trace_enable = true
oracle_trace_collection_name = ""
# define directories to store trace and alert files
background_dump_dest = E:\Oracle\admin\DEMIST\bdump
#Uncomment this parameter to enable resource management for your
database.
#The SYSTEM_PLAN is provided by default with the database.
#Change the plan name if you have created your own resource plan.#
resource_manager_plan = system_plan
user_dump_dest = E:\Oracle\admin\DEMIST\udump
db_block_size = 8192
remote_login_passwordfile = exclusive
os_authent_prefix = ""
distributed_transactions = 500
compatible = 8.0.5
sort_area_size = 65536
sort_area_retained_size = 65536
I tried to infer something from it but couldn't find any useful
information. I also tried to look into the alert log but that totally
went off my head :(
Here are some of the latest entries from it:
Mon Jul 15 10:46:15 2002
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 50 shared_pool_size = 9349120 large_pool_size = 614400 java_pool_size = 32768 control_files = E:\Oracle\oradata\DEMIST\control01.ctl,E:\Oracle\oradata\DEMIST\control03.ctl,
E:\Oracle\oradata\DEMIST\control02.ctl
db_block_buffers = 3423 db_block_size = 8192 compatible = 8.0.5 log_archive_dest_1 = LOCATION=E:\Oracle\Ora81\RDBMS log_buffer = 32768 log_checkpoint_interval = 10000 log_checkpoint_timeout = 1800 db_files = 1024 db_file_multiblock_read_count= 8 max_enabled_roles = 30 remote_login_passwordfile= EXCLUSIVE global_names = TRUE distributed_transactions = 500 instance_name = DEMIST service_names = DEMIST sort_area_size = 65536 sort_area_retained_size = 65536 db_name = DEMIST open_cursors = 100 os_authent_prefix = parallel_max_servers = 5 background_dump_dest = E:\Oracle\admin\DEMIST\bdump user_dump_dest = E:\Oracle\admin\DEMIST\udump max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7
Mon Jul 15 10:46:21 2002
/* OracleOEM */ ALTER DATABASE MOUNT
Mon Jul 15 10:46:26 2002
Successful mount of redo thread 1, with mount id 3641929986. Mon Jul 15 10:46:26 2002
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT Mon Jul 15 10:46:27 2002
/* OracleOEM */ ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Mon Jul 15 10:46:29 2002
Thread recovery: start rolling forward thread 1 Recovery of Online Redo Log: Thread 1 Group 1 Seq 631 Reading mem 0 Mem# 0 errs 0: E:\ORACLE\ORADATA\DEMIST\REDO01.LOG Mon Jul 15 10:46:30 2002
Thread recovery: finish rolling forward thread 1 Thread recovery: 3 data blocks read, 3 data blocks written, 2 redo blocks read
Crash recovery completed successfully
Mon Jul 15 10:46:32 2002
Thread 1 advanced to log sequence 632
Thread 1 opened at log sequence 632
Current log# 2 seq# 632 mem# 0: E:\ORACLE\ORADATA\DEMIST\REDO02.LOG Successful open of redo thread 1.
Mon Jul 15 10:46:32 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Jul 15 10:46:37 2002
Completed: /* OracleOEM */ ALTER DATABASE OPEN Mon Jul 15 10:50:18 2002
archiving is enabled
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=9
Mon Jul 15 10:50:19 2002
ARCH: STARTING ARCH PROCESSES COMPLETE
Mon Jul 15 10:50:19 2002
ARC0: Archival started ARC0: Beginning to archive log# 1 seq# 631 ARC0: Completed archiving log# 1 seq# 631
Please see if you can do something!
Anand
Received on Mon Jul 15 2002 - 07:49:58 CEST