Thank you gentlemen, We are in the middle of a major change of several items so switching to direct connect or an upgrade of ArcSDE were not in the cards but it's looking like we'll have to one or the other. May I ask, what are the locators for? My application developer doesn't have any idea (I am the dba) what they are and he's able to start up the ArcCatalog and things seem to be working fine. Kind of at a loss, Appreciate your time, elizabeth
... View more
Hello, We have been running ArcSDE 9.3.1 SP 1 on AIX 5.3 with Oracle 10.2.0.3 and upgraded the database last week to 220.127.116.11. After the database upgrade, I installed the ArcSDE 9.3.1 and ArcSDE 9.3.1 SP2 per ESRI's instructions (installed the base but didn't do post install, installed SP2 then completed post install) but while trying to run sdesetup -o upgrade -d ORACLE11G -u sde I am getting the following errors: ESRI ArcSDE Server Setup Utility Fri Aug 26 07:26:23 2011 ---------------------------------------------------------------- Upgrade ArcSDE, GDB table schema: Are you sure? (Y/N): Y Upgrading ArcSde schema..... Successfully upgraded ArcSde schema. Upgrading locators..... Error: 0509-130 Symbol resolution failed for /u01/app/product/esri/sdeexe93/lib/libgsrvrora11g93_64.so because: 0509-136 Symbol fc_softc (number 84) is not exported from dependent module /u01/app/product/oracle/11.2.0/db_1/lib/libclntsh.so. 0509-022 Cannot load module /u01/app/product/esri/sdeexe93/lib/libgsrvrora11g93_64.so. 0509-026 System error: Cannot run a file that does not have a valid format. 0509-192 Examine .loader section symbols with the 'dump -Tv' command. Error: Operation Failed (-1). Error: Error upgrading locators . SDE schema object install not completed. Check SDEHOME\etc\sde_setup.log or SDEHOME\etc\sde_dc<rdbms>.log for more details.. And all that's in the log is: [Fri Aug 26 07:26:25 2011] Instance initialized for ((sde)) . . . [Fri Aug 26 07:26:25 2011] ArcSde is already at an acceptable release: 9.3.1 [Fri Aug 26 07:26:31 2011] Connection to sde failed(0) According to ESRI documentation, Oracle 11gR2 is supported at ArcSDE 9.3.1 SP2 but when I entered a ticket with ESRI, I was told that it was hitting bug [#NIM062679: Running sdesetup -o install on Oracle 11G R2 64bit Standard Edition for ArcSDE fails with an error]. This bug though says it was found in ArcSDE 10 and is fixed in SP2. I found an entry in the forums referencing this problem and the last message says: "For technical reasons AIX ArcSDE 9.3.1 for Oracle 11g doesn't work with Oracle 11gR2. We have changed the way we link to the Oracle libraries at ArcSDE 10 on AIX. We will port this fix to ArcSDE 9.3.1 with Service Pack 2. -- Dave" http://forums.esri.com/thread.asp?c=158&f=2291&t=303773 Any help on this would be greatly appreciated because so far I've been told that our only fix is to go to ArcSDE 10 SP 2 so why list that ArcSDE 9.3.1 SP 2 is supported at my OS and database level?
... View more