Hello everyone,
I am installing Enterprise Manager Cloud Control 13c on a Windows Server 2012 R2**.** The initial time I tried to install Cloud Control, the installation froze at 50%. I exited the installation process (making the environment a lot less clean), and I have been now trying to reinstall and make the environment clean again. I was able to fix a number of issues, but this one eludes me. When connecting to my PDB, the install stops and give me this problem:
From my understanding, I need to drop ALL public synonyms.
I have tried searching, and I know "drop public synonym <synonym you wish to drop> but can't find a way to simply drop ALL public synonyms.
I am not very familiar with SQL scripting, and am not able to write a script to do it. Could you either point to me to a command to do that, or show me the script?
Many thanks for your time!