It sounds like you need to go to the range.I choose not to explore the psychology behind this, but I've had dreams of being in imminent danger and my firearm won't fire.
Every time I've known if someone to have dreams of this type this has been the cure. Likely something to do with doubt or insecurity regarding one's shooting abilities.