Upgrading a geodatabase in Oracle

ArcGIS 10 and higher release geodatabases are upgraded using the Upgrade Geodatabase geoprocessing tool or Python script. Therefore, you must have the current version of ArcGIS for Desktop (Standard or Advanced), ArcGIS Engine with the Geodatabase Update extension, or ArcGIS for Server (Standard or Advanced) installed on the computer from which you will run the upgrade because geoprocessing functionality is available from ArcGIS on these clients.

Caution:

If you have geodatabases in the schemas of users other than the sde user, you must first upgrade the sde master geodatabase, then upgrade each of the geodatabases in the other users' schemas. Each geodatabase is upgraded separately.

Be sure you have read and performed the steps in Preparing to upgrade a geodatabase in Oracle before you upgrade.

This topic explains how to upgrade an enterprise geodatabase by launching the Upgrade Geodatabase geoprocessing tool from the Upgrade Geodatabase button on the Geodatabase Properties dialog box. You could also search for the tool and run it, or you could run a Python script.

Steps:

1. Start ArcCatalog, or start ArcMap, ArcGlobe, or ArcScene and open the Catalog window.
2. Expand the Database Connections node and connect to the geodatabase you want to upgrade.

   You must connect directly to the geodatabase as the geodatabase administrator. If the connection does not already exist, add a new connection. See Database connections in ArcGIS for Desktop for information.

3. Right-click the geodatabase connection and click Properties.
4. Click the General tab.

   If an upgrade is needed, the Upgrade Geodatabase button is active.

   If the Upgrade Geodatabase button is not active, it could be because the connecting client is at the same release as the geodatabase, your DBMS is not at a supported upgradable release, you are using an ArcSDE service connection rather than a direct connection to the geodatabase, or you are connecting from an ArcGIS for Desktop Basic client.

5. Click the Upgrade Geodatabase button.

   The Upgrade Geodatabase geoprocessing tool opens. The Input geodatabase text box is prepopulated with the geodatabase connection information.

Note:

You cannot run the Upgrade Geodatabase tool if any other geoprocessing tools are currently running as background processes on the client machine.

6. Esri recommends that you leave both the Pre-requisites check and Upgrade geodatabase options checked on the Upgrade Geodatabase geoprocessing tool. That way, the tool checks to see whether the prerequisites to upgrade have been met before continuing with the geodatabase upgrade.

   The prerequisite check detects other active connections to the geodatabase, whether the connecting user has sufficient privileges to upgrade the geodatabase, and that the database can support XML columns; makes sure all datasets can be opened; ensures that the master geodatabase has been upgraded before any user-schema geodatabases can be upgraded; and detects that the database and libraries are at the same release. If any prerequisite is not met, the tool terminates. You must correct any problems before you run the upgrade procedure again.

   The results of this check are reported on the geoprocessing tool dialog box. If the check (or upgrade) fails, results are also written to the GDBUpgrade.log, which can be found in c:\ Documents and Settings \<user name>\ Local Settings\Application Data\ESRI\<ArcGIS product> on Windows XP and Server 2003 operating systems; c:\Users\<user name>\AppData\Local\ESRI\<ArcGIS product> on all other supported Windows operating systems; or <user home>/.arcgis<#>/Application Data/ESRI on Linux operating systems.

7. Click OK to start the checks and upgrade.
8. If all checks are passed, the tool proceeds with the upgrade. The status for the prerequisites check and the upgrade are shown on the geoprocessing tool progress dialog box. If the upgrade fails, information is written to the GDBUpgrade.log. Additional information is written to the sdesetup.log, which can be found in the system TEMP directory.
9. When the tool successfully completes, click Close to close the geoprocessing tool progress dialog box.

Your geodatabase is upgraded to the latest release.

To upgrade network datasets, parcel fabrics, or mosaic datasets in the geodatabase, use the Upgrade Dataset geoprocessing tool or a Python script.

Note:

Upgrades of network datasets, parcel fabrics, or mosaic datasets are optional. However, if you do not upgrade them, you do not have access to the latest functionality in these datasets.

If you have existing versioned views (formerly called multiversioned views), and you want to take advantage of new versioned view functionality, drop the existing versioned views and re-create them from an ArcGIS 10.1 or later release client after you upgrade your geodatabase.