Not an apex domain
The domain ns3.p200.dns.us-dcc-phoenix-2.oci.oraclerealm17.com is not the root of its zone.
Instead, try zone transfer on us-dcc-phoenix-2.oci.oraclerealm17.com .
Instead, try zone transfer on us-dcc-phoenix-2.oci.oraclerealm17.com .