Hello,
We are using BaanLogin on Baan5c/Oracle9/AIX5.2.

Periodically (few times per week), we are facing a problem that new users are unable to login to Baan (while logged user works normally) , with message:
(Could not setup connection to port 7150): baanlogin failed on host ’192.168.10.241’ username bsp
Failure executing ipc_boot binary in ’/baanerp/bse’
After restarting Baan Login (blogin6.2) service, everythnig works fine.

Login over rexec protocol doesn't work at all, with message:
Error 510: Database not on

Why we can not use rexec protocol?

Baanlogin will pass on environment variables to the connecting bshell.

So for example, if the user that starts blogind6.1 has ORACLE_HOME set
then the bshell will also get that set as an environment variable.

rexec does not do this, so you need to make sure the settings in the tabledef6.1 and bse_vars and db_resource are all correct.

My guess is that one of those files is incorrect and you've never noticed because you're setting the correct values in /etc/profile.

In that setup ba6.1 works and so does blogind but not bw via rexec.

Dave

Thanks for the answer.
User root (that starts blogind6.2) doesn't have ORACLE_HOME set. I've checked tabledef, dbresource and it seems OK, only thing that I've noticed is that tabledef containd ORACLE_SID, but db_resource contains ORACLE_SERVICE_NAME. I've created bse_vars file because it didn't exist before, to be the same as db_resource, but problem still exist.

When login to Baan over rexec failed, Oracle log file shows:
dbs_errno = 0Error 510 occurred:
Error ORA-12154 occurred during logon.
ORA-12154: TNS:could not resolve service name
Error BDB-510 returned.
Check the Oracle settings:
NLS_LANG = 'slovenian_slovenia.ee8iso8859p2'
ORACLE_HOME (client) = '/oracle/app/oracle/product/9.2.0' (resource oracle_client_home)
ORACLE_HOME (server) = '/oracle/app/oracle/product/9.2.0' (resource oracle_server_home)
Oracle Service Name = 'baan' (resource oracle_service_name --> TWO_TASK)
TWO_TASK = 'baan'
ORACLE_SID = 'baan' (ignored)
Logon failed; errno 510

According to the log, Baan can not resolve the service name.

You might try to set the "TNS_ADMIN" variable to point to the directory on the server, where the tnsnames.ora is stored. Usually $ORACLE_HOME/network/admin.

Hey guys,

Has a resolution been found for this issue? We have just upgraded from Solaris 9 to Solaris 10 and since the upgrade Rexec does not work at all, and Baanlogin works only for some (super?) users.

Is rexec enabled?

most distros disable it by default for security reasons.

see if you can rsh into the machine.

Dave

Rexec is enabled as it always was. Also Baanlogin used to work fine for all users, and since the upgrade it doesn't.

I don't know how it works on Solaris, on AIX for instance you have to start rexecd daemon with option -c to prevent reverse name resolution or you have to have all clients listed in /etc/hosts file.
Regarding blogind I don't think that it's connected with user type (superuser or not), that is more likely network problem.