WARNING: This page is about a different car, the 2004 GMC Safari and 2004 Chevrolet Astro. However, it is still accessible from the selected car via links, so may be relevant.
Ratcheting Noise
Checks
Causes
Parking Brake Pawl (50-81)
The parking pawl return spring is weak, damaged, or misassembled