Soporific means causing drowsiness or sleepiness (sedative, sleep-inducing). The antonym is therefore 'active' or 'stimulating' - something that keeps you awake rather than putting you to sleep. 'Sedative', 'sleepy', and 'narcotic' are all synonyms, not antonyms.