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