@UğurKARAMAN - perform an Oracle Trace, and perform a sde intercept and then open a ticket with Esri Support to investigate the issue further.
How To: Set up Intercept Log Files on a Machine Running ArcGIS pro or ArcMap
Note, you did not informed the ArcSDE Repository Version of your geodatabase and also did not informed the ArcGIS Pro version that you are using, depending on the version combination here you will run into issues and you must upgrade the ArcSDE Repository using the ArcGIS Pro version that you are using, read more in the link below.
https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/client-geodatabase-compatib....
https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-oracle.htm
If you need to upgrade the Geodatabase ArcSDE Repository to match the version of the ArcGIS Pro that you are using, then read my blog post below, make sure the geodatabase has no invalid objects, especially the sde user which is the arcsde repository owner.
Oracle eGDB SDE Repo Upgrade Using Oracle Restore Point | Download PDF Version
How to Move the Oracle Enterprise Geodatabase with the Oracle Data Pump Utility
I hope this helps.
| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "About: In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 33 years, my passion for Spatial Databases and GIS data has become a central part of my career.." | “ The mountains are calling and I must go.” – John Muir |
