topic Re: The latest ST_GEOMETRY and dependent libraries need to be copied to the correct s in Data Management Questions https://community.esri.com/t5/data-management-questions/the-latest-st-geometry-and-dependent-libraries/m-p/375955#M21344 <HTML><HEAD></HEAD><BODY><SPAN>Do not copy anything from SDEHOME.&nbsp; The most recent libraries are part of the</SPAN><BR /><SPAN style="font-style:italic;">Desktop</SPAN><SPAN> unstall (under the Desktop10.1/DatabaseSupport/Oracle folder, as </SPAN><BR /><SPAN>described by the&nbsp; documentation).&nbsp; You should apply 10.1 SP1 before copying.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Tue, 18 Feb 2014 16:04:17 GMT VinceAngelo 2014-02-18T16:04:17Z The latest ST_GEOMETRY and dependent libraries need to be copied to the correct softw https://community.esri.com/t5/data-management-questions/the-latest-st-geometry-and-dependent-libraries/m-p/375954#M21343 <HTML><HEAD></HEAD><BODY><SPAN>i am upgrading my geodatabase instance from 9.3.1 to 10.1</SPAN><BR /><BR /><SPAN>my environment:</SPAN><BR /><SPAN>Oracle 11gR2 (11.2.0.3)</SPAN><BR /><SPAN>ArcSDE 9.3.1 SP2</SPAN><BR /><SPAN>IBM AIX 6.1</SPAN><BR /><BR /><SPAN>i want to enable st_geometry on my instance, i have followed esri procedure, however every time i run the pre-requisite upgrade tool i still face the warning message "</SPAN><STRONG>The latest ST_GEOMETRY and dependent libraries need to be copied to the correct software location</STRONG><SPAN>"</SPAN><BR /><BR /><SPAN>i have used the geoprocessing tool "</SPAN><STRONG>create spatial type</STRONG><SPAN>", and used the "sys" user (which is by the way not a good security practice to access a 'sys' user from the client, which requires the creation of a password file,...etc)</SPAN><BR /><BR /><SPAN>the tool ran for 3 seconds and stated "successful" message, however it gave me a warning that a "geodatabase instance already exists".</SPAN><BR /><BR /><SPAN>i have copied the st_shapelibrary.so from $SDEHOME/lib to under my $ORACLE_HOME/lib</SPAN><BR /><SPAN>also i have updated the external procedure file under $ORACLE_HOME/hs/admin</SPAN><BR /><SPAN>with a directory referencing the $ORACLE_HOME/lib/st_shapelibarary</SPAN><BR /><BR /><SPAN>is this the right path where should i place the library ?</SPAN><BR /><BR /><SPAN>or should i place it locally on my machine where ArcGIS desktop ? if this is the case.....can someone please provide the directory?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN></BODY></HTML> Tue, 18 Feb 2014 14:10:04 GMT https://community.esri.com/t5/data-management-questions/the-latest-st-geometry-and-dependent-libraries/m-p/375954#M21343 EmadAl-Mousa 2014-02-18T14:10:04Z Re: The latest ST_GEOMETRY and dependent libraries need to be copied to the correct s https://community.esri.com/t5/data-management-questions/the-latest-st-geometry-and-dependent-libraries/m-p/375955#M21344 <HTML><HEAD></HEAD><BODY><SPAN>Do not copy anything from SDEHOME.&nbsp; The most recent libraries are part of the</SPAN><BR /><SPAN style="font-style:italic;">Desktop</SPAN><SPAN> unstall (under the Desktop10.1/DatabaseSupport/Oracle folder, as </SPAN><BR /><SPAN>described by the&nbsp; documentation).&nbsp; You should apply 10.1 SP1 before copying.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Tue, 18 Feb 2014 16:04:17 GMT https://community.esri.com/t5/data-management-questions/the-latest-st-geometry-and-dependent-libraries/m-p/375955#M21344 VinceAngelo 2014-02-18T16:04:17Z Re: The latest ST_GEOMETRY and dependent libraries need to be copied to the correct s https://community.esri.com/t5/data-management-questions/the-latest-st-geometry-and-dependent-libraries/m-p/375956#M21345 <HTML><HEAD></HEAD><BODY><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>i found the st_geometry libraries in the following directory:</SPAN><BR /><BR /><SPAN>C:\Program Files (x86)\ArcGIS\Desktop10.1\DatabaseSupport</SPAN></BODY></HTML> Sun, 23 Feb 2014 02:07:01 GMT https://community.esri.com/t5/data-management-questions/the-latest-st-geometry-and-dependent-libraries/m-p/375956#M21345 EmadAl-Mousa 2014-02-23T02:07:01Z