POST
|
Hi Guys Any updates?? Is the problem in the dbtune table (create index directive) ? If so, which directive exactly is used for creating an Index on the TABLE_LOCKS table? Regards
... View more
06-24-2013
06:06 AM
|
0
|
0
|
155
|
POST
|
Thank you Angelo for the update, actually I have applied SP1 for ArcSDE 9.3.1 successfully, but the problem is in the upgrade stage. Also I want to mention that the result of the following select statement on the destination Server: Select * from sed.version; Giving us the following output, although it is a 9.3.1 on an Oracle 11G Server . Major Minor Bug_Fix Database 9 3 0 ORACLE10GR2 Regards
... View more
06-24-2013
04:18 AM
|
0
|
0
|
155
|
POST
|
Dear All, We have this project of migrating ArcSDE Repository and spatial data to a new better Server: Source: ArcSDE 9.3, Oracle 10G r2, Solaris 10 64 SPARC Destination: ArcSDE 9.3.1, Oracle 11G r2, Solaris 10 64 SPARC We had some issues while working, but we managed to solve most of them, here is a summary of what we have done so far: 1- Install Oracle 11G r2 software, and create a Database on the new Server. 2- Install the ArcSDE 9.3.1 Software on the same Server 3- Take a databump file of the SDE user, Data Owner, and all the other business users from destination. 4- Import the Databump file on the new Server. 5- upgrading the ArcSDE Repository on the new Server, but this step didn't work! giving us the following error: [Sun Jun 23 15:06:22 2013] ST_Geometry Schema Owner: (SDE) Type Release: 1007 [Sun Jun 23 15:06:22 2013] Instance initialized for ((sde)) . . . [Sun Jun 23 15:06:22 2013] ArcSde is already at an acceptable release: 9.3.0 [Sun Jun 23 15:06:22 2013] ERROR in creating index on TABLE_LOCKS. Error: -51 [Sun Jun 23 15:06:22 2013] DBMS error code: 2158 ORA-02158: \330\256\331\212\330\247\330\261 CREATE INDEX \330\272\331\212\330\261 \330\265\330\247\331\204\330\255 [Sun Jun 23 15:06:22 2013] SDE release upgrade not completed(-51). [Sun Jun 23 15:06:22 2013] ERROR installing/upgrading ArcSDE, Error = -51 Any ideas, your help are appreciated. Best Regards Sufian Khader
... View more
06-24-2013
03:07 AM
|
0
|
3
|
278
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|