nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcSDE 9.2 SP6 Error installing software authorization / cannot start service

MilosMilicevic

Hello,

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:

Error: Underlying DBMS error (-51).
Error: Error upgrading authorization key.

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?

Thanks in advance for any help.

Regards,
Milos

Find more posts tagged with

Accepted answers

VinceAngelo

If you change bit architectures you *MUST* run the 'sdesetup -o upgrade' to update the packages.

- V

All comments

VinceAngelo

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.

MilosMilicevic

Hello,

I am a bit new, so I am not sure I understood your advice .
What tool should I use to do the benchmark?
Would SDETRACE give me the info I need?

Tnx in advance.

Regards,
M

VinceAngelo

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.

- V

MilosMilicevic

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?

Regards,
MMilos

MilosMilicevic

Hello V,

thanks for helping.

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?

Tnx in advance.
Regards,
MMilos

VinceAngelo

If you change bit architectures you *MUST* run the 'sdesetup -o upgrade' to update the packages.

- V

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.