Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Windows service does not start DB
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:udptj831i1paf7_at_corp.supernews.com...
>
> Please try to be *exact* instead of *vague*
> 'Windows found *some* disk problems'
> Where? It might have corrupted Oracle binaries!
> Did you check the alert<sid>.log? Probably not.
> Please check the alert before posting, your post doesn't contain any
> sensible clues. The error points to the fact Oracle can't create the
SGA,
> you might have changed the init.ora parameters in the meantime.
> Also: you are one of the regulars here who consistently crosspost.
Please
> stop doing so.
Dear Sybrand,
I want to be exact but it's realy difficult to say were Windows had
found disk problem. The whole partiotion where Windows found problems is
mostly dedicated for my Oracle database instance, so it is very probably
that something was wrong with Oracle binaries. Maybe computer was shut
off without regular Oracle shutdown procedure. Here is alert log file
you
did mention in your post:
Dump file E:\oracle\admin\PBASE\bdump\PBASEALRT.LOG
Mon May 13 08:41:35 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
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 100 shared_pool_size = 31457280 large_pool_size = 614400 java_pool_size = 20971520 control_files = E:\oracle\oradata\PBASE\control01.ctl,E:\oracle\oradata\PBASE\control02.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 = 100 remote_login_passwordfile= EXCLUSIVE global_names = TRUE distributed_transactions = 500 instance_name = PBASE service_names = PBASE mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer) open_links = 4 sort_area_size = 65536 sort_area_retained_size = 65536 db_name = PBASE open_cursors = 300 ifile = E:\oracle\admin\PBASE\pfile\init.ora os_authent_prefix = job_queue_processes = 4 job_queue_interval = 10 parallel_max_servers = 5 background_dump_dest = E:\oracle\admin\PBASE\bdump user_dump_dest = E:\oracle\admin\PBASE\udump max_dump_file_size = 10240
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 SNP0 started with pid=8 SNP1 started with pid=9 SNP2 started with pid=10 SNP3 started with pid=11
Thank you Sybrand and best regards
-- Stjepan BrbotReceived on Mon May 13 2002 - 02:49:55 CDT