Awarding the Nobel Peace Prize to US President Barack Obama in 2009 failed to achieve what the committee hoped it would, its ex-secretary has said.