| Re: NMI errors after reboot [message #52273] |
Thu, 11 July 2002 16:26 |
TomY
Messages: 3
Registered: July 2002
|
Junior Member |
|
|
Mahesh:
Thanks for the detailed help.
The registry parameters look good, I ran the oradim -edit command, so autostart should be effective. And I believe that the instance _is_ starting automatically (the "already started" error when I try to manually start unless I shutdown first), just not the contained database.
I have attached the most recent TRC file, which was produced after a reboot around midday, there hasn't been another created since. I have included the newest alert file entry as well.
Thanks.
:Tom
--- Trace file and Log ----
----------------
senatorALRT.LOG
----------------
Dump file C:oracleadminsenatorbdumpsenatorALRT.LOG
Thu Jul 11 15:33:08 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Thu Jul 11 15:33:08 2002
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 31457280
large_pool_size = 614400
java_pool_size = 20971520
control_files = C:oracleoradatasenatorcontrol01.ctl, C:oracleoradatasenatorcontrol02.ctl, C:oracleoradatasenatorcontrol03.ctl
db_block_buffers = 2048
db_block_size = 8192
compatible = 8.1.0
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
db_domain = world
global_names = TRUE
distributed_transactions = 500
instance_name = senator
service_names = senator.world
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = senator
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = C:oracleadminsenatorbdump
user_dump_dest = C:oracleadminsenatorudump
max_dump_file_size = 10240
oracle_trace_collection_name=
----------------
The most recent
tracefile -- several
hours ago.
----------------
Dump file C:oracleadminsenatorudumpORA01280.TRC
Wed Jun 26 10:19:20 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: senator
Redo thread mounted by this instance: 1
Oracle process number: 16
Windows thread id: 1280, image: ORACLE.EXE
*** 2002-06-26 10:19:20.255
*** SESSION ID:(12.366) 2002-06-26 10:19:19.704
Import 8.0 queue table: SYSTEM.DEF$_AQCALL
Import 8.0 queue: SYSTEM.DEF$_AQCALL
Import 8.0 queue: SYSTEM.DEF$_AQCALL
Import 8.0 queue table: SYSTEM.DEF$_AQERROR
Import 8.0 queue: SYSTEM.DEF$_AQERROR
Import 8.0 queue: SYSTEM.DEF$_AQERROR
Dump file C:oracleadminsenatorudumpORA01280.TRC
Thu Jul 11 12:10:07 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: senator
Redo thread mounted by this instance: 1
Oracle process number: 14
Windows thread id: 1280, image: ORACLE.EXE
*** 2002-07-11 12:10:07.535
*** SESSION ID:(11.1) 2002-07-11 12:10:07.194
Registered presentation http://admin on database startup
----- End of Trace file and Log -----
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
