hi,

when we are trying to log in after upgrading from oracle 9i to 10g , we are getting following error :

error 7413 (bdb error 7413) on select.

After upgradation, oracle_home path was changed and we have already changed the oracle_home path in tabledef6.1 and table ttaad410.

Also we are able to log into oracle using bsp and root users.

kindly suggest how to resolve the issue.

Thanking you in advance,
Anil

Hi,

did you use the pipes protocol in your ipc_info file?
If yes you have to switch to the sockets protocol.
Please check Infor solution 200328.

Regards,
Juergen

Hi Anil,

The error corresponds to ORA-06413 (http://download.oracle.com/docs/cd/B19306_01/server.102/b14219/e4100.htm#ORA-06413).

This might be relevant: http://www.baanboard.com/baanboard/showthread.php?t=25934

Or this: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/ab662d63-6385-4f73-b27f-d526048f601f/

Or this: http://itknowledgeexchange.techtarget.com/itanswers/solution-for-ora-6413-error-showinh-connection-not-open/

Groetjes,
<><
Marnix

hi,

there are no pipes used in ipc_info file.

We have already tried this solution. After changing ipc_info file we are getting error 510 : database not on.


Thanks,

Anil

hi,

Thanks for the reply.

The oracle bug is when you connect from windows application you get this error. but in our case the os in unix and still i am getting the error.

Earlier we had oracle 9i 64 bit and it was working fine. but now it is not working. not able to find out the reason.

please suggest.


Thanks,

Anil

let's see your log.oracle8, tabledef6.x and db_resource

Dave

hi Dave,

please find attached the following files as required by you:

1> tabledef6.1
2> log.oracle8
3> db_resource


Thanks,
Anil

Howdy.

So Baan and Oracle are on the same machine, correct?

what happens if you change from ORACLE_SID to ORACLE_SERVICE_NAME or TWO_TASK in your tabledef6.1 ?

I'm inclined to agree with Juergen, although I couldn't find the solution he referenced.

Can you post your ipc_info file as well?


Also as a side note, us7ascii is gone in 11g. so you may want to start the process of changing to a more modern character set like we8iso8859p1

Dave

hi dave,

yes oracle and baan are installed on same machine. Right now we are not planning to upgrade to oracle 11g.

please find attached ipc_info file as required by you.

Also i have changed ORACLE_SID to ORACLE_SERVICE_NAME and TWO_TASK in tabledef6.1 file. then the error changes to 510 : database not on.


Thanks,

Anil

you will eventually want to get to 11g since i'm sure 10g is almost unsupported.

so yes it does look like Jurgen was correct:
your ipc_info has:
oracle8 s 302 320 p ${BSE}/bin/ora8_srv6.1

Where mine has:
oracle8 s 0 0 s ${BSE}/bin/ora8_srv6.1

the "p" is the pipes he was talking about.

Dave

hi Dave,

I have already tried this option. But still i was not able to connect to data base. i have tried by removing the p and replacing with 0,0.

Then error was : error 510 : database not on.

I would like to inform you that our porting set is very old could that be the reason?

OS : IBM AIX 5.3 and porting set 6.1c.07.06.

Thanking you,
Anil

hi ,

When i changed the line in ipc_info file as suggested in infor solution 200328 and tried to run baan it give following error :

Received from ipc_boot: 'remote bshell path '/app/baan4c4/bse/bin/bshell6.1' not executable'
failed to connect to 141.86.185.27!bshell

Thanks,

Anil

Dear all,

Thanks a lot for your inputs. The problem has been solved.

we had made following changes :

First, upgraded porting set from 6.1c.07.06 to 6.1c.07.16 and changed the ipc_info file as mentioned in solution 200328 and changed login method from rexec to baanlogin to solve the issue.

Once again thanks a lot to all of you for your support

Anil

Why are you still using that pretty old portingset?

hi,

the porting set 6.1c.07.16 which we have installed has been recommended by infor. We are using Baan 4 SP27. Which portingset we should use now?


Thanks,
Anil

did you test ORACLE_SERVICE_NAME instead of ORACLE_SID?, check ora_storage to be sure your are using the correct tablespaces