topic sde commands in Data Management Questions

sde commands

jayasudha — Thu, 22 Feb 2018 03:43:38 GMT

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.

Re: sde commands

Asrujit_SenGupta — Thu, 22 Feb 2018 04:21:01 GMT

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

Re: sde commands

jayasudha — Thu, 22 Feb 2018 05:52:19 GMT

Thanks

Re: sde commands

Asrujit_SenGupta — Thu, 22 Feb 2018 05:56:22 GMT

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

Re: sde commands

jayasudha — Thu, 22 Feb 2018 09:37:23 GMT

both options