Ultracet is prescribed to relieve moderate to moderately severe pain. It contains two pain-relieving agents. Tramadol, known technically as an opioid analgesic, is a narcotic pain reliever. Acetaminophen is the active ingredient in the over-the-counter pain remedy Tylenol.