On our Baan environment the "$BSE/lib/tabledef6.1" file contains ORACLE_HOME settings which define the path is "/COMNFS/oracle....". This "/COMNFS/oracle..." directory is not available on the database servers BUT it is on the Application servers. The Oracle application is available locally on the Database servers and our Batch jobs are run on the database servers.

On the database server the variable ORACLE_HOME is set in the batch users .profile to "/usr/app/oracle/product/8.1.7" which does exist. I assume that the ORACLE_HOME setting is being picked up from this rather than the tabledef6.1.

Does any one know if the users environment settings overule the tabledef6.1 settings ?

Are there any more ways of defining the ORACLE_HOME setting and what is the order of precedence ?

Are there any performance issues relating to where the ORACLE_HOME value is set ( i.e. in the .profile, tabledef6.1 etc ) ?

Inquiring minds need to know !! :-)

:confused:

ORACLE_HOME, ORACLE_SID, TWO_TASK, LOCAL, NLS_LANG, NLS_SORT and many other (Oracle) parameters can also be set in the $BSE/lib/defaults (varible in lower case and seperated by a column of its value like oracle_home:/app/oracle/product/8.1.7). In this way you can set up different envionments on different systems. It also reduces the size of the tabledef and makes the tabledef more readable.

The way of reading the variables (the more on top the higher priority):
- Envionment variables e.g. when setting in .profile and connecting with ASCII interface (NOT BW).
- bse_vars file
- tabledef6.1
- db_resource

As these viariables are only read when starting the driver the performance decrease of placing it in the one or other place is in most cases not noticable.

See also chapter 5 in Performance Tracing and Tuning Guide (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=7665)

Kind regards,
Dick