Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Restrictions in the OTN downloadable version of 9i?

Re: Restrictions in the OTN downloadable version of 9i?

From: <peter.peltonen_at_iki.fi>
Date: 3 Jul 2002 22:32:37 GMT
Message-ID: <afvu25$gn0$1@oravannahka.helsinki.fi>


Niall Litchfield <niall.litchfield_at_dial.pipex.com> wrote: > Obviously win2k must be a better os than linux <runs off laughing > hysterically>

Well, when it turned out that our app is working fine against Win2k running 8i I kinda blushed :) I'd been so proud with my nice little linux installation running Oracle... Oh well.

I'm going to install Oracle on some other linux machine in the near future to see what happens...

> Seriously if the app performs badly against only one database/machine
> especially if you can replicate the problems with the demo db then I'd be
> tempted to look at the initialisation parameters of the db on linux (and the
> kernel parms as well) and also the network connections between the machines.

Great. Here is some info. If you need more, just ask.

The network is quite simple: It is a private network (192.168.0.0). All hosts are connected to a 100M HP's switch by ethernet. The machine has Intels's NIC:

From dmesg:
--<snip>--
eepro100.c:v1.09j-t 9/29/99 Donald Becker http://cesdis.gsfc.nasa.gov/linux/drivers/eepro100.html eepro100.c: $Revision: 1.36 $ 2000/11/17 Modified by Andrey V. Savochkin <saw_at_saw.sw.com.sg> and others
PCI: Found IRQ 11 for device 01:08.0
eth0: Intel Corporation 82801BA(M) Ethernet, 00:03:47:13:E5:53, IRQ 11.   Board assembly 000000-000, Physical connectors present: RJ45   Primary interface chip i82555 PHY #1.
  General self-test: passed.
  Serial sub-system self-test: passed.
  Internal registers self-test: passed.
  ROM checksum self-test: passed (0x04f4518b). --</snip>--

ifconfig reports of no errors. Transferring files via ftp happens as fast as in any other machine on the network.

My /etc/sysctl.conf:
--<snip>--
# Disables packet forwarding
net.ipv4.ip_forward = 0
# Enables source route verification
net.ipv4.conf.default.rp_filter = 1
# Disables the magic-sysrq key
kernel.sysrq = 0

# 320M
kernel.shmmax = 335544320

kernel.sem = 250 32000 100 128
kernel.msgmni = 128
--</snip>--

My /opt/oracle91/product/9.0.1/dbs/inittest.ora: --<snip>--
##############################################################################
# Copyright (c) 1991, 2001 by Oracle Corporation
##############################################################################
 

###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_cache_size=67108864  

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300  

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/opt/oracle/admin/test/bdump core_dump_dest=/opt/oracle/admin/test/cdump timed_statistics=TRUE
user_dump_dest=/opt/oracle/admin/test/udump

###########################################
# Distributed, Replication and Snapshot
###########################################
db_domain=fivetec.dev
remote_login_passwordfile=EXCLUSIVE  

###########################################
# File Configuration
###########################################

control_files=("/opt/oracle/oradata/test/control01.ctl", 
"/opt/oracle/oradata/te
st/control02.ctl", "/opt/oracle/oradata/test/control03.ctl")
 

###########################################
# MTS
###########################################
dispatchers="(PROTOCOL=TCP)(SER=MODOSE)", "(PROTOCOL=TCP)(PRE=oracle.aurora.serv
er.GiopServer)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"  

###########################################
# Miscellaneous
###########################################
compatible=9.0.0
db_name=test  

###########################################
# Network Registration
###########################################
instance_name=test  

###########################################
# Pools
###########################################
java_pool_size=117440512
large_pool_size=1048576
shared_pool_size=117440512  

###########################################
# Processes and Sessions
###########################################
processes=150  

###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300  

###########################################
# Resource Manager
###########################################
resource_manager_plan=SYSTEM_PLAN  

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
sort_area_size=524288  

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS  

# added by peter
license_sessions_warning=140
--</snip>--

Regards,
Peter Received on Wed Jul 03 2002 - 17:32:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US