Home » RDBMS Server » Server Administration » Database upgradation (oracle10.2.0.5,windows x64)
Database upgradation [message #636944] Wed, 06 May 2015 06:01 Go to next message
surmaa013
Messages: 20
Registered: April 2015
Location: delhi
Junior Member
Hello All,

After upgradition of database from 10.2.0.3 to 10.2.0.5 . While running the script to check invalid object (utlrp.sql) .I got

OBJECTS WITH ERROS =61 .. IS it serious issue ? Here are some logs ..


DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
61

DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
0


PL/SQL procedure successfully completed.


Lalit : Fixed typo in topic title, upgradation is a single word.

[Updated on: Thu, 07 May 2015 01:08] by Moderator

Report message to a moderator

Re: Database up gradation [message #636946 is a reply to message #636944] Wed, 06 May 2015 06:04 Go to previous messageGo to next message
Michel Cadot
Messages: 66057
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
IS it serious issue ?


How many objects were in error before the upgrade?

Re: Database up gradation [message #636948 is a reply to message #636944] Wed, 06 May 2015 06:05 Go to previous messageGo to next message
gazzag
Messages: 1061
Registered: November 2010
Location: Bristol, UK
Senior Member
What does the following code now return?
SQL> SELECT owner, COUNT(*)
     FROM DBA_OBJECTS
     WHERE status!='VALID';
     GROUP BY owner
Re: Database up gradation [message #636958 is a reply to message #636946] Wed, 06 May 2015 07:18 Go to previous messageGo to next message
surmaa013
Messages: 20
Registered: April 2015
Location: delhi
Junior Member
WARNING: --> Database contains INVALID objects prior to upgrade.
.... USER CORALAPPS_REP has 4 INVALID objects.
.... USER OLAPSYS has 25 INVALID objects.
.... USER PUBLIC has 22 INVALID objects.
.... USER CORALAPPS has 45 INVALID objects.
.... USER SYS has 3 INVALID objects.
.

and after upgration


OWNER COUNT(*)
------------------------------ ----------
CORALAPPS_REP 4
CORALAPPS 55
SYS 2

and most are views ....
Re: Database up gradation [message #636959 is a reply to message #636958] Wed, 06 May 2015 07:23 Go to previous messageGo to next message
Michel Cadot
Messages: 66057
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Try to manually compile them.
Were they not invalid before upgrade?

Re: Database up gradation [message #636960 is a reply to message #636958] Wed, 06 May 2015 07:23 Go to previous message
gazzag
Messages: 1061
Registered: November 2010
Location: Bristol, UK
Senior Member
SQL> SELECT object_name, object_type, created
     FROM dba_objects
     WHERE status!='VALID' AND owner='SYS';
Previous Topic: User defined tables in System tablespaces
Next Topic: upgrade multiple databases of same oracle home from 11.2.0.1 to 11.2.0.3
Goto Forum:
  


Current Time: Tue Dec 18 17:36:26 CST 2018