Latest Contributions by irishadar

hi 🙂 I'm having the same problem , I've created the subscription on the 16 of July, and i cant make any analysis . a prompt fix we be much appreciated. my Subscription ID: 8973724458 do you need my customer ID as well ? thank's Iris Hadar Gis administrator Israel Antiquities Authority ... View more

Sorry about the slowness I'm not DBA I'm GIS ADMINISTRATOR. In any case this the EXPLAIN PLAN and is identical both time i run it, it even gets the same Plan Hash Value PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                            ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Plan hash value: 3387874830                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   --------------------------------------------------------------------------------------------------------------                                                                                                                                                                   | Id  | Operation                                | Name              | Rows  | Bytes | Cost (%CPU)| Time     |                                                                                                                                            --------------------------------------------------------------------------------------------------------------                                                                                                                                                                   |   0 | SELECT STATEMENT                         |                   |  8564 |    21M|     4   (0)| 00:00:01 |                                                                                                                                                             |   1 |  NESTED LOOPS                            |                   |  8564 |    21M|     4   (0)| 00:00:01 |                                                                                                                                                                   |   2 |   TABLE ACCESS BY INDEX ROWID            | GIS_ATAR1         |     1 |   240 |     2   (0)| 00:00:01 |                                                                                                                                       |*  3 |    INDEX RANGE SCAN                      | GIS_ATAR1_ATA_IDX |     1 |       |     1   (0)| 00:00:01 |                                                                                                                                            |   4 |   TABLE ACCESS BY INDEX ROWID            | GIS_PARCEL1       |  8348 |    18M|     4   (0)| 00:00:01 |                                                                                                                                  |*  5 |    DOMAIN INDEX (Sel: Default - No Stats)| A11_IX1           |       |       |    18E  (0)|          |                                                                                                                                           --------------------------------------------------------------------------------------------------------------                                                                                                                                                                                                                                                                                                                                                                                                                                                                                Predicate Information (identified by operation id):                                                                                                                                                                                         ---------------------------------------------------                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             3 - access("A"."ATA_ID"=567)                                                                                                                                                                                                                                                      5 - access("SDE"."ST_INTERSECTS"("B"."SHAPE","SDE"."ST_BUFFER"("A"."SHAPE",0))=1)                                                                                                                                                                                                                                                                                                                                                                                                                                                 Note                                                                                                                                                                                                                                                                                                   -----                                                                                                                                                                                                                                                                                                         - dynamic sampling used for this statement (level=2)                                                                                                                                                                                       22 rows selected ... View more

couldn't find the execution plan part. should I run something else beside the trace 10046 level8? ... View more

Hi all i have upgraded the original 1.2 sample javascript viewer to 3.2 , but only the basic widgets. if any one wants the code i can send it 🙂 iris hadar ... View more

I completely agree with you since as I mentioned in my reply , we realy don't know what solve it , I simply pointing the changes that made the difference. I didn�??t mentioned it before but this was a completely new installation , no ARCSDE was ever install on it , so maybe that's way we don�??t have  the dependencies  you have (I've enclose ours in my last reply) . In any case this is the URL: http://resources.arcgis.com/en/help/main/10.1/index.html#/A_quick_tour_of_setting_up_a_geodatabase_in_Oracle/002n00000001000000/ Under "Setting up a geodatabase in Oracle" you can find these line: "The ST_Geometry library can be found in the DatabaseSupport directory of your ArcGIS client." Regarding the extproc.ora , I know this is what's documented but , it didn�??t work till we added the "old style" configuration as well .we plan on testing it again with only the extproc.ora config, once we finish making some benchmarks. I accepts your suggestion regarding the" ArcSDE application server " and will pass on to my DBA . Thanks again for all your effort to help us, it is really appreciated. Iris hadar ... View more

hi, I've notice that there is no version for solaris 10 , will this version work on solaris 10 ? Sun Solaris 9 (64-bit) 10.1 (Final)  thanks iris ... View more

problem solved 🙂 we realy don't know what solve it but here are the three major changes: 1.You must take the libst_shapelib.so from the unix installation and not from the "AcGIS for Desktop" as documented by ESRI. 2. you must have both extproc.ora  and old configuration "LISTENER.ORA+TNSNAMES.ORA". 3. the libst_shapelib.so must be in oracle root installation (oracle recommendation) thank you for your time iris ... View more

I've run the lld command, this is the results: SDE /var/opt/esrilibs 12 > ldd libst_shapelib.so         libclntsh.so.10.1 =>     /u01/app/oracle/product/11.2.0/dbhome_1/lib/lib clntsh.so.10.1         libCrun.so.1 =>  /usr/lib/64/libCrun.so.1         libnnz11.so =>   /u01/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.so         libkstat.so.1 =>         /lib/64/libkstat.so.1         libnsl.so.1 =>   /lib/64/libnsl.so.1         libsocket.so.1 =>        /lib/64/libsocket.so.1         libresolv.so.2 =>        /lib/64/libresolv.so.2         libgen.so.1 =>   /lib/64/libgen.so.1         libdl.so.1 =>    /lib/64/libdl.so.1         libsched.so.1 =>         /usr/lib/64/libsched.so.1         librt.so.1 =>    /lib/64/librt.so.1         libc.so.1 =>     /lib/64/libc.so.1         libaio.so.1 =>   /lib/64/libaio.so.1         libpool.so.1 =>  /usr/lib/64/libpool.so.1         libm.so.2 =>     /lib/64/libm.so.2         libmp.so.2 =>    /lib/64/libmp.so.2         libmd.so.1 =>    /lib/64/libmd.so.1         libscf.so.1 =>   /lib/64/libscf.so.1         libxml2.so.2 =>  /usr/lib/64/libxml2.so.2         libnvpair.so.1 =>        /lib/64/libnvpair.so.1         libexacct.so.1 =>        /usr/lib/64/libexacct.so.1         libdoor.so.1 =>  /lib/64/libdoor.so.1         libuutil.so.1 =>         /lib/64/libuutil.so.1         libpthread.so.1 =>       /lib/64/libpthread.so.1         libz.so.1 =>     /usr/lib/64/libz.so.1         /platform/SUNW,Sun-Fire-V240/lib/sparcv9/libc_psr.so.1         /platform/SUNW,Sun-Fire-V240/lib/sparcv9/libmd_psr.so.1 I've also run the command "ldd  -v libst_shapelib.so |grep 'not found'" it came back with nothing . I think it is simply not working on 11.2.0.3.0 for some reason. iris ... View more

Hi, thank again for all of your help, Why do you think we have installed ArcSDE for 10gR2? We don�??t have the "ArcSDE application server" currently installed at all. I'll describe our work flow, maybe it can clarify some things: 1. We've followed the instruction laid out in "setting up a geodatabase in oracle" and used the "Create Enterprise Geodatabase" geoprocessing tool in ArcGIS for Desktop To create the sde schema and then used direct connect to use it. 2.  We've followed the instruction laid out in "Installations on a Linux or UNIX server" we used this file to do so "ArcSDE_for_Oracle11g_on_Solaris_101_130017.tar.gz". 3.  We've tested the st_geometry and it returned the " SQL Error: ORA-28595: Extproc agent : Invalid DLL Path " , so our local distributor said that we do not need the " ArcSDE application server" on Unix any more , so we've removed it. As you can see nothing changed , we can use sde from within  "AcGIS for Desktop" But can't use the st_geometry functionality. ... View more

ok , so this are the files : TNSNAMES.ORA # TNSNAMES.ORA Network Configuration File: /app_root/network/admin/tnsnames.ora # Generated by Oracle configuration tools. EXTPROC_CONNECTION_DATA =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))     )     (CONNECT_DATA =       (SID = PLSExtProc)       (PRESENTATION = RO)     )   ) o11g =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = archeo)(PORT = 1521))     )     (CONNECT_DATA =       (SID = o11g)     ) ) LISTENER.ORA # LISTENER.ORA Network Configuration File: /app_root/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS_LIST =         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))       )       (ADDRESS_LIST =         (ADDRESS = (PROTOCOL = TCP)(HOST = archeo)(PORT = 1521))       )     )   ) SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (SID_NAME = PLSExtProc)       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)       (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=/var/opt/esrilibs/libst_shapelib.so,LD_LIBRARY_PATH=/var/opt/esrilibs")     )     (SID_DESC =       (GLOBAL_DBNAME = o11g.iaa.local)       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)       (SID_NAME = o11g)     )   )   ) SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF INBOUND_CONNECT_TIMEOUT_LISTENER=500 extproc.ora SET EXTPROC_DLLS=ONLY:/var/opt/esrilibs/libst_shapelib.so SET LD_LIBRARY_PATH=/var/opt/esrilibs:/u01/app/oracle/product/11.2.0/dbhome_1/lib this is what i get from SELECT * FROM USER_LIBRARIES LIBRARY_NAME                   FILE_SPEC                           DYNAMIC          STATUS  ------------------------------ --------------------------------------------------------------------- ST_SHAPELIB    /var/opt/esrilibs/libst_shapelib.so  Y   VALID this is what i get now from select st_point(0,0,0) from dual SQL*Plus: Release 11.2.0.3.0 Production on  Fri Dec 15 05:55:23 2012 Copyright (c) 1982, 2011, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select st_point(0,0,0) from dual; select st_point(0,0,0) from dual        * ERROR at line 1: ORA-06520: PL/SQL: Error loading external library ORA-06522: ld.so.1: extproc: fatal: libclntsh.so.10.1: open failed: No such file or directory ORA-06512: "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 12 ORA-06512: "SDE.ST_POINT", line 176 any suggestions ? iris ... View more

Hi all, Thanks again for your help 🙂 As I understand now we must use ONLY one of the two configurations. I see that we are using both configurations at once. However  I'm sending you all tree files, for you to check please, tell how should we  proceed from here. Do you think we should leave it and go back to 11.2.0.1.0? iris ... View more

Hi, Thanks for your prompt response. But we've already notice that and recompile the shape library to match the UNIX path. LIBRARY_NAME FILE_SPEC ------------------------------ ------------------------------------- ST_SHAPELIB /var/opt/esrilibs/libst_shapelib.so It is still doent work 😞 My DBA talked with Oracle and says that oracle version higher then 11.2.0.1 has a bug concerning external proc (LD_LIBRARY_PATH Set In extproc.ora File Is Ignored, ORA-06522 Could Be Raised (Doc ID 1194224.1)) Unfittingly I couldnâ??t find any documentation or work around on this . if any one has suggestion or was able to install it on 11.2..0.3 I would me more than happy to know how ? iris ... View more