Does this movie from the 80's or 90's sound familiar to anyone and can you tell me what it's called ?

I only remember that the boy is dreaming and he’s in a gym and realizes that the ghost is in his dream and wakes himself up. Another sequence I remember is the ghost taking the boy to visit his childhood who is now an elderly woman.