sde commands

[jayasudha]

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.

[Asrujit_SenGupta · Accepted solution]

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]

Thanks

[Asrujit_SenGupta]

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

[jayasudha]

both options