ArcSDE 10 upgrade failed in Linux release 5.5

NorlizaAbdul_Rahman — Tue, 24 Apr 2012 05:28:05 GMT

Hi,
I'm trying to upgrade ArcSDE from 9.3 to ArcSDE 10.
This is on VMWare setup.

$ more /etc/redhat-release
CentOS release 5.5 (Final)

This is what was done:
$ ./sdesetup -o upgrade -d ORACLE10G -u sde -p sde

ESRI ArcSDE Server Setup Utility Tue Apr 24 06:57:02 2012
----------------------------------------------------------------
Upgrade ArcSDE, GDB table schema: Are you sure? (Y/N): Y
Upgrading ArcSDE schema.....
VERSION/release table updated to:
        10.0 for Oracle10g Build 685 Fri May 14 12:05:43 2010
Error: Underlying DBMS error (-51).
       SDE release upgrade not completed.
Check SDEHOME\etc\sde_setup.log for more details..

$ more sde_setup.log

[Tue Apr 24 06:53:37 2012]
ST_Geometry Schema Owner: (SDE) Type Release: 1007
[Tue Apr 24 06:53:37 2012] Instance initialized for ((sde)) . . .

[Tue Apr 24 06:53:40 2012]
ST_Geometry Schema Owner: (SDE) Type Release: 1007
[Tue Apr 24 06:53:40 2012] Instance initialized for ((sde)) . . .

[Tue Apr 24 06:53:42 2012] ERROR installing/upgrading ArcSDE, Error = -25
[Tue Apr 24 06:57:02 2012]
ST_Geometry Schema Owner: (SDE) Type Release: 1007
[Tue Apr 24 06:57:02 2012] Instance initialized for ((sde)) . . .

[Tue Apr 24 06:57:04 2012]
ST_Geometry Schema Owner: (SDE) Type Release: 1007
[Tue Apr 24 06:57:04 2012] Instance initialized for ((sde)) . . .

[Tue Apr 24 06:57:04 2012] ArcSde is already at an acceptable release:
        9.3.0
[Tue Apr 24 06:57:08 2012] LAYER_STATS table being created...
[Tue Apr 24 06:57:09 2012] LAYER_STATS table created...
[Tue Apr 24 06:57:10 2012] Warning: Resetting MAXBLOBSIZE value to remove maximu
m blobsize restriction (-1). Old value (1000000)
[Tue Apr 24 06:57:13 2012] DBMS stored procedures being created or updated...
[Tue Apr 24 06:57:21 2012] DBMS stored procedures created or updated...
[Tue Apr 24 06:57:21 2012] WARNING: Config parameter "XML_COLUMN_STORAGE" not fo
und in keyword "DEFAULTS".
         Inserting the default values.
[Tue Apr 24 06:57:21 2012] WARNING: Config parameter "XMLDB_INDEX_FULLTEXT" not
found in keyword "DEFAULTS".
         Inserting the default values.
[Tue Apr 24 06:57:21 2012] WARNING: Config parameter "XMLDB_INDEX_TAG" not found
in keyword "DEFAULTS".
         Inserting the default values.
[Tue Apr 24 06:57:25 2012] SDE release upgrade not completed(-51).
[Tue Apr 24 06:57:25 2012] ERROR installing/upgrading ArcSDE, Error = -51

When I query "select object_name, object_type, created, last_ddl_time, status from user_objects where object_type in ('OPERATOR','PACKAGE','PACKAGE BODY','INDEXTYPE','FUNCTION','TYPE','TYPE BODY');"
Returns with 185 rows but only 1 object_name that invalid
ST_DOMAIN_METHODS, TYPE BODY

When I query "select major, minor, release from sde.version;"
Returns:
    MAJOR MINOR RELEASE
10 0 100001

Anybody can help me to get a successfull upgrade?

Thanks.

Re: ArcSDE 10 upgrade failed in Linux release 5.5

NorlizaAbdul_Rahman — Tue, 24 Apr 2012 05:59:00 GMT

Dear All,

Managed to get this solved by:
1. Setting the environment correctly. Remove any link to the old ArcSDE9.3 installation including the path and lib.
2. Setting the correct port in /etc/services

Thanks.

topic ArcSDE 10 upgrade failed in Linux release 5.5 in Data Management Questions

ArcSDE 10 upgrade failed in Linux release 5.5

Re: ArcSDE 10 upgrade failed in Linux release 5.5