Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Getting error while executing catupgrd.sql script for upgrading database 11.2.0.1 to 11.2.0.4

edited Dec 15, 2014 10:02AM in Database Install/Upgrade/Opatch (MOSC) 3 commentsAnswered

Hi ,

While executing @catupgrd.sql script to upgrade oracle database from 11.2.0.1 to 11.2.0.4 , I am getting the below error

SQL> Rem If Intermedia upgrade, first install XML if it is not loaded

SQL> BEGIN

  2     IF dbms_registry.is_loaded('XML') IS NULL AND

  3        (dbms_registry.is_loaded('ORDIM') IS NOT NULL OR

  4         dbms_registry.is_loaded('SDO') IS NOT NULL) THEN

  5       :dbinst_name := dbms_registry_server.XML_path || 'initxml.sql';

  6       INSERT INTO sys.registry$log -- indicate start time

  7                  (cid, namespace, operation, optime)

  8              VALUES ('XML', SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),

  9                         -1, SYSTIMESTAMP);

10       COMMIT;

11    ELSE

12       :dbinst_name := dbms_registry.nothing_script;

13    END IF;

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