ArcSDE 9.2 SP6 upgrade to ArcSDE 10 SP5 upgrade issue

[MilosMilicevic]

Hello,

I am having issues with upgrading to ArcSDE 10 SP5.
My gdb is on ArcSDE 9.2 SP6 on Oracle 10.2.0.3 x32 .I have migrated the data to Oracle 11.2.0.3 x64 (Server 2008 R2 x64), and trying to make a direct connection through ArcCatalog 10, in order to perform the upgrade to ArcSDE 10 SP5.


The problem that I encounter is that the direct connection will not work. It gives all sort of error messages (the most common one is a general DBMS error "underlying DBMS error [Unkonown error.No extended error.]".
We have installed the 32bit Oracle Client (full, not Instant), but avail.
I have followed the instructions on ESRI site, on how to connect without SDE service, eg: sde:oracle11g:<Net service name 32bit>
What is interesting is this: When i try to connect to the new database, from the old server, with ArcCatalog 9.2, it connects and shows all the data, but cannot upgrade, since it has ArcSDE 9.2 installed, and I cannot install a new version since that server still runs as a production server.

Please advise...
tnx in advance.
Regards,
Milos.

[VinceAngelo]

I don't see any place in that cookbook where is says to install 32-bit Oracle 11g.
It does say to upgrade the geodatabase before upgrading the database to 64-bit,
and your description doesn't include that step.

I try to avoid in-situ Oracle upgrades, preferring to load the data into a new instance
(prevents the fragmentation that occurs during uprade), but getting the data into the
instance can be a challenge.

- V

[MilosMilicevic]

I did as you guys suggested.
Did the upgrade to ArcSDE 10, and it wen well. The ORA-25153 was because I had no datafile in my TEMP tbs. After correcting that, the upgrade went smooth.
Now I have created the dump that I will import into Oracle 11g x64. I hope that it will go allright, because I already did this type of migration a few month ago (Oracle 10.2.0.3 x86 to x64).
I created a full export of the x86 Oracle, and after the copy of the .dmp to the server is done I will use impdp to import it into 11g.
Then I will run the postinstall, without creating the SDE tbs and user, only authorization and service creation.

Any suggestions on this?

Tnx,
M.

[MarcoBoeringa]

Good to hear the upgrade to 10.x on the 32-bit installation went well after correcting the TEMP tablespace issue. Good luck with the migration to the 64-bit server. I haven't got any additional suggestions here, sounds like you are on the right track now, maybe Vince has something to add.

I do see a potential issue with Oracle 11.2.0.1 mentioned here concerning import/export operations, but since you are using 11.2.0.3, this probably doesn't apply, anyway, maybe good to keep this in mind if anything goes wrong:

http://support.esri.com/en/knowledgebase/techarticles/detail/38470

[MilosMilicevic]

I give up...
this will not work no matter what.
I did the import, all ok, but still cannot connect to Oracle directly, or create a service.
Also I get error, that the authentification key cannot be updated.

[MarcoBoeringa]

I give up...
this will not work no matter what.
I did the import, all ok, but still cannot connect to Oracle directly, or create a service.
Also I get error, that the authentification key cannot be updated.

Seems to me you are awfully close to solving this, but I guess it may be good to call in some ESRI Help to get this ArcSDE authorization and database connection issue sorted out now you managed to upgrade and move the database to the 64-bit platform.

Anyway, you probably already followed these steps, but have you tested the functioning of the Oracle Net client per the text below from this Help page?

"2. Test that Oracle Net was installed successfully by typing the following at a command prompt on the client machine:

sqlplus <user name>/<password>@<Oracle Net service name>"

[MilosMilicevic]

Yes, that was the first thing I did, when the direct connect failed. It works with sqlplus, but in ArcCatalog, it gives me a general error message (Operation failed).
I have found in some forum, that the authentication error like this happens when a database name is changed, and I did change it...Now I will try to delete the database, and create a new 11g db, with the sam name as the 10g I did the upgrade and export from.

I will post results.
Tnx,
M.

[MarcoBoeringa]

Yes, that was the first thing I did, when the direct connect failed. It works with sqlplus, but in ArcCatalog, it gives me a general error message (Operation failed).
I have found in some forum, that the authentication error like this happens when a database name is changed, and I did change it...Now I will try to delete the database, and create a new 11g db, with the sam name as the 10g I did the upgrade and export from.

I will post results.
Tnx,
M.

Milo, Vince clearly stated in another thread that changing database names is NOT supported on geodatabases. This is because the database name is included in vital stored procedures and triggers etc. in the ArcSDE Repository.

So yes, ensure the database name of the new instance is exactly the same as the old one.

[VinceAngelo]

Changing database names is not supported with RDBMS software which supports databases.
Oracle does not support multiple databases in a larger instance container, so it is immune
from this possible complication.

I'm not sure what the complication is, but it can't be change of database name.

- V

PS: ArcSDE 10.0 requires a different ECP key than 9.2, so this might be the "authentication key".
See the doc on 'sdesetup -o update_key'.

[MilosMilicevic]

I have new ECP keys for v10, it can't be that.

[VinceAngelo]

Yet you reported an error that the authentication key could not be updated.  So you should
confirm that the 10.0 key is present in the Oracle instance (and that the 9.2 key is not)
by inspecting the SDE.SERVER_CONFIG table:

sqlplus sde/password@instance
SELECT char_prop_value FROM server_config WHERE prop_name = 'AUTH_KEY';

(Please do not report the results to this thread, just whether the first two elements are
"arcsdeserver,100").

- V