How to change protocol with Baan?
Baan IVc4
Oracle 8.0.5 HP/UX 11 L3000

I have changed two_task to oracle_sid but this is not enough.
Is tnsnames.ora needed any more?

For connections based of ORACLE_SID instead of $TWO_TASK, you should unset TWO_TASK (so not defined at all) and other Baan resources that set $TWO_TASK automatically.

Anthon

We have several sites working on beq (8i). Now i'm building 9.2.0.5 Oracle and trying to get it work with beq. Baan is IVc4,

Do you agree that beq doen't need tnsnaes.ora, listener.ora at all?

I can't make it work. sqlplus is working with beq, so it means that protocol is working...and without beq defined in tnsnames.ora and listener.ora.

TCP is of course working. But when I take tnsnames away it stops working (error 510). Oracle_local_template is defined and oracle_sid also tested without success.

Maybe I just need to add beq-values to both .ora's, but I think it should not be so...

Hi makiju,

What's not working about it? what errors are you getting?

Are the app and DB on the same box?
What's your tabledef6.x and db_resource look like now?


Dave

Porting set: 6.1c.07

# cat db_resource
ssts_set_rows:25
dbsinit:021
ora_init:0101000
lock_retry:0
ora_timeout:{0,60,60,60,0}
retained_cursors:20
max_free_cursors:32
bdb_max_session_schedule:4
rds_full:2
ora_max_array_fetch:2
nls_lang:american_america.we8iso8859p1
nls_sort:binary
ora_default_tablespace:dat
ora_temporary_tablespace:temp
oracle_home:/oracle/920
oracle_client_home:/d1/bse/lib/ora/oracle_home
oracle_local_template:baan
#oracle_sid:baan

********
tabledef:

# cat tabledef6.1
cpcom000:*:oracle8:Y
cprpd000:*:oracle8:Y
pspmg000:*:oracle8:Y
tccom000:*:oracle8:Y
tccom999:*:oracle8:Y
tcedi000:*:oracle8:Y
tcmcs000:*:oracle8:Y
tcmcs002:*:oracle8:Y
tcmcs095:*:oracle8:Y
tdcms000:*:oracle8:Y
tdilc000:*:oracle8:Y
tdinv000:*:oracle8:Y
tdltc000:*:oracle8:Y
tdpst000:*:oracle8:Y
tdpur000:*:oracle8:Y
tdrpl000:*:oracle8:Y
tdsls000:*:oracle8:Y
tdsls600:*:oracle8:Y
tdsmi000:*:oracle8:Y
tdsst000:*:oracle8:Y
tfacp000:*:oracle8:Y
tfacr000:*:oracle8:Y
tfcal000:*:oracle8:Y
tfcmg000:*:oracle8:Y
tffas001:*:oracle8:Y
tffas002:*:oracle8:Y
tffst000:*:oracle8:Y
tfgld003:*:oracle8:Y
tfgld004:*:oracle8:Y
tfgld450:*:oracle8:Y
tgeis000:*:oracle8:Y
tibom000:*:oracle8:Y
ticpr000:*:oracle8:Y
ticrp000:*:oracle8:Y
tiedm000:*:oracle8:Y
tihra000:*:oracle8:Y
tiitm000:*:oracle8:Y
timps000:*:oracle8:Y
timrp000:*:oracle8:Y
tipcf000:*:oracle8:Y
tipcs000:*:oracle8:Y
tirou000:*:oracle8:Y
tirpt000:*:oracle8:Y
tisfc000:*:oracle8:Y
tpbop000:*:oracle8:Y
tphrs000:*:oracle8:Y
tpism000:*:oracle8:Y
tppbs000:*:oracle8:Y
tppdm000:*:oracle8:Y
tpppc000:*:oracle8:Y
tpprc000:*:oracle8:Y
tppss000:*:oracle8:Y
tpptc000:*:oracle8:Y
tracs000:*:oracle8:Y
trcde000:*:oracle8:Y
trdrp000:*:oracle8:Y
trecs000:*:oracle8:Y
trhec000:*:oracle8:Y
trtcd000:*:oracle8:Y
trtco000:*:oracle8:Y
trtoc000:*:oracle8:Y
trtop000:*:oracle8:Y
trtrc000:*:oracle8:Y
trwoc000:*:oracle8:Y
tssma000:*:oracle8:Y
tuxch001:*:oracle8:Y
*:*:oracle8:N

***********
host mode. HP-UX 11.11 PA-RISC

Problem is ORA-510....login not possible without tnsnames.ora

Why are you using oracle_local_template instead of
oracle_sid?

If you use oracle_sid, baan will use beq internally..

Dave

oracle_sid is "older" version with Baan. Both settings are ok.

I think with oracle_local_template you have to build the whole connect string. (like it would show up in your tnsnames.ora).

Does it work with oracle_sid set?

Dave

Thanks Dave, oracle_sid worked. Now it's working without beq defined anywhere. There must have been some other problem when I tested last time with oracle_sid.