For EDDB, see those 2 topics:
EDDB new runway allocations
Berlin Brandenburg EDDB Approaches missing apart from automatic
For WSSS, the issue reported here could explain the lack of procedures: WSSS Runways 02C/20C and 02R/20L submerged / incompletely labeled
Usually this type of issue happens when the airport runways setup into the sim does not match with the latest Airac.
If you install sceneries where runways match the Airac then the STAR become available again.