According to this article, http://resources.arcgis.com/en/help/main/10.1/index.html#/ST_Transform/006z0000009s000000/, to apply file-based CRS transformation in using sde.st_transform function, need to copy the ArcGIS pedata folder to the database server and setup environmental variable PEDATAHOME on the database server. It gives an example for databases on Windows. I am wandering if anybody has done this for SDE database on Linux and what else needs to be done. Does the database instance needs to be rebounced or the listener needs some extra configuration?
The process should be the same, but setting environment variables can't be done
at a server level in Unix, and some of the newer Oracle releases seem to clear the
environment to avoid security pitfalls, so you need to make sure PEDATAHOME is
being set correctly (before the service start request), and that it's still available
when necessary (might need to be set explicitly in the listener files).
You will certainly need to restart the listener; the need for a database bounce
is less likely. Unfortunately, you can't prototype all possible problems as thought
experiments -- At some point you need to try it in your dev server, and see how
it works out.