Not an apex domain
The domain ns6.p200.dns.eu-madrid-2.oci.oraclerealm.eu is not the root of its zone.
Instead, try zone transfer on eu-madrid-2.oci.oraclerealm.eu .
Instead, try zone transfer on eu-madrid-2.oci.oraclerealm.eu .