upgrade

639
2
Jump to solution
02-18-2018 07:27 PM
jayasudha
New Contributor III

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

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
Asrujit_SenGupta
MVP Regular Contributor

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.

View solution in original post

2 Replies
Asrujit_SenGupta
MVP Regular Contributor

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.

jayasudha
New Contributor III

Many Thanks Asrujit SenGupta

0 Kudos