Not an apex domain
The domain ns2.p200.dns.me-dcc-doha-1.oci.oraclerealm21.com is not the root of its zone.
Instead, try zone transfer on me-dcc-doha-1.oci.oraclerealm21.com .
Instead, try zone transfer on me-dcc-doha-1.oci.oraclerealm21.com .