I'm upgrading our Oracle server to patch 18.104.22.168.0 and in the installation notes it states to start the server in migrate mode and run the catpatch.sql script. I though I could get away with this if I created my database after the 22.214.171.124.0 patch had been applied, however it seems that I must run the catpatch.sql on every database that is created after as I can't perform an import or export. Can anybody advise me?
You have to run catpatch.sql on your new instance only if you didn't create the new instance with the database configuration assistant. The DCA runs the script automatically while creating instances. But if you created the instance manually, the catpach.sql will not be executed.