Re: how to start Oracle 8i DB automatically

ashrivastava_at_auriga-insys.com (Anand) wrote in message news:<396cc940.0207142149.e348cb5_at_posting.google.com>...
> Hi,
> Here are the contents from my init.ora file!
>
> # Copyright (c) 1991, 1998 by Oracle Corporation
> # -------Installation/Database Size------
> # SMALL MEDIUM LARGE
> # Block 2K 4500K 6800K 17000K
> # Size 4K 5500K 8800K 21000K
> ###############################################################################
>
> db_name = "DEMIST"
> 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
> #timed_statistics = true # if you want timed statistics
> 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

Couple of things.

From alert log.
> 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.

Your database is version 8.1.6.0.0. This version is desupported by Oracle. You *Should* upgrade to atleast 8.1.7.0.0. (Patchset 8.1.7.4 is recommended)

From pfile
> compatible = 8.0.5

You should change that to major version of your database. In your case it should be,
compatible = 8.1.6.0.0
BTW...You can use compatible = 8.1.6.0.0 if the database is 8.1.7.0.0

I am surprised you are not getting ORA-00402 at database startup when using previous version in your compatability. Maybe it is OK to use compatible = 8.0.5 on 8.1.6.0.0. Can someone verify this?

I think you should still change to compatible = 8.1.6.0.0 and then try again.

> #rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )
Any reason why you have this commented out? Are you bringing your non system rollback segments online after you start your database?

HTH
//Rauf Sarwar Received on Tue Jul 16 2002 - 02:33:24 CEST