What impact can be on ArcGIS after Oracle Upgrade?

[bulatmakhmutov]

Hi everybody,

I have question,
What impact can be on ArcGIS after Oracle Upgrade?

we have architecture:
ArcGIS 9.3.1 system is installed on Microsoft Windows Server 2003 R2 (32 bit)
with Database: Oracle 10.2.0.3.0.

we are going to make upgrade of oracle on 11.2.0.1.0 version.

So question is,
if there will be any impact  on ArcGIS system?
if it will work uncorrectly?

If yes,
please advice, what steps must be done?
where we can read necessary documentation?
if that operation (upgrade of oracle) involve a lot of changes in ArcGIS?


With regards!

[bulatmakhmutov]

hi once more, Guys,
thanks for your replies.

I am new to ArcGIS.
I support Oracle. but we don't have person responsible for ArcGIS.
so, we responsible for that.


I think that these are full steps:

1.Stop the SDE service and disconnect database connections.
2.Follow steps in Oracle documentation to upgrade the RDBMS to 11.2.0.1.
3.Delete current sdehome folder.
4.Install ArcSDE 9.3.1 for Oracle 11g
5.Change environment variable (sde home/Oracle home)
6.Run sdesetup -o upgrade so that the geodatabase knows its Oracle version and gets any needed RDBMS changes, such as underlying stored procedures
7.Reconfigure the listener and tnsnames.ora for the new ST_GEOMETRY libraries
8.Debug the incorrect ST_GEOMETRY library references
9.Unblock the DBMS and start the SDE service
10.Update all your Direct Connect connection files (Syntax-11g)

where it (apply SP2 for ArcGIS 9.3.1) must be added in this list?
can you describe ArcGIS steps above in detail?

With regards!

[MichaelVolz]

Number 10 can be quite a big task if you want the client software at the same version as the database if your organization manages a large number of mxds (This could also impact lyr files that have SDE as their source).

[VinceAngelo]

@mvolz47 - The support status doc includes a link to the Life Cycle Policy page, which includes:

Once a product enters the Retired phase, the product will no longer be available for purchase and users can expect the following:

Software Support
�?� No new patches or hot fixes will be available.
�?� Esri will not certify any new environment.

Technical Support
�?� Users will no longer have access to technical support through direct phone, fax, chat, or e-mail request.
�?� E-mail requests posted through the online support center will not be answered. Access to very limited support will be provided in the form of the online support center including knowledge base, supported environment, downloads, and discussion forums.
�?� Although the online information will remain available to users, this information will not be updated. Users, however, will be able to browse existing documents.

Typically, products in the Retired phase will not work correctly in new environments. Esri will not attempt to either determine whether a Retired product will work in a new environment or actually make it work in a new environment.

- V

[VinceAngelo]

Given that 9.3.1 is relatively ancient, all the client computers should already be at
9.3.1sp2, but if they aren't, then you'll need to do that as well.

There are several post-SP2 patches that should be applied as well.

- V