Discussion :

[agdid04]

Bonjour,

A la fin de l'execution de catupgrd pour passer à 11.2.0.3, j'ai ce message:

DOC>##############################################
DOC>
DOC>   The above sql script is the final step of the upgrade. Please
DOC>   review any errors in the spool log file. If there are any errors in
DOC>   the spool file, consult the Oracle Database Upgrade Guide for
DOC>   troubleshooting recommendations.
DOC>
DOC>   Next restart for normal operation, and then run utlrp.sql to
DOC>   recompile any invalid application objects.
DOC>
DOC>   If the source database had an older time zone version prior to
DOC>   upgrade, then please run the DBMS_DST package.  DBMS_DST will upgrade
DOC>   TIMESTAMP WITH TIME ZONE data to use the latest time zone file shipped
DOC>   with Oracle.
DOC>
DOC>#############################################
DOC>#############################################
SQL>
SQL> Rem Set errorlogging off
SQL> SET ERRORLOGGING OFF;
SQL>
SQL> REM END OF CATUPGRD.SQL
SQL>
SQL> REM bug 12337546 - Exit current sqlplus session at end of catupgrd.sql.
SQL> REM                This forces user to start a new sqlplus session in order
SQL> REM                to connect to the upgraded db.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Quelle la criticité de ce bug (bug 12337546) ? y a un patch correctif ?

Je reprends dans une autre session sqlplus la compiliation d'objets invalides ....?

Merci.

[Chtulus]

Bonjour,

bug 12337546 - Exit current sqlplus session at end of catupgrd.sql. This forces user to start a new sqlplus session in order to connect to the upgraded db.