Migrating to ArcSDE 64 bit on Windows when the existing DBMS is 64 bit

If you are running ArcSDE as a 32-bit application connecting to an existing 64-bit database management system (DBMS) on a 64-bit server, follow the instructions in this topic to migrate to using an ArcSDE 64-bit service.

Steps:
  1. Stop the ArcSDE service, if one is running.
    sdemon -o shutdown -i <service> -s <server_name> -p <ArcSDE_administrator_password>

    ArcSDE command line tools and their documentation are installed with ArcSDE.

  2. Make sure there are no users currently making a direct connection to the geodatabase.

    You can use the sdemon command to do this.

    sdemon -o users -i <service> -s <server_name> -p <ArcSDE_administrator_password>
  3. Create a backup of the database.
  4. If you will be installing the 64-bit version of the ArcSDE component on the same server as you had the 32-bit version, you must uninstall the 32-bit version of ArcSDE.
  5. Install the 64-bit version of the ArcSDE component on a 64-bit server (either the one on which the DBMS resides or a remote one). Do not proceed with the Post Installation wizard.
  6. Update the st_shapelib.dll library definition in the Oracle data dictionary.
    CREATE or REPLACE LIBRARY <library_name> 
    AS '<path_to_library>'
  7. If you installed a new release of ArcGIS and ArcSDE, grant upgrade privileges to the ArcSDE administrator user and upgrade the geodatabase.
  8. If your site uses an ArcSDE service to connect to the geodatabase, run a custom postinstallation setup using the Post Installation wizard on the 64-bit server to create and start the 64-bit service.
    NoteNote:

    If you installed the 64-bit ArcSDE component in the same location as the 32-bit ArcSDE component was installed and you want to use the same name and port for the 64-bit service as you had for the 32-bit service, you must first delete the entries for the 32-bit service from the services.sde and Windows services files. If you do not, the wizard will not allow you to create the service with the same name and/or port number as your old, 32-bit service.


11/18/2013