Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
14%
200 - 500 GB
31%
500 - 800 GB
3%
800 - 1200 GB
7%
1200 - 1500 GB
10%
1500 - 2000 GB
14%
> 2000 GB
21%
Total votes: 29

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 11th August 2003, 18:49
philpom's Avatar
philpom philpom is offline
Junior Member
 
Join Date: Sep 2002
Location: Dallas
Posts: 22
philpom is on a distinguished road
Baan: BaanIV and BaanERP - DB: Oracle - OS: HPUX
Talking initbaan.ora 8.1.7

Hi,

We are upgrading from oracle 734 to 817 on a test box and wanted to know if someone could post their ora.init file from an Oracle 8.1.7 environment for me. Our DBA said it would save her much time converting our init file from 734 to 817 if she had one as a refference.

Thanks in advance for the help.

Mark Philpott
__________________
Mark...
Reply With Quote
Sponsored Links
  #2  
Old 18th August 2003, 15:18
PeterH's Avatar
PeterH PeterH is offline
Member
 
Join Date: Aug 2001
Location: Maastricht - Netherlands
Posts: 53
PeterH is on a distinguished road
Baan: Baan IV c4 - DB: Oracle 8 - OS: unix
Hope this will help

#### Oorzaak : Migratie naar Oracle 8.1.7
#### Aanpassing :

db_name = baan

remote_login_passwordfile = exclusive
control_files = $ORACLE_HOME/dbs/ctrl1baan.dbf, /oradata/baan/ctrl2baan.dbf
#rollback_segments = (r30)
rollback_segments = (r01,r02,r03,r04,r05,r06,r07,r08,r09,r10,r11,r12,r13,r14,r15,r16,r17,r18,r19,r20,r21,r22,r23,r24
,r25,r26,r27,r28,r29,r30)
#rollback_segments = (r01,r02,r03,r04,r05,r06,r07,r08,r09,r10)
max_rollback_segments = 31
transactions_per_rollback_segment = 25

# Obsolete V7 parameters
# obs. db_file_simultaneous_writes = 16
# obs. db_block_checkpoint_batch = 16
# obs. db_writers = 1
# obs. log_simultaneous_copies = 6
# obs. log_small_entry_max_size = 80
# obs. sequence_cache_entries = 10
# obs. sequence_cache_hash_buckets = 10
# obs. checkpoint_process = TRUE
# obs. row_cache_cursors = 128
# obs. sort_write_buffers = 4
# obs. temporary_table_locks = 2205


# tuning parameters

db_block_size = 8192
db_files = 50
# db_block_buffers = 57344
db_block_buffers = 51200
db_block_lru_latches = 3
parallel_min_servers = 3
parallel_max_servers = 15
shared_pool_size = 367001600
pre_page_sga = TRUE
#lock_shared_memory = TRUE
log_checkpoint_interval = 1024001
log_checkpoints_to_alert = TRUE
#processes = 500
processes = 900
sessions = 970
dml_locks = 2848
log_buffer = 1048576
enqueue_resources = 8192
cursor_space_for_time = TRUE
open_cursors = 5120
session_cached_cursors = 512
sort_area_retained_size = 65536
sort_area_size = 2097152
always_anti_join = HASH

max_dump_file_size = 10240
# ivm caretronic database link global_names op false
global_names = FALSE

event = "10181 trace name context forever, level 1500"

# Tuning parameter voor Asynchrone IO
# obs. use_async_io = TRUE

# TIMED_STATISTICS = TRUE

# Dump parameter
background_dump_dest = /oracle/app/oracle/admin/baan/bdump
core_dump_dest = /oracle/app/oracle/admin/baan/cdump
user_dump_dest = /oracle/app/oracle/admin/baan/udump

# Uncommenting the line below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
log_archive_start = TRUE
log_archive_dest = /archive/
log_archive_format = log_%s_t%t.arch

Greetz Peter.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Baan IVc2 and Oracle 8.1.7 performance problem mpenno Performance & Tuning 2 3rd September 2003 19:50
initbaan.ora KO.SA. Operating Systems & Databases 1 25th October 2002 19:41
Upgrade Oracle 8.0.6 to 8.1.7 gcharles Operating Systems & Databases 1 18th September 2002 12:35
Error installing B4c4 with Oracle 8.1.7 on NT syllepage Tools Administration & Installation 2 22nd July 2002 14:52
Upgrading Oracle 8.0.5 to 8i (8.1.7) ranias Operating Systems & Databases 14 5th March 2002 17:29


All times are GMT +2. The time now is 04:37.


©2001-2018 - Baanboard.com - Baanforums.com