Hi,

We can not connect to Baan on GUI mode to our server but can connect using ASCII.

What must be something wrong.

The following are the server configuration:

Baan version: BaanIVc4
OS: HPUX 10.2
Database: Oracle 8
Porting set : 6.1c.06.02
BW: B40.58
Service Packs : SP8

Also, log.oracle8 reports error ORA-011034 - ORACLE not available, and error Logon failed; errno 510- Database is not on.

I think the problem is in Oracle, there must be something in this driver that was not installed. I already encountered this error before (its been a long time ) but I forgot the exact term in Oracle.

Please help.

Your immediate feedback is greatly appreciated.

regards,

julia

Check the $BSE/lib/tabledef6.1, if there the ORACLE_SID is defined.

Martin

Go into ttaad4110m000 and check if in the parameter field for you database you have defined at least the parameters ORACLE_HOME=<your_path_here>,ORACLE_SID=<SID_here>
If not, add them and convert to runtime.

Hi,

ORACLE SID is already configured in parameters for Maintain Database Definition. If this does not exist , you can not login to Baan in ASCII. But our problem is only on connecting to Baan on GUI mode. What must be missing interface?

please help.

thanks,

julia

Julia,

What user are using to connect with ba6.1? The same user account or another one?

What you should do is to check all the environment settings that are active for this user. There must be an ENV setting that is set in the UNIX environment which is not set properly for GUI users.

Typical forgotten settings in Oracle C/S environments are:
TNS_ADMIN
TWO_TASK - or - ORACLE_SERVICE_NAME

To track it faster, can you please post:

- the full line of the Parameter field of the session ttaad4110m000
- a few lines of your $BSE/lib/tabledef6.1 file (so that we see the parameters also at RTDD)
- the .profile of one user working in ba but not on bw
- what settings that user uses on the BW (what is used under the bshell part)

cpcom000:*:oracle8(ORACLE_HOME=/oracle8/app, ORACLE_SID=baan):Y
cprpd000:*:oracle8(ORACLE_HOME=/oracle8/app, ORACLE_SID=baan):Y
pspmg000:*:oracle8(ORACLE_HOME=/oracle8/app, ORACLE_SID=baan):Y
tccom000:*:oracle8(ORACLE_HOME=/oracle8/app, ORACLE_SID=baan):Y
tccom999:*:oracle8(ORACLE_HOME=/oracle8/app, ORACLE_SID=baan):Y
tcedi000:*:oracle8(ORACLE_HOME=/oracle8/app, ORACLE_SID=baan):Y
tcmcs000:*:oracle8(ORACLE_HOME=/oracle8/app, ORACLE_SID=baan):Y
tcmcs002:*:oracle8(ORACLE_HOME=/oracle8/app, ORACLE_SID=baan):Y

Hi Julia,

Like Patrick says, its most likely TNS_ADMIN, TWO_TASK or ORACLE_SERVICE_NAME thats not set correctly.

Test logging in thru BW by entering the variables for Oracle within the BW parameter field [-- -set ...=...].

When it is working, update your Parameter field under Maintain Database Definitions with the correct parameter, convert to runtime and it will work for ASCII & BW as well then.

Hi,

We have already set the TNS_ADMIN variable but still we can not connect using GUI.

Should we define ORACLE environment in our user profile?

Any recommendations/suggestions is greatly appreciated.

regards,

julia

Julia,

I don't have a clue what's missing. However by using a wrapper script around the bshell you probably can find out what environment settings are missing.

That the only thing that's came up with me.

Rgrds,
Han

hi,

what do you mean by wrapper script?

do you have sample source code of this?

thanks,

julia

Build a unix script (test_bshell.ksh, put it on $BSE/bin, do a chmod 770 on it) that only does the following:
#!/usr/bin/ksh
echo "Check environment variables" >> /tmp/test_bw-env.log
env >> /tmp/test_bw-env.log

Then edit your $BSE/lib/ipc_info file and add the following line:
test_bshell s 0 0 p ${BSE}/bin/test_bshell.ksh

Then login using yout BW by adding the following in your bshell name field:
test_bshell

This will not do anything, will start instead of the bshell, that script, and that script writes the current environment variables into /tmp/test_bw-env.log
Check that file to know what environment variable is missing, compare with the 'env' output from a user that can login using the ba6.1

hi guys,

thank you very much for all your response!

by the way, we can now use Baan gui. The only problem is the SPACE (ORACLE_HOME=/oracle8/app, ORACLE_SID=baan) in the Field Parameter on session Maintain Database definition.

God bless you all!

julia