HELP: Database cache in iAS 9i installation

From: Anton G. Sokolovsky <me_at_dgraf.eu.org>
Date: Thu, 22 Mar 2001 17:04:36 +0200
Message-ID: <99d491$b87$1_at_alice.infopulse.kiev.ua>

[Quoted] Has anyone successfully installed and configured Oracle database Cache ?

[Quoted] [Quoted] Oracle iAS 9i 1.0.2 for WindowsNT/2000
Windows2000 Professional

Cache configurator is unable to create cache (wtacca -create -typical).

[Quoted] [Quoted] Below is the abstract from icacheALRT.LOG file

Help is greatly appreciated.

--------=========---------

Dump file d:\oracle\ora812\admin\icache\bdump\icacheALRT.LOG Thu Mar 22 13:01:08 2001
ORACLE V8.1.7.0.0 - Production vsnsta=0 vsnsql=e vsnxtr=3 Windows 2000 Version 5.0 Service Pack 1, CPU type 586 Starting up ORACLE RDBMS Version: 8.1.7.0.0. System parameters with non-default values:

  processes                = 100
  license_max_sessions     = 15
  shared_pool_size         = 16777216
  large_pool_size          = 12582912
  java_pool_size           = 20971520
  control_files            = d:\oracle\ora812\dbs\control01.ctl
  db_block_buffers         = 3200
  db_block_size            = 8192
  compatible               = 8.1.0
  log_buffer               = 81920
  log_checkpoint_interval  = 10000
  log_checkpoint_timeout   = 1800
  max_enabled_roles        = 30
  remote_login_passwordfile= EXCLUSIVE
  distributed_transactions = 10
  instance_name            = icache
  service_names            = icache.anton
  mts_dispatchers          =

(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer),
(PROTOCOL=TCP)(SERV=MODOSE)

  open_links               = 4
  sort_area_size           = 65536
  sort_area_retained_size  = 65536
  db_name                  = icache
  open_cursors             = 100
  os_authent_prefix        =
  remote_dependencies_mode = SIGNATURE
  job_queue_processes      = 4
  job_queue_interval       = 3
  background_dump_dest     = d:\oracle\ora812\admin\icache\bdump
  user_dump_dest           = d:\oracle\ora812\admin\icache\udump
  max_dump_file_size       = 10000
  core_dump_dest           = d:\oracle\ora812\admin\icache\cdump
  oracle_trace_enable      = TRUE
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
Thu Mar 22 13:01:12 2001
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Thu Mar 22 13:01:14 2001
alter database mount exclusive
Thu Mar 22 13:01:17 2001

ORA-00202: controlfile: 'd:\oracle\ora812\dbs\control01.ctl'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Thu Mar 22 13:01:17 2001
ORA-205 signalled during: alter database mount exclusive... Shutting down instance (abort)
License high water mark = 5

--
Rgds,
me.

Received on Thu Mar 22 2001 - 16:04:36 CET