Hi,

We are in the process of migrating BaanIV from HP-UX and Informix to IBM-AIX5.3 and Oracle9.

On executing the bdbpost6.1 command we are getting error 521 (This indicates that shared memory has not been loaded)
On starting the shared memory the error changes to 515 (This indicates a license error; probably an unpatched binary)

In the new environment, the Baan application and database will be on different servers.
Environment variables that have been set are are:

BSE=/eubaan02/app/bse
ORACLE_SID=EUBAAN2S
ORACLE_HOME=/baanCNLRDD01s/app/oracle/product/9.2.0
TNS_ADMIN=/var/opt/oracle
oracle_client_home:/user/app/oracle/product/9.2.0


We have performed the following steps:

1. Copy the Baan application from source server to target server.
All Baan directories have been copied (application, dict, lib, bin, etc, tools ...)

2. Export the 000 company on source server in pipe delimited form and copy the dump to the target server.

3. Porting set has been upgraded to 6.1c.07.15

4. The tabledef6.1 file has been updated as
*:000:oracle8(ORACLE_HOME=/user/app/oracle/product/9.2.0,ORACLE_SID=EUBAAN2S):N

We have also tried with the tabledef6.1 as
*:000:oracle8(TNS_ADMIN=/var/opt/oracle,TWO_TASK=EUBAAN2S.world):N

5. $BSE/etc/* files have been modified to reflect the change in BSE location

6. ora_users, ora_groups and ora_storage files have been created as follows:

#----------------------------------------------------------------------------
# U S E R S
# Please edit this file with the ora_maintain program or the ora_admin tool!!
#----------------------------------------------------------------------------
bsp:EUBAAN02_000:FPq}1Qt%SSV>YR8oC.9'M(zGET+_M51w:EUBAAN02_000
#----------------------------------------------------------------------------
# G R O U P S
# Please edit this file with the ora_maintain program or the ora_admin tool!!
#----------------------------------------------------------------------------
EUBAAN02_000:FPq}1Qt%SSV>YR8oC.9'M(zGET+_M51w
#----------------------------------------------------------------------------
# S T O R A G E
#----------------------------------------------------------------------------
*:000:T:group:0214:5:TABLESPACE EUBAAN02_DATA_000
*:000:I:group:0214:5:TABLESPACE EUBAAN02_INDX_000
#----------------------------------------------------------------------------

7. /var/opt/oracle/tnsnames.ora

EUBAAN2S.world =
(DESCRIPTION =
(SDU = 32767)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 159.82.226.26)(PORT = 1522))
)
(CONNECT_DATA = (SID = EUBAAN2S))
)


Please advise. Please let me know if any information is needed from me.

Thanks in advance.
Ayush

On starting the shared memory the error changes to 515 (This indicates a license error; probably an unpatched binary)

Did you validate Oracle database (commercial function t062)?

There are unfortunately several error in your procedure, some of them are related to the problems you see, some of them will show up errors later.

a) Do not use pipes as seperator for dumping company 000. Baan stores in some tools tables the form/report/menu layouts in binary format, but in String fields. These fields get corrupted if using pipe as a seperator.
At best use a big dump or if you need seperators use "^a".

b) You need to change the licence6.1 file to point to your local host.

c) You need to execute session "Patch objects after system crash" in tools->SW installation-> misc to get rid of your old validation

d) You need to revalidate your system by getting new codes from Baan


Good luck,

Markus

Did you validate Oracle database (commercial function t062)?

Small addition: above might also be your problem, in case you did not have Oracle on the HP-Ux already. In this case you might be forced to first upload the data of company 000 to tbase, validate your system (including oracle) and then move to Oracle as a DB.

From which DB platform are you coming?

Thanks a lot for your responses.

As suggested I have changed the licence6.1 file to point to the local host. The earlier errors (515, 521) are not coming.

Now on running bdbpost, I get the error 510 (This indicates that the database has not been started. Start the database to correct the problem).

The database is running. From the application server, I can connect to the database (located on another server) using SQLPlus. Please advise what parameter specification, I might have missed.

I have also started the dump of the 000 company without the separator.

The database on the source server is Informix.

Hmmm, if you were running informix before and did not have oracle licensed, then you should still get that unpatched binary error.


Anyway, at least your tabledef is also wrong. In your first posting, you specified:

ORACLE_HOME=/user/app/oracle/product/9.2.0,ORACLE_SID=EUBAAN2S

This is wrong, because this means the DB is locally. Or:

TNS_ADMIN=/var/opt/oracle,TWO_TASK=EUBAAN2S.world

This is wrong, because no Oracle Home is specified. You need to combine the two!

Regards

Markus

Thanks again for you help. After changing the tabledef6.1, bdbpost has worked. The tabledef6.1 entry that worked is:

*:000:oracle8(ORACLE_HOME=/user/app/oracle/product/9.2.0,TNS_ADMIN=/var/opt/oracle,ORACLE_SERVICE_NAME=EUBAAN2S.world):N

Now when we log into Baan and try to run any session (including patch objects after error solving), we are getting an error "Can't read session or object"

In the log file log.bshell the message logged is " bdb_errno 111 (No record found)"

I have checked for the location of the application components and permissions.

Please advise.

Hi,

can you post the complete log.bshell entry? Maybe there is even more than one?

I guess two things might happened:

a) You did not copy the complete bse
b) you changed the installation directory

There might be other reasons, but it is all guessing.

Are you using the ASCII or the GUI interface?

Markus

Hi Marcus,

The issues have been resolved.

The import of table ttadv999 was not proper. So exported and imported it again using ^a separator. After that I was able to patch the system and bring it in demo mode.

I have created the data companies and the import non tools data is now being done.

Greatly appreciate your inputs.

Thanks
Ayush

We have to migrate 4 instances of Baan. 3 of them have been migrated successfully and are running in demo mode.

For the 4th instance, when trying to log into baan (ba6.1), I am getting the error "You have no license anymore to start the bshell!" In the licence6.1 the entry is "localhost". This is the same in other instances.

I have checked the $BSE/log files and there is no message logged.

Please advise. Please let me know apart from licence6.1 what files/tables are referred by Baan for licensing purposes.

Did you execute session "Patch objects after system crash" in tools-->SW Installation->Misc on that instance?

I am not able to log into Baan. So cannot execute session "Patch objects after system crash". (I did that for the other instances).

One difference that I can see is that only in this instance in the path $BSE/lib/tbase there are the following files:
reginfo.bdt
reginfo.bid
tbase_open
tbase_param
tbase_reg
tbase_tp_param

In the other instances the files present are:
tbase_open
tbase_param
tbase_tp_param

I am not sure if the error is related to this.

Log into one of the working instances. Get the sessioncode and start baan directly with the session code.

Do all this in the ASCII interface and life will be much easier.

Whatever you have on tbase has nothing got to do with your topic (most likely).

Thanks again for your help. With "ba6.1 session code" I was able to log in, patch the application and create the company tables. Data upload for the companies is now is process.

With this, the pilot phase of the migration is drawing to a completion.

The thought of trying "ba6.1 session code" had come to me but I did not try it thinking that the license error would come.

Please let me know how is it that "ba6.1 session code" option by-passed the license error that was coming.

Thanks again for all the help provided.

Actually that specific session is outside the normal licensing behavior and can always be started.

In historic times you could start ba6.1 always and it would show you at least the menu (after giving a license warning). This way you could go to the session the normal way.

This behavior seems to be changing from Portingset to Portingset. In the GUI it never worked. Without the licenses the GUI does not allow to start the menu.

All in all a bit odd, but that how it is.

Regards

Markus