Our BaanIVc4/Oracle9i is currently running on an HPUX11i machine. We want to have the same copy of our production server to an AIX5.3.3. What would be the approach to do that? Your help will be very much appreciated.

Thanks in advance.

Gelyne

Your smiley indicates, that you do not like this decision. I sympathize and agree, even though HP is loosing several deals at the moment to IBM.

Anyway here is the procedure:

a) Copy Baan (mainly $BSE) to AIX
b) Replace Portingset
c) Install Oracle on AIX
d) Export Data on HP-Ux
e) Recreate Users and roles in Oracle on Aix
f) Import Data on Aix
g) Revalidate Baan

That's it. Pretty staright forward. Obviously you will need to care of some nitty gritty details, like Oracle settings, printers, etc.

Regards

Markus

You mean, no need to install baan anymore? Have you tested or experienced the procedure already? I thought you could only do that for the sam operating system?

Thanks again.
Gelyne

I did excactly the same a couple of times, but in the past always from other systems to HP-Ux. I migrated systems from Digital to HP and from Sinix to HP. No need to reinstall on a Unix platform, just copy.

It is a different story on Windows. Here you want to reinstall at least a so called fat client to get the registry entries for the services etc.

On Unix it works like a charm. Copy it over, adjust your kernel to be Baan suited, replace the Portingset and you are ready to go.

The only thing you can not just copy over is the actual oracle data files. An Oracle data file on Hp-Ux is not compatible to Aix. So you need to go via export/import.

Regards

Markus

Thanks again.

My porting set is already 6.1c.07.05 (almost updated). Do i still have to replace it? How's the procedure of replacing it, the usual way of updating porting set or there are other ways?

Regrds,
Gelyne

The portingset is the one component of a Baan installation, which is platform dependent, so yes, you have to change it, independent of the version.

The process is the same as usual. Even though if you are not familiar with this "low" level of Baan, then you might search for external help.

Actually I had unfortunately a similar case of IBM snapping up a HP customer and actually IBM paid somebody to get this done in order to win the customer.

it's easy, but let them carry the burden! If your IBM rep canm not provide a person to do the job, then this should make you think twice, wether they know what they talk about in regards to Baan.

Regards

Markus

Hi Markus,

I followed your procedure and now i'm experiencing error 510 (Database not On). Did i miss something? The error log goes something like this:
2006-06-08[16:28:26]:E:bsp: ******* S T A R T of Error message *******
2006-06-08[16:28:26]:E:bsp: Log message called from /view/port.6.1c.07.05/vobs/t
t/servers/ORACLE_2/oci_shlib.c: #333 keyword: OCI error
2006-06-08[16:28:26]:E:bsp: Pid 528588 Uid 125 Euid 125 Gid 125 Egid 125
2006-06-08[16:28:26]:E:bsp: user_type S language 2 user_name bsp tty 4 locale IS
O88591/NULL
2006-06-08[16:28:26]:E:bsp: Errno 2 (No such file or directory) bdb_errno 0
2006-06-08[16:28:26]:E:bsp:
2006-06-08[16:28:26]:E:bsp: dbs_errno = 510Error 510 occurred:
2006-06-08[16:28:26]:E:bsp: Could not load shared Oracle library
2006-06-08[16:28:26]:E:bsp: path = /baan/usr/bse/lib/ora/oracle_home/lib
2006-06-08[16:28:26]:E:bsp: library = libclntsh.a [ libclntsh.a(shr.o) ]
2006-06-08[16:28:26]:E:bsp: alternative library = libclntsh.so [ libclntsh.so(sh
r.o) ]
2006-06-08[16:28:26]:E:bsp: Flushed at /view/port.6.1c.07.05/vobs/tt/servers/ORA
CLE_2/oci_shlib.c : #350.
2006-06-08[16:28:26]:E:bsp: ******* E N D of Error message *******

Just wanna know if your familiar with the error. I already explore the error 510 here and it seems no similar situation like mine.

Thanks in advance.

Gelyne

Hi there,

unfortunatrely I know the error, but it might have several causes. The actually interesting error message is:

Could not load shared Oracle library


Oracle works with shared libraries, which the client process is loading at connection time. This is a bit of an ugly topic. The library in question is "libclntsh.a" and the path it is looking at is "/baan/usr/bse/lib/ora/oracle_home/lib".

As you notice this is not an oracle directory, so the oracle library will not be there.

If you are lucky, then you can solve this by typing: "ora_update". This script is part of the portingset and copies the "required support files" of oracle to the right destination.

If this does not help, then you better start working on some environment variables, which influence the search part of the dll loader. Unfortunately I can not help you here much, as this is OS dependent. Sometimes the variable is called "LIBPATH", sometimes it is called SHLIB_PATH. You will find this in the OS specific documentation of your oracle version.

But I think you are on the right track,

Markus

In 6.1c.07.10 Baan doesn't deliver it's own client libs, you have use oracle's

so ora_update will remove $BSE/lib/ora/oracle_home and update the db_resource to point to the real $ORACLE_HOME

that may solve the problem.

also "relink all" as oracle (with oracle down) may help as well.

otherwise you may need to make sure you're LIBPATH is set so that you're pulling the $ORACLE_HOME/lib32 instead of $ORACLE_HOME/lib (assuming you installed 64 bit oracle.)

Dave

fyi...
If you are lucky, then you can solve this by typing: "ora_update". This script is part of the portingset and copies the "required support files" of oracle to the right destination.

>cat ora_update
#!/bin/sh

# Since 7.2 the Oracle driver is using oracle shared libraries.
# This script is not needed anymore

exit 0

that's just for you fancy ERP LN folk..

Baan 4 and 5 do it like i described above.

Dave

after doing the the ora_update(as root) and relink all (as oracle while dbase is shutdown), the error upon logging in to baan is:

2006-06-09[09:25:39]:E:root: ******* S T A R T of Error message *******
2006-06-09[09:25:39]:E:root: Log message called from /view/port.6.1c.07.05/vobs/
tt/servers/ORACLE_2/ora_native.c: #2067 keyword: Oracle Error
2006-06-09[09:25:39]:E:root: Pid 319704 Uid 0 Euid 0 Gid 0 Egid 0
2006-06-09[09:25:39]:E:root: user_type S language 2 user_name root tty 1 locale
ISO88591/NULL
2006-06-09[09:25:39]:E:root: Errno 0 bdb_errno 0
2006-06-09[09:25:39]:E:root:
2006-06-09[09:25:39]:E:root: dbs_errno = 0Error 510 occurred:
2006-06-09[09:25:39]:E:root: Error ORA-12154 occurred during logon.
2006-06-09[09:25:39]:E:root: ORA-12154: TNS:could not resolve service name
2006-06-09[09:25:39]:E:root:
2006-06-09[09:25:39]:E:root: Error BDB-510 returned.
2006-06-09[09:25:39]:E:root: Check the Oracle settings:
2006-06-09[09:25:39]:E:root: NLS_LANG = 'American_America.us7ascii'
2006-06-09[09:25:39]:E:root: ORACLE_HOME (client) = '/oracle9i/product/9.2.0' (r
esource oracle_client_home)
2006-06-09[09:25:39]:E:root: ORACLE_HOME (server) = '/oracle9i/product/9.2.0' (r
esource oracle_server_home)
2006-06-09[09:25:39]:E:root: Oracle Service Name = 'MAXX' (resource oracle_servi
ce_name --> TWO_TASK)
2006-06-09[09:25:39]:E:root: TWO_TASK = 'MAXX'
2006-06-09[09:25:39]:E:root: ORACLE_SID = 'maxx' (ignored)
2006-06-09[09:25:39]:E:root: Logon failed; errno 510
2006-06-09[09:25:39]:E:root: Flushed at /view/port.6.1c.07.05/vobs/tt/servers/OR
ACLE_2/ora_driver.c : #227.
2006-06-09[09:25:39]:E:root: ******* E N D of Error message *******

the behaviour of listener.ora and tnsnames.ora are very inconsistent. I've done all the possible modifications and restart the listener but still the listener hungs and never start. Anyone who encountered the same problem in AIX? ou inputs will be very much appreciated. Thanks

Gelyne

Is the database on the same box as the application? if so, why are you setting TWO_TASK?

regardless you should use ORACLE_SERVICE_NAME if you are in a 2 tier setup. if you're in a 1 tier setup (which it looks kind of like you are..) you should use ORACLE_SID and not use a listener at all.

Dave

I dont remember i set it up that way... where can i find that TWO_TASK, ORACLE_SERVICE_NAME setup you've mentioned? :confused: I'm really lost...

Thanks
Gelyne

Well - before we worry about those things.

Is your database on the same server as Baan? or is on a different server?

Dave

they are on the same server.

Regards,
Gelyne

ok. you need to find where you set TWO_TASK and unset it then.

could be in your unix profile
/etc/profile
~/.profile
$BSE/lib/tabledef6.1
$BSE/lib/defaults/*

Dave

yes they are on the same server...

regards,
gelyne

i really checked and remembered very well that i did not setup the TWO_TASK parameter. what else should be the other reason for that? i already raised it with oracle but until now, the haven't responded yet.

tnx,
Gelyne

Don't know

Do you have oracle_service_name set?

2006-06-09[09:25:39]:E:root: Oracle Service Name = 'MAXX' (resource oracle_servi
ce_name --> TWO_TASK)
2006-06-09[09:25:39]:E:root: TWO_TASK = 'MAXX'
2006-06-09[09:25:39]:E:root: ORACLE_SID = 'maxx' (ignored)

Dave

The Problem with Baan environments is, that you can define at many places environment variables. And instead of choosing one central location, many Baan customers have them actually defined often with different values in several locations.

Here a list of locations, which might help you, but is most likely not complete:

a) central profile: /etc/profile
b) user specific profile (depends on shell used)
c) $BSE/lib/tabledef6.1
d) in any file in $BSE/lib/defaults
e) in $BSE/lib/env.local (not 100% sure about that name though)
f) in a so called bshell wrapper. Check $BSE/lib/ipc_info where the entry bshell is pointing to, then check wether this is the origional baan binary or a script.

As I said, there might be even more ...

My clear preference is number (f) and remove all settings from the rest.

Regards

Markus

Thanks for all your input. I did re format the server and try the same procedure again. I'll see if i'll encounter the same problem again. I'll update the forum as soon as i'm done.

Regards,
Gelyne