Because of a policy not to install "application software" on the database (Oracle 11g) machine, I am constrained to do a remote install of ArcSDE 10 from Windows (Server 2008) to Linux (Suse Enterprise - 64bit). We would like to use ST_Geometry. The ArcSDE 10 Oracle 11g (32 bit) sp 1 "installation" has been done on the Windows machine and the TNS Names file has been configured and I have confirmed that it connects to the Oracle 11g instance on the Linux machine. It also includes the "extproc" reference that will be needed to access the ST_Geometry library. Execute privileges have been granted to "public" on dbms_pipe, dbms_lock,dbms_utility,dbms_sql, and utl_raw and the "sde" user has been created with the required permissions. And, finally, I have my ArcSDE license file ready to go. In theory, I should be able to do the remote install. Has anyone tried this?
My questions are: Does the libst_shapelib.so (extracted from the Linux installation media) need to be on the Linux machine before the post_installation is run or can it be done after post_installation? And, what does the setup_st_geometry.exe in the sdehome bin directory do?
Any advise, tips, or warnings would be much appreciated.
Scott