According to Baan Knowledge Base Solution 163684, Oracle 10g is supported as of portingsets 6.1c.07.04 and 7.1d.05.

Does anyone have any experience with it yet?

Any success/horror stories to share?

Thanks!

I've installed BaanIV both on Sun Solaris 9 and on Suse 9.1
with Oracle 10g successfully.

Thanks soltpeter. How has performance been on 10g compared to other versions? Are there any interesting problems you encountered, required parameter tweaks, etc. that you could share? What portingset are you on?

Thanks again,
Brandon

Linux
> bshell6.1 -v
Product ver.: 6.1c.07.04
Port no. : PA.2508
Date : Tue Jun 8 15:02:28 CEST 2004
Uname : Linux orangebird 2.4.19-64GB-SMP #1 SMP Mon Oct 21 18:48:05 UTC 20
02 i686 unknown
Machine-id : LINUX_INTEL
OS-release : LINUX2.4
.....

>cat /etc/sysctl.conf
kernel.sem=250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
# half of phys mem 256 M
kernel.shmmax = 256000000
fs.file-max = 65536
vm.nr_hugepages = 2048
vm.disable_cap_mlock = 1

I can't compare the performance with other versions but it runs
quite well and the errors are easily correctable.

@all

from Technical Notes Portingset 61c0705 :

"Benchmarks on Oracle 10 indicate a performance loss of 10% in comparision with Oracle 9. Benchmark on Oracle 9 indicate loss of Performance of about 20% in comparision with Oracle8"

martin

Brandon,

i have installed Baan IV c4 and Oracle10G on Suse9, on server it is working fine, but no clients are able to connect.

while connecting following errors are coming.

rexec failed host "132.147.160.243" port 512, username bsp command /aplab/baanapp/bin/ipc_boot6.1'

could u pls help me out. how u have managed this >

Deepak

Hi Deepak,

I haven't installed our Baan/10g environment yet, but from the error you mention I don't see any indication that is has anything to do with Oracle 10g.

Can you ping the server from the client where you are trying to connect?
Can you ping the client from the server, and ping it's hostname? I think Baan/rexec tries to do a reverse DNS lookup on some platforms before it allows you to connect, so maybe you are failing there due to some network configuration issue. Is there any more detail in your log files?

Deepak - SuSE comes with rexec turned off by default. You can turn it on in Yast.


I tired SuSE 10gR1 and Baan 4. I really don't like 10g, it was a Pita to install, and gave weird buggy error messages in the trace files. (were on EMT64)
(known issue that's fixed for all other platforms.)

importing 120GB worth of data into 10g took like 4 days, and yeah, i know how to turn a database and server.

I rolled back to 9i and haven't been happier.

Dave

Thanks for the feedback Dave, but how about 10gR2? Have you tried that? Oracle first releases of every version tend to be pretty buggy, but I've heard 10gR2 is a lot better.

I'm not sure if R2 exists for my platform yet.

Also, I don't think that Baan supports it yet..

Dave

Yes, according to Metalink 10gR2 is supported for your platform:

Certify - Certification Matrix: Oracle Database - Enterprise Edition on Linux x86-64 (AMD64/EM64T)

--------------------------------------------------------------------------------


Server Certifications
OS Product Certified With Version Status Addtl. Info. Components Other Install Issue
SLES-9 10gR2 64-bit N/A N/A Certified None None None None

In Baan's portingset (6.1c.07.09) documentation it just says "10g" is supported so I assumed that meant 10.x, but I have opened a case with them now to find out specifically if 10.2 is supported - will post the results when I get them.

Regards,
Brandon

Ah well that's good to know.

I think i'm happy with 9i for now though!

Dave

Here is the info from our support case

Details: What porting set or function pack supports Oracle 10G Release 2?

Resolution: Unfortunately at this time Baan does not support Oracle 10g R2 yet. It will work with the latest porting set, but it has caused problems in the Baan environment. We will continue to improve functionality with future porting sets and feature packs.

new portingset is available for 10g rel2 on the downloadsite

Thanks, but could you please elaborate on what porting set version you are talking about and where it says that it supports 10gR2? The most recent porting set I see is 6.1c.07.09 and in the release notes it only mentions 10g. I don't see any mention of 10g release 2.

When you go to the ftpsite from ssa support you can see the new portingset at /updates/port and in the documentation from this portingset you can see thats its compatible with oracle 10.g release 2

Yes, your right - I see it on the FTP site. They haven't posted this new porting set in solution 15219 yet, but that will be coming soon I'd imagine.

Thanks!


From page 3-3 of ftp://ftp.support.baan.com/updates/port/6.1c.07.10/Technical_notes_portingset_61c0710.pdf:

"Supported: Oracle SE/EE 9.2, 10.1, 10,2"