Dynamical Tides And Oscillations In Star And Planetary Systems