Good day,

We are looking at moving our database from 7.3.4 to 8.1.7. Our configuration is

oracle 7.3.4
portset 6.1b.03.03
BaanIVa
HPUX 11.11

Has anyone done this with succ? Is there any reason why we couldn't just upgrade oracle and leave baan alone? What is the suggested method? Do you have to purchse the extensions?

We don't use the DBA module, all maint in done outside of baan other than adding new scripts, reports, forms and table changes.

I would appreciate and advice on this matter.

Thanks,

Mark

Phil,

Many have gone before you go so by now it should be a well proven path.

Is there any reason why we couldn't just upgrade oracle and leave baan alone?
No, you need to add the Oracle8 functionality and thus relicense your system. There's also a minimum portingset version requirement

What is the suggested method?
You can get an Oracle upgrade guide from Baan Support. It's pretty good. Your basic 2 choices are to run a migration tool against your current database or do an export/import on a new database.

Do you have to purchse the extensions?Not sure that you mean by this. If you mean the relicensing I mentioned earlier, then yes but I don't think it will cost you any more.

We don't use the DBA module, all maint in done outside of baanNeither do we and never had any problems. Just make sure you are acquainted with the $BSE/lib/ora*_xxx tools.

Hi phil,

I think i have to contrdict Pat here!

The answers to your questions actually depend on your version:

In BaanIVc4 you have to install a patch, need a corresponding Portingset, which supports Oracle8 and you have to request a licence Key, which permits the usage of Oracle8 driver.

In BaanIVb and a, you have to buy I think the oracle extension, which gives you Oracle8!! This costs a bit extra.

The other option you have is to access your database via SQL-Net, even though your Database is directly installed. In this case you install the Oracle7 SqlNet client, point your oracle home to this client and point the TQO_TASk variable to the Oracle8 services. This has some performance penalties, but works.

Regards

Markus

OK... What I do know is that we are on b4a and that we must pay for the oracle8 support. We need to upgrade our portset from 6.1b.03.03 to 6.1c.05.xx.xx. I have looked at this previously but it turns into spegetti mess. I was hoping for an easy way out. our function servers stopped working with the new port set and also text quit printing. That was what we found with virtually no testing.

Thanks for the info

Mark, sorry for calling you Phil :)

Originally posted by Markus Schmitz
Hi phil,

I think i have to contrdict Pat here!

The answers to your questions actually depend on your version:

In BaanIVc4 you have to install a patch, need a corresponding Portingset, which supports Oracle8 and you have to request a licence Key, which permits the usage of Oracle8 driver.

In BaanIVb and a, you have to buy I think the oracle extension, which gives you Oracle8!! This costs a bit extra.

The other option you have is to access your database via SQL-Net, even though your Database is directly installed. In this case you install the Oracle7 SqlNet client, point your oracle home to this client and point the TQO_TASk variable to the Oracle8 services. This has some performance penalties, but works.

Regards

Markus

Markus,

So now I have installed 817 and moved the data over. I pointed the TWO_TASK at the 817 SID and my ORACLE_HOME I left at 734. I can actually log into baan but when I try to run something I get some ora errors.... Here is what my oracle7 log file looks like:

103-08-12[13:08:16]bsp:
103-08-12[13:08:16]bsp: ******* S T A R T of Log message *******
103-08-12[13:08:16]bsp: Log message called from ora_native.c $ $Revision: /main/bugfix6.1b/2 $: #983 keyw
ord: Oracle Error
103-08-12[13:08:16]bsp: Pid 28920 Uid 205 Euid 205 Gid 201 Egid 201
103-08-12[13:08:16]bsp: user_type S language 2 user_name bsp tty ypb locale ISO88591/NULL
103-08-12[13:08:16]bsp: Errno 0 bdb_errno 0
103-08-12[13:08:16]bsp:
103-08-12[13:08:16]bsp: dbs_errno = 0Error 4114 occurred:
103-08-12[13:08:16]bsp: Error ORA-3114 occurred during execute.
103-08-12[13:08:16]bsp: ORA-03114: not connected to ORACLE
103-08-12[13:08:16]bsp:
103-08-12[13:08:16]bsp: Error BDB-4114 returned.
103-08-12[13:08:16]bsp: Info: peo 0, sql 4, oci 4, warn 0, osd 0, rpc 0
103-08-12[13:08:16]bsp: See fatal SQL statement in '/opt/prod/BAAN42/bse/log/log.ora.sql'.
103-08-12[13:08:16]bsp: Flushed at ora_cursor.c $ $Revision: /main/bugfix6.1b/3 $ : #541.
103-08-12[13:08:16]bsp: ********** E N D of Log message **********
103-08-12[13:08:16]bsp:
103-08-12[13:08:16]bsp: ******* S T A R T of Log message *******
103-08-12[13:08:16]bsp: Log message called from ora_native.c $ $Revision: /main/bugfix6.1b/2 $: #983 keyw
ord: Oracle Error
103-08-12[13:08:16]bsp: Pid 28920 Uid 205 Euid 205 Gid 201 Egid 201
103-08-12[13:08:16]bsp: user_type S language 2 user_name bsp tty ypb locale ISO88591/NULL
103-08-12[13:08:16]bsp: Errno 0 bdb_errno 0
103-08-12[13:08:16]bsp:
103-08-12[13:08:16]bsp: dbs_errno = 0Error 4114 occurred:
103-08-12[13:08:16]bsp: Error ORA-3114 occurred during commit.
103-08-12[13:08:16]bsp: ORA-03114: not connected to ORACLE
103-08-12[13:08:16]bsp:
103-08-12[13:08:16]bsp: Error BDB-4114 returned.
103-08-12[13:08:16]bsp: Flushed at ora_db.c $ $Revision: /main/6 $ : #139.
103-08-12[13:08:16]bsp: ********** E N D of Log message **********
103-08-12[13:08:39]bsp:
103-08-12[13:08:39]bsp: ******* S T A R T of Log message *******
103-08-12[13:08:39]bsp: Log message called from ora_native.c $ $Revision: /main/bugfix6.1b/2 $: #983 keyw
ord: Oracle Error
103-08-12[13:08:39]bsp: Pid 28920 Uid 205 Euid 205 Gid 201 Egid 201
103-08-12[13:08:39]bsp: user_type S language 2 user_name bsp tty ypb locale ISO88591/NULL
103-08-12[13:08:39]bsp: Errno 0 bdb_errno 0
103-08-12[13:08:39]bsp:
103-08-12[13:08:39]bsp: dbs_errno = 0Error 4114 occurred:
103-08-12[13:08:39]bsp: Error ORA-3114 occurred during execute.
103-08-12[13:08:39]bsp: ORA-03114: not connected to ORACLE
103-08-12[13:08:39]bsp:
103-08-12[13:08:39]bsp: Error BDB-4114 returned.
103-08-12[13:08:39]bsp: Info: peo 0, sql 4, oci 4, warn 0, osd 0, rpc 0
103-08-12[13:08:39]bsp: See fatal SQL statement in '/opt/prod/BAAN42/bse/log/log.ora.sql'.
103-08-12[13:08:39]bsp: Flushed at ora_cursor.c $ $Revision: /main/bugfix6.1b/3 $ : #541.
103-08-12[13:08:39]bsp: ********** E N D of Log message **********
103-08-12[13:08:39]bsp:
103-08-12[13:08:39]bsp: ******* S T A R T of Log message *******
103-08-12[13:08:39]bsp: Log message called from ora_native.c $ $Revision: /main/bugfix6.1b/2 $: #983 keyword: Oracle Error
103-08-12[13:08:39]bsp: Pid 28920 Uid 205 Euid 205 Gid 201 Egid 201
103-08-12[13:08:39]bsp: user_type S language 2 user_name bsp tty ypb locale ISO88591/NULL
103-08-12[13:08:39]bsp: Errno 0 bdb_errno 0
103-08-12[13:08:39]bsp:
103-08-12[13:08:39]bsp: dbs_errno = 0Error 4114 occurred:
103-08-12[13:08:39]bsp: Error ORA-3114 occurred during commit.
103-08-12[13:08:39]bsp: ORA-03114: not connected to ORACLE
103-08-12[13:08:39]bsp:
103-08-12[13:08:39]bsp: Error BDB-4114 returned.
103-08-12[13:08:39]bsp: Flushed at ora_db.c $ $Revision: /main/6 $ : #139.
103-08-12[13:08:39]bsp: ********** E N D of Log message **********
103-08-12[13:08:42]bsp:
103-08-12[13:08:42]bsp: ******* S T A R T of Log message *******
103-08-12[13:08:42]bsp: Log message called from ora_native.c $ $Revision: /main/bugfix6.1b/2 $: #983 keyw
ord: Oracle Error
103-08-12[13:08:42]bsp: Pid 28920 Uid 205 Euid 205 Gid 201 Egid 201
103-08-12[13:08:42]bsp: user_type S language 2 user_name bsp tty ypb locale ISO88591/NULL
103-08-12[13:08:42]bsp: Errno 0 bdb_errno 0
103-08-12[13:08:42]bsp:
103-08-12[13:08:42]bsp: dbs_errno = 0Error 2041 occurred:
103-08-12[13:08:42]bsp: Error ORA-1041 occurred during close cursor.
103-08-12[13:08:42]bsp: ORA-01041: internal error. hostdef extension doesn't exist
103-08-12[13:08:42]bsp:
103-08-12[13:08:42]bsp: Error BDB-2041 returned.
103-08-12[13:08:42]bsp: Flushed at ora_cursor.c $ $Revision: /main/bugfix6.1b/3 $ : #1284.
103-08-12[13:08:42]bsp: ********** E N D of Log message **********

If you have any suggestions I would like to hear them. The other thing was a bit of confusion on the Oracle client path. In my tabledef6.1 I just left it as the Oracle7 home as before. But the listener is the Oracle8 listner.

The baan environment and oracle database are on the same system.

If you need more information from me let me know.

Thanks,

Mark Philpott
Baan Admin
The Boeing Company

Hi Mark,

your setup sounds right. Unfortunately the error message does not make much sense. If you can login and see the menu, then normally Baan allready accessed successfully the database.

Can you please post:

a) tabledef6.1
b) compnr6.1
c) listener.ora/sqlnet.ora/protocol.ora/tnsnames.ora
d) your environment before you start Baan

I will try to take a look at it.

Do you get the error, when starting a session/displaying data or writing data?

Regards

Markus

Hi all,

hmmm, i remember i had seen this problem.
Are you sure, that you are working with the correct oracle driver (ora8_srv6.1) ?
Please check the entry in tabledef6.1.
Do you run the script ora_update under $BSE/bin ?


Martin

Hi Martin,

In his current setup, he should NOT (!) work with the ora8 driver.

He is accessing the database via the oralce7 SQL-Net client, so he has to use the ora7 driver.

Example:

ORACLE_HOME=/oracle/product/7.3.4
TWO_TASK=baan


the tnsnames.ora in $ORACLE_HOME/network/admin must point to the local host.

the listener.ora in /oracle/product/8.1.7/network/admin for the oracle 8 listener, must specify the oracle8 HOME!

Looks confusing. But just imagine oracle and baan to be on different servers and the setup is the same.

Regards

Markus

Hi Markus,

you are right.
So let us wait for tabledef6.1

BTW, the ORA-03114 error also occurs, if the kernel paramter setting for oracle 8 is not ok. (so you could run in this Siutation, that a login to baan is possible, but sql-statements to other table are not working)

@mark
please post also the log.ora.sql from $BSE/log and check the oracle alert-file.

Nevermind. The errors had been due to database conversion errors. We executed a 2nd conversion and it fixed everything. It now works just fine in our current configuration. That is:

Old portingset pointing at Oracle 8 via sqlnet with the database residing locally.

Any gotcha's using this config that are not obvious?

Thanks for the info.

Mark

Good day,

We are looking at moving our database from 7.3.4 to 8.1.7. Our configuration is

oracle 7.3.4
portset 6.1b.03.03
BaanIVa
HPUX 11.11

Has anyone done this with succ? Is there any reason why we couldn't just upgrade oracle and leave baan alone? What is the suggested method? Do you have to purchse the extensions?

We don't use the DBA module, all maint in done outside of baan other than adding new scripts, reports, forms and table changes.

I would appreciate and advice on this matter.

Thanks,

Mark


Hi,

I´m problem with message "Error ORA-3114 occurred during commit and ORA-03114: not connected to ORACLE and dbs_errno = 0, Error 522 occurred"

This error is happening after we migrated to Oracle 9 g, BaaN is suing and always returns to the beginning of select as if you were entering the function again, if I run the commit transaction for each changed record or rendered non of the error.

I don't know where to look for or where to parameterize but all indications are that either parameter or configuration problem.

I look forward to return.

Grateful.

Morpheus