AMENDMENT NO. 2 TO THE AGREEMENT OF LIMITED PARTNERSHIP OF TITAN RESOURCES, L.P.