Drop public synonym XMLCONCAT prior to upgrade

Thanks to my team mates, Cindy and Hector, who alerted me on this newly detected issue. When your database has been upgraded from release to release, it could happen that a public synonym XMLCONCAT exists. And before you upgrade to Oracle 12.2.01 or Oracle 18c you must drop this public synonym to avoid upgrade errors. Drop public synonym XMLCONCAT prior to upgrade The public synonym XMLCONCAT in pre-9.2.0.2 Oracle databases pointed to a PL/SQL function of the same name. In 9.2.0.2, this PL/SQL function was changed to a C function.The public synonym was no longer needed nor pointing to a…

Oracle Database Documentation – From Past to Present

Yesterday one of my colleagues, well known Data Guard Guru Larry “Murphy” Carpenter, sent out an internal email with links to older and recent Oracle Database Documentation. Reason why you should use the below links: Some sites in the www have stored copies of the doc – but some may represent not the most recent state or may not be complete. So stay with the official Oracle docs only: Oracle 8.0.6 http://www.oracle.com/technetwork/documentation/oracle8-090636.html Oracle 8.1.7 http://www.oracle.com/pls/tahiti/homepage Oracle 9.0.1 http://www.oracle.com/pls/db901/homepage Oracle 9.2.0 http://www.oracle.com/pls/db92/homepage Oracle Database 10.1.0 http://docs.oracle.com/cd/B12037_01/index.htm Oracle Database 10.2.0 http://www.oracle.com/pls/db102/homepage Oracle Database 11.1.0 http://docs.oracle.com/cd/B28359_01/index.htm Oracle Database 11.2.0 http://docs.oracle.com/cd/E11882_01/index.htm Oracle Database 12.1.0…