The dismissal follows an investigation into a drunken incident, marking the second scandal for the Japanese oil giant in two years.