Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
36%
Installation Wizard into new VRC
36%
Manual into existing VRC
7%
Manual into new VRC
22%
Total votes: 45

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 17th June 2003, 16:55
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
Lightbulb BaanIVa upgrade to Oracle8

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
__________________
Mark...
Reply With Quote
  #2  
Old 17th June 2003, 17:08
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,165
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
Phil,

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

Quote:
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

Quote:
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.

Quote:
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.

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

Patrick Van der Veken - Admin & Founder - (c) 2001-2018 baanboard.com/baanforums.com
Reply With Quote
  #3  
Old 18th June 2003, 14:00
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Guru
 
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
got a problem there

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
Reply With Quote
  #4  
Old 18th June 2003, 14:57
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
Red face

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...
Reply With Quote
  #5  
Old 18th June 2003, 15:22
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,165
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
Mark, sorry for calling you Phil
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2018 baanboard.com/baanforums.com
Reply With Quote
  #6  
Old 12th August 2003, 21:09
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
Re: got a problem there

Quote:
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
Reply With Quote
  #7  
Old 13th August 2003, 08:00
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Guru
 
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
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
Reply With Quote
  #8  
Old 13th August 2003, 10:26
Martin Martin is offline
Senior Member
 
Join Date: Aug 2001
Location: Germany
Posts: 135
Martin is on a distinguished road
Baan: IVc, ERP5c - DB: oracle 9i, 10g, 11g - OS: Windows, HP-UX, SLES8/9/10/11
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
Reply With Quote
  #9  
Old 13th August 2003, 11:36
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Guru
 
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
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
Reply With Quote
  #10  
Old 13th August 2003, 12:17
Martin Martin is offline
Senior Member
 
Join Date: Aug 2001
Location: Germany
Posts: 135
Martin is on a distinguished road
Baan: IVc, ERP5c - DB: oracle 9i, 10g, 11g - OS: Windows, HP-UX, SLES8/9/10/11
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.
Reply With Quote
  #11  
Old 25th August 2003, 21:35
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
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
__________________
Mark...
Reply With Quote
Sponsored Links
  #12  
Old 7th February 2011, 18:05
Morpheusn Morpheusn is offline
Junior Member
 
Join Date: Feb 2011
Posts: 3
Morpheusn is on a distinguished road
Baan: Baan c4 - DB: Oracle 11g - OS: Unix HP
Quote:
Originally Posted by philpom View Post
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
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
Upgrade to Win2k kereni Operating Systems & Databases 3 7th February 2011 18:07
Upgrade strategy torwin Tools Administration & Installation 11 28th May 2003 15:47
problem installing baan IVc4 upgrade - user interface helpdeskchickie Tools Administration & Installation 2 21st April 2003 21:59
Security Upgrade: vbulletin v2.2.4 patvdv About Baanboard.com 1 22nd March 2002 09:06


All times are GMT +2. The time now is 11:09.


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