Re: Database cache in iAS 9i installation

[Quoted] This may be a dumb question but IS the controlfile at d:\oracle\ora812\dbs\control01.ctl? And why are you running with only one controlfile?

Van

[Quoted] [Quoted] "Anton G. Sokolovsky" <me_at_dgraf.eu.org> wrote in message news:99d491$b87$1_at_alice.infopulse.kiev.ua...
> Has anyone successfully installed and configured Oracle database Cache ?
>
> Oracle iAS 9i 1.0.2 for WindowsNT/2000
> Windows2000 Professional
>
> Cache configurator is unable to create cache (wtacca -create -typical).
>
> 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 - 23:37:29 CET