topic Re: upgrade in Data Management Questions

upgrade

jayasudha — Mon, 19 Feb 2018 03:27:50 GMT

I am using arcgis desktop 10.1 and oracle 11gR2, connected using direct connect, there is no app server and there is no service. When i try to upgrade gdb, i get following error in the log.

[Mon Feb 19 08:45:19 2018]
ST_Geometry Schema Owner: (SDE) Type Release: 1007
[Mon Feb 19 08:45:19 2018] Instance initialized for ((sde)) . . .

[Mon Feb 19 08:45:19 2018] Error: Underlying DBMS error (-51).
[Mon Feb 19 08:45:19 2018] Error: DB_arcsde_setup: Unable to connect
[Mon Feb 19 08:45:19 2018] ORA-00933: SQL command not properly ended

[Mon Feb 19 08:45:19 2018] ERROR installing/upgrading ArcSDE, Error = -51

Re: upgrade

Asrujit_SenGupta — Mon, 19 Feb 2018 03:52:39 GMT

ArcSDE 10.1 sp1 upgrade geodatabase error: DB_arcsde_setup: Unable to connect

NIM086410: Upgrading an Enterprise geodatabase using a database..

Do not use the old syntax of sde:oracle11g:tnsname within the connection that is upgrading the geodatabase.
Ensure that a new connection is established with one of the following:
1 - Make a connection to the Oracle geodatabase by typing only the TNSNAME in the 'Instance' textbox and the geodatabase will upgrade successfully. OR
2 - Modify the sqlnet.ora file on the client machine to enable easy connect: NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT) Then connect to the geodatabase with the easy connect string (refer to ArcGIS 10.1 documentation) and upgrade the geodatabase.

Re: upgrade

jayasudha — Mon, 19 Feb 2018 04:06:26 GMT

Many Thanks Asrujit SenGupta