Re: file instORCL missing in Web Application Server

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/12/31
Message-ID: <68csi1$49u$1@news02.btx.dtag.de>#1/1

Thomas Frei wrote:
>
> I 've downloaded the latest trial version of the Web Application Server.
>
> When I'm trying to start the database I receive the message that the
> file instORCL.ora was not found. While searching the file in all my
> directories I found out
> that there's no such file in the installation files!
>
> What will I have to do ?
>
> Thanks ;_)
>
> Thomas

Hi Thomas,

if you didn't install sample database and didn't create your own databasee you won't have an initORCl.ora file. This file contains startup paramter for your database and may lokk like:

compatible = 7.3.3.0.0

background_dump_dest = %RDBMS73%\trace
#control_files =

(c:\ora_cont\ctl1.ora,f:\ora_cont\ctl1.ora,e:\ora_cont\ctl1.ora,d:\ora_cont\ctl1.ora)
control_files =
(c:\ora_cont\ctl1.ora,e:\ora_cont\ctl1.ora,d:\ora_cont\ctl1.ora)

cpu_count=2

db_block_size = 8192
db_block_buffers = 4000
DB_BLOCK_LRU_EXTENDED_STATISTICS = 1500
db_name = oracle
db_file_multiblock_read_count = 8
nls_territory = Germany

nls_language = German
nls_sort = German_DIN

distributed_lock_timeout = 10 
distributed_recovery_connection_hold_time = 0
distributed_transactions = 10  

global_names = FALSE

log_archive_start = true
log_archive_dest = e:\ora_arch
log_archive_format = O_%S.%T
log_block_checksum = true
log_buffer = 65536
log_checkpoint_interval = 1000 
log_checkpoints_to_alert = true
log_simultaneous_copies = 4
max_enabled_roles = 8
open_links = 20
open_cursors = 64                                             

processes = 200
parallel_max_servers = 18
parallel_min_servers = 6
row_locking =
ALWAYS sequence_cache_entries = 70
sequence_cache_hash_buckets = 10
sort_area_retained_size = 1524288
sort_area_size = 1524288
Timed_Statistics = True
user_dump_dest = %RDBMS73%\trace\control

shared_pool_size = 17000000      
dml_locks = 200                
sequence_cache_entries = 10        

sequence_cache_hash_buckets = 10
max_dump_file_size = 5120
remote_login_passwordfile = shared
#rollback_segments = (rb1, rb2)
rollback_segments = (rb1, rb2, rb3, rb4, rb5, rb6, rb7, rb8, rb9, rb10, rb11, rb12, rb13, rb14, rb15, rb16)

-- 
Regards

Matthias Gresz    :-)

Received on Wed Dec 31 1997 - 00:00:00 CST