I follow this step-by-step http://technet.microsoft.com/en-us/library/ff681014.aspx for totally reset the consumer Profile Synchronization Service however i require the GUID from the synchronization database. I looked a great deal however i did not find anything. I want also to obtain the GUID from theOrsomething.


You should use Powershell to get this done the way in which MS describes within the Technet article or even the wise way:

$syncDBType = "Microsoft.Office.Server.Administration.SynchronizationDatabase"
$upaSAType = "User Profile Service Application"
$syncDB = Get-SPDatabase | where-object {$_.Type -eq $syncDBType}
$upa = Get-SPServiceApplication | where-object {$_.TypeName -eq $upaSAType}

$syncDB.Status = "Offline"
restart-service SPTimerV4 

Therefore we really don't search for the guid but look in which the database type may be the sync database type. You'll find more troubleshooting gems such as this on Harbars site: “Stuck on Starting”: Common Issues with SharePoint Server 2010 User Profile Synchronization