An emotional Rory McIlroy was left holding back tears after missing the cut in The Open at Royal Portrush by a shot following a valiant six-under par second round of 65.