<INLINE> <snip> > Two things to check immediately: > > (1) Is the Oracle service defined as started automatically in > the services?
Yes > (2) If yes, is there any error reported in alert log of the database? Compared line-by-line the last three starts and they seem identical, nothing unusual in the last start. Anyway here is today's entries: Tue Jul 29 03:44:39 2003 Thread 1 advanced to log sequence 73 Current log# 1 seq# 73 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO01.LOG Tue Jul 29 03:45:00 2003 Thread 1 advanced to log sequence 74 Current log# 2 seq# 74 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO02.LOG Tue Jul 29 03:45:31 2003 Thread 1 advanced to log sequence 75 Current log# 3 seq# 75 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO03.LOG Dump file D:\oracle\admin\tpocs\bdump\tpocsALRT.LOG Tue Jul 29 05:31:23 2003 ORACLE V9.0.1.1.1 - Production vsnsta=0 vsnsql=10 vsnxtr=3 Windows 2000 Version 5.0 Service Pack 3, CPU type 586 Starting up ORACLE RDBMS Version: 9.0.1.1.1. System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 50331648 java_pool_size = 33554432 control_files = D:\oracle\oradata\tpocs\control01.ctl, D:\oracle\oradata\tpocs\control02.ctl, D:\oracle\oradata\tpocs\control03.ctl db_block_size = 4096 db_cache_size = 33554432 compatible = 9.0.0 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS remote_login_passwordfile= EXCLUSIVE db_domain = instance_name = tpocs background_dump_dest = D:\oracle\admin\tpocs\bdump user_dump_dest = D:\oracle\admin\tpocs\udump core_dump_dest = D:\oracle\admin\tpocs\cdump sort_area_size = 524288 db_name = tpocs open_cursors = 300 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 Tue Jul 29 05:31:26 2003 /* OracleOEM */ ALTER DATABASE MOUNT Tue Jul 29 05:31:31 2003 Successful mount of redo thread 1, with mount id 1877649006. Tue Jul 29 05:31:31 2003 Database mounted in Exclusive Mode. Completed: /* OracleOEM */ ALTER DATABASE MOUNT Tue Jul 29 05:31:31 2003 /* OracleOEM */ ALTER DATABASE OPEN Tue Jul 29 05:31:32 2003 Beginning crash recovery of 1 threads Tue Jul 29 05:31:33 2003 Started first pass scan Tue Jul 29 05:31:33 2003 Completed first pass scan Tue Jul 29 05:31:38 2003 Started recovery at Thread 1: logseq 74, block 202409, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 2 Seq 74 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\TPOCS\REDO02.LOG Recovery of Online Redo Log: Thread 1 Group 3 Seq 75 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\TPOCS\REDO03.LOG Tue Jul 29 05:31:39 2003 Ended recovery at Thread 1: logseq 75, block 18467, scn 0.2938502 3305 data blocks read, 3305 data blocks written, 20858 redo blocks read Crash recovery completed successfully Tue Jul 29 05:31:40 2003 Thread 1 advanced to log sequence 76 Thread 1 opened at log sequence 76 Current log# 1 seq# 76 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO01.LOG Successful open of redo thread 1. Tue Jul 29 05:31:40 2003 SMON: enabling cache recovery Tue Jul 29 05:31:41 2003 Undo Segment 1 Onlined Undo Segment 2 Onlined Undo Segment 3 Onlined Undo Segment 4 Onlined Undo Segment 5 Onlined Undo Segment 6 Onlined Undo Segment 7 Onlined Undo Segment 8 Onlined Undo Segment 9 Onlined Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Tue Jul 29 05:31:41 2003 SMON: enabling tx recovery Tue Jul 29 05:31:43 2003 replication_dependency_tracking turned off (no async multimaster replication found) Completed: /* OracleOEM */ ALTER DATABASE OPEN > Import does not shut the database down. I didn't think so. I'm just wondering why when I rebooted the server the TPOCS instance did start, it is like It didn't grab the InitTpocs.ora ...perplexed (but understandable when you are in the constant learn mode. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).