PL/SQL

Oracle 11g R2: catupgrd.sql running for hours

During the last weeks, I was confronted to an uncommon bug during the database upgrade from security sensibledatabases. The upgrade was sticking for hours on the script c1101000.sql.  which tried to fill the column DBID with the database DBID of(…)

Getting rid of network acces issues after migrating to Oracle 11.2

Are you experiencing network access issues after a migration to Oracle Database 11g Release 2 (11.2)? If yes, you probably have to allow the concerned PL/SQL packages to access your network again. This posting will show you how.