We are trying to install ArcSDE 9.2 SP6 after migrating from Oracle 10.2.0.3.0 32bit to 10.2.0.3.0 64bit. I installed Oracle, then installed ArcSDE 9.2 and then we performed data migration which went well. Then I tried to perform ArcSDE PostInstall (only authorization and service creation, since the SDE user and repository already exist).
When I try to authorize the software, i get the following message box: Error installing software authorization. When I try to run sdesetup -o update key, i get following messages:
I must mention that going to a newer ArcSDE version is not an option since we use some extensions that must run on ArcGIS 9.2, at least for the next couple of months. I added LOCAL=netservicename in dbinit.sde, added a path to oracle clients network/admin folder in TNS_ADMIN , and added a ORACLE_HOME variables...and i cannot get the service to start. The last entry in ArcSDE service log is this:
ST_Geometry Schema Owner: (SDE) Type Release: 1007 Instance initialized for ((sde)) . . .
Connected to instance . . . DBMS Connection established... Error -51 in purge unused shared entries. DBMS error code: -6508 Error in PL/SQL block to clean upleftover entries for SDE instance ORA-06508: PL/SQL: could not find program unit being called ERROR: Cannot Initialize Shared Memory (-51)
While preparing for this migration, I found on some forums that I must use 32bit Oracle Client to connect to database, and I configured it, and it works ok (I can query data with sqlplus, and connection tests in Oracle Net manager goes ok)...could this be the problem?
One question before I try upgrade: Since I have SDE user and Repository already created in my x64 Oracle DB, how would sdesetup -o upgrade affect the data inside the SDe repository?
Thanks for helping, Vangelo. It worked. I run sdesetup -o upgrade and it works. Only thing I notice is that logging in to the database takes a bit longer than usual...any ideas why?
Too many to count. It may be fragmentation in the upgraded instance. It could be the larger application word size increasing the size of the instruction set... You'd need to benchmark old and new, then study query plans to determine why.
SDEINTERCEPT* can probably help you see what queries are being performed and how long they take (just not *why* they're slower, for that you need a query plan).
The query plan topic is too large (and too tangential to GIS) to go into depth here. Google 'Oracle Query Plan' to begin your journey to the Dark Side.
-V
*Note that the Knowledge Base doc states:
If the server code is slow, it is recommended to apply the ArcGIS 9.2 SP6 General Update patch for ArcSDE. The patch contains enhancements to improve slow connections.
So you should certainly apply that (and the other post-SP6 patches) before starting.
