topic Re: ArcSDE 9.2 SP6 Error installing software authorization / cannot start service in Data Management Questions

ArcSDE 9.2 SP6 Error installing software authorization / cannot start service

MilosMilicevic — Thu, 29 Nov 2012 10:29:06 GMT

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

Re: ArcSDE 9.2 SP6 Error installing software authorization / cannot start service

VinceAngelo — Thu, 29 Nov 2012 11:04:48 GMT

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

- V

Re: ArcSDE 9.2 SP6 Error installing software authorization / cannot start service

MilosMilicevic — Fri, 30 Nov 2012 07:19:01 GMT

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

Re: ArcSDE 9.2 SP6 Error installing software authorization / cannot start service

MilosMilicevic — Fri, 30 Nov 2012 10:44:43 GMT

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

Re: ArcSDE 9.2 SP6 Error installing software authorization / cannot start service

VinceAngelo — Tue, 04 Dec 2012 12:40:40 GMT

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

Re: ArcSDE 9.2 SP6 Error installing software authorization / cannot start service

MilosMilicevic — Wed, 05 Dec 2012 12:32:47 GMT

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

Re: ArcSDE 9.2 SP6 Error installing software authorization / cannot start service

VinceAngelo — Wed, 05 Dec 2012 14:34:09 GMT

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.