Is a cold shawer sober up a drunk person?

No, the only thing that can sober up a drunk person is time (provided he/she has a working liver). Cold showers or coffee or anything else do not work.