This sound effect can be found on The General Series 6000 Sound Effects Library, which was made by Sound Ideas. It shouldn't be confused with DRAWBRIDGE - CHAINS HOISTING BRIDGE OPEN, CASTLE from the same library.
Clean, Full Length and Unedited Link to the Sound Effect
- Super Mario 64 (Used when aiming a cannon.)
- Super Mario 64 DS (Used when aiming a cannon.)