sde commands

519
4
Jump to solution
02-21-2018 07:43 PM
jayasudha
New Contributor III

we are using arcgis 10.1, oracle 11g database and using direct connection, there is no service.

the commands (sdeconfig, sdedbtune, sdelog, sdemon) works fine for me.

the commands (sdegdbrepair, sdesetup) does not work and gives error.

sdegdbrepair -o diagnose_metadata -d ORACLE11G -u sde -p xyz -i sde:oracle11g:orcl3

ESRI ArcSDE Server Repair Utility Thu Feb 22 09:11:47 2018
----------------------------------------------------------------
Error: Underlying DBMS error (-51).
Error: Unable to list inconsistent metadata.

0 Kudos
1 Solution

Accepted Solutions
Asrujit_SenGupta
MVP Regular Contributor

Well....it's been a long time working with SDE Command line tools... 

Error: Underlying DBMS error (-51).

This seems to point to an issue in connecting to the Database.

Maybe try something like below:

sdegdbrepair -o diagnose_metadata -d ORACLE11G -u sde -p xyz@orcl3

sdegdbrepair -o diagnose_metadata -d ORACLE11G -u sde -p xyz -i orcl3

In case you have 10.3.x or higher Desktop available, check this: Diagnose Version Metadata—Help | ArcGIS for Desktop 

View solution in original post

4 Replies
Asrujit_SenGupta
MVP Regular Contributor

Well....it's been a long time working with SDE Command line tools... 

Error: Underlying DBMS error (-51).

This seems to point to an issue in connecting to the Database.

Maybe try something like below:

sdegdbrepair -o diagnose_metadata -d ORACLE11G -u sde -p xyz@orcl3

sdegdbrepair -o diagnose_metadata -d ORACLE11G -u sde -p xyz -i orcl3

In case you have 10.3.x or higher Desktop available, check this: Diagnose Version Metadata—Help | ArcGIS for Desktop 

jayasudha
New Contributor III

Thanks

0 Kudos
Asrujit_SenGupta
MVP Regular Contributor

If possible, do share what worked for you...so that it may help others for reference..

0 Kudos
jayasudha
New Contributor III

both options