Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Migration database issue

edited Dec 8, 2014 9:33AM in Database Install/Upgrade/Opatch (MOSC) 5 commentsAnswered ✓


Hello,

following id:1188535.1

Migration:

     Migration database

     5-(Option A) Migrate windows 32-bit database to windows x64

          5.h. Run %ORACLE_HOME%/drbms/admin/utlirp.sql to invalidate the PL/SQL modules

==> face the below issue

******************************************************************************************************************

SQL> @utlirp.sql
SQL>
SQL> WHENEVER SQLERROR EXIT;
SQL>
SQL> DOC
DOC>#######################################################################
DOC>#######################################################################
DOC>   The following statement will cause an "ORA-01722: invalid number"
DOC>   error if there the database was not opened in UPGRADE mode
DOC>
DOC>   If you encounter this error, execute "SHUTDOWN", "STARTUP UPGRADE" and
DOC>   re-execute utlirp.sql
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SQL> SELECT TO_NUMBER('MUST_BE_OPEN_UPGRADE') FROM v$instance
  2  WHERE status != 'OPEN MIGRATE';

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center