Desktop Help 10.0 - Preparing to upgrade a geodatabase in Oracle

When you upgrade any enterprise system, including a geodatabase, plan ahead. Test the new version on a development or test server to ensure that it works with all your client applications.

When you have determined that the new system works the way you expected, schedule the upgrade; be sure the necessary staff are available to perform the upgrade and that they have the permissions necessary to complete their assigned tasks.

Note:

You can upgrade directly from an ArcSDE 9.2, 9.3, or 9.3.1 geodatabase to ArcSDE 10. If your geodatabase is at release 9.1 or earlier, you must first upgrade to a supported release, then upgrade to ArcSDE 10.
Upgrades from beta versions of the software are not supported.
If the geodatabase is part of a replica, you must upgrade both the parent and child geodatabase before synchronizing.
There is no formal mechanism to downgrade a geodatabase to a previous version. If after upgrading to a newer version you want to downgrade the geodatabase, you must restore the old database from backup.
Once a geodatabase has been upgraded, previous versions of ArcGIS will be unable to open it since older versions of ArcGIS cannot read newer versions of the geodatabase.

You must also complete the following steps before you upgrade your geodatabase in Oracle:

Steps:

Check the ArcGIS Resource Center to be sure that your system meets the minimum requirements.
If you are upgrading to ArcSDE 10 for Oracle and you are currently using Oracle9i, you must first upgrade your Oracle database to at least Oracle 10g R2. See the Oracle documentation for information on how to migrate your existing Oracle installation and database to a new release of Oracle.

For details on exact Oracle versions and patch levels supported by each ArcSDE for Oracle installation, see the ArcGIS Server system requirements on the ArcGIS Resource Center at http://resources.esri.com and navigate to ArcGIS Products > Server > System Requirements > Relational Database Management Systems > Oracle.
Make sure that the Oracle Text component is installed.
The Text component is installed by default in Oracle 10g and 11g; however, if you did not do a default installation, the Text component may not have been installed.
To see if it is installed, execute the following SQL statement while logged in as SYSTEM or a user with DBA privileges in the database:
```
SELECT owner, object_name
FROM all_objects
WHERE object_type = 'PACKAGE'
  AND object_name = 'CTX_DDL'
```
If no record is returned, the Text component is not installed. Run the Oracle installation to install the Text component.
Create a backup of the database.
For IBM AIX users only: If you are installing on AIX, it is recommended that you run slibclean before upgrading or installing ArcSDE to clear inactive libraries from memory. Stop your current ArcSDE service and run slibclean as the root user. See your AIX system administrator documentation for more information on the slibclean command.
Remove any custom functionality you may have added to the ArcSDE geodatabase system tables outside ArcGIS such as triggers or additional indexes.

The upgrade procedure cannot be aware of customizations you make to the system tables. If such customizations prevent the alteration of a system table's schema, the upgrade will fail.
Grant the ArcSDE administrator the permissions necessary to upgrade a geodatabase.
Install the current release of an ArcGIS client (ArcGIS Desktop ArcEditor or ArcInfo, ArcGIS Engine Runtime with the Geodatabase Update extension, or ArcGIS Server Standard or Advanced) on a computer that can directly connect to the geodatabase to perform the upgrade.
Note:
If you are upgrading the geodatabase to release 10 from an ArcGIS client on Linux, you must apply 10 service pack 1 to the client. See technical article 37974 on the ArcGIS Resource Center for details on why this is necessary.
Make sure that the Oracle client is installed and configured on the computer where the ArcGIS client is installed.

This is required because you must make a direct connection from an ArcGIS client to the geodatabase to upgrade it. See Setting up a direct connection to Oracle for more information.
Make sure there are no users connected to the geodatabase you are upgrading. If you are upgrading the sde master geodatabase, also make sure no one is connected to any of the user-schema geodatabases in the Oracle database.

You can use the sdemon command to check this. Be sure to check the connections for the geodatabase you are upgrading and, if upgrading the master geodatabase, check the connectcions for all user-schema geodatabases. See Displaying connected sessions for instructions.
Shut down any ArcSDE services that are running using the sdemon –o shutdown command. Or if the service is running on a Windows server, you can stop the service on the Windows Services interface instead of using the sdemon command.

See the command syntax in the ArcSDE Administration Command Reference for more information on the sdemon command.
Uninstall the old release of ArcSDE. See either Uninstalling ArcSDE from Windows or Uninstalling ArcSDE from Linux or UNIX for instructions.
In Windows, you are prompted to delete the ArcSDE services during the uninstallation process if any are running. Click Yes to delete the service if you are installing a new release of ArcSDE. If you are installing a service pack or patch, you can click No and reuse the service unless the service pack or patch instructions specify that you must re-create the service. (For example, if the service pack or patch fixes something in the service functionality, you most likely need to re-create it.)
Install the new release of ArcSDE.
On Windows operating systems, do not run the Post Installation wizard. The Post Installation wizard is for new installations only.
If installing ArcSDE 10 on Linux, apply service pack 1.
Note:
If you install ArcSDE to a different location than you had previously and your previous release geodatabase had the EXTPROC configured for ST_Geometry, you must reconfigure your listener.ora file to point to the new library location and restart the Oracle listener. (The default directory for UNIX and Linux is different with each version of ArcSDE.) See Configuring the Oracle listener to use SQL for more information.
If ArcSDE is installed on a different server than your Oracle database, copy the st_shape library from the bin (Windows) or lib (UNIX/Linux) directory in SDEHOME to the lib directory in ORACLE_HOME. If you plan to use the ST_Raster type, also copy the libst_raster_ora library from SDEHOME to the ORACLE_HOME directory.

See Installing Oracle and ArcSDE on separate servers for more information.

The geodatabase is now ready to be upgraded. You can use the Upgrade Geodatabase tool in ArcGIS Desktop or a Python script run on the ArcGIS client computer.

Preparing to upgrade a geodatabase in Oracle

Related Topics