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.