Oracle has appointed a pair of co-CEOs to take over the C-suite as longtime chief Safra Catz transitions to a new role as executive vice chair.