Hi,

BaanIVc4 configuration client/server.

appserver - AiX 4.3 - App server - portingset 6.1c.07.03
dbserver1 - AIX 4.3 Oracle 8.0.5 - DB server (SID=tools and SID=prod1)
dbserver2 - AIX 4.3 Oracle 8.0.5 - DB server (SID=prod2 and SID=teste)

Tabledef6.1:

*:000:oracle8(ORACLE_HOME=/u01/oracle/product/8.0.5,ORACLE_SID=tools.dbserver1,TWO_TASK=tools.dbserver1):

N

*:*:oracle8(ORACLE_HOME=/u01/oracle/product/8.0.5,ORACLE_SID=prod1.dbserver1,TWO_TASK=prod1.dbserver1):N

*:400:oracle8(ORACLE_HOME=/u01/oracle/product/8.0.5,ORACLE_SID=teste.dbserver2,TWO_TASK=teste.dbserver2):

N

*:410:oracle8(ORACLE_HOME=/u01/oracle/product/8.0.5,ORACLE_SID=prod2.dbserver2,TWO_TASK=prod2.dbserver2):

N

db_resource:

dbsint:021
rds_full:2
ora_init:0111000
lock_retry:0
ora_max_array_fetch:2
ora_max_array_insert:400
ora_timeout:{999,999,999,999,999}
epc_disable=true
nsl_lang:american_america.we8dec
nsl_sort:binary
ora_column_format:7

With these configurations I have no connections problems thru the appserver to all DB in dbserver1 an
dbserver2. As all production companies(prod1/prod2) have the same package combination, all users can

change company in the application.

Question:
I want use the new approach, defining in db_resource file the parameters for oracle connections.

1-Which parameters must I add to my db_resource file, maintaining the same functionality?

2- It is necessary one db_resource file for each DB ? If so, how can tell in users BW wich db_resource file

must be use?

3-Parameter - oracle_client_home:$BSE/lib/ora/oracle_home - I have not this directory.Which the utility

4- To configure the tnsnames.ora, must I use the oracle_local_template ?

Thanks for all information

Rui Goncalves

I want use the new approach, defining in db_resource file the parameters for oracle connections.


Why would you possibly try to do this?
These are just variables, so as long as you assure that they are loaded before they are needed, you're ok (I don't remember the load order, there are some posts on the subject). However, any given process might refer to the designated location to retrieve this information.
The bottom line is that its hard to tell what will break but there is a good chance that something will.

Question:
1-Which parameters must I add to my db_resource file, maintaining the same functionality?


tns_admin


2- It is necessary one db_resource file for each DB ? If so, how can tell in users BW wich db_resource file must be use?


You cannot do this.


3-Parameter - oracle_client_home:$BSE/lib/ora/oracle_home - I have not this directory.Which the utility


depends on what porting set. newer Baan 5 porting sets do not need
that. if you run $BSE/bin/ora_update it will either create or remove it, based on what is needed.


4- To configure the tnsnames.ora, must I use the oracle_local_template ?


Nope! just use the standard sqlnet stuff.


Overall, your best bet is to do the following

db_resource:
tns_admin:/path/to/tnsnames.ora

tabledef6.x
<table>:<company>:oracle8(ORACLE_SERVICE_NAME=<servicename>):N

and that's as close as you're going to get to what you're trying to do.

Dave