OraFAQ Forum: Server Administration » Database upgradation

Home » RDBMS Server » Server Administration » Database upgradation (oracle10.2.0.5,windows x64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database upgradation [message #636944]

Wed, 06 May 2015 06:01

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

IS it serious issue ?

How many objects were in error before the upgrade?

Report message to a moderator

Re: Database up gradation [message #636948 is a reply to message #636944]

Wed, 06 May 2015 06:05

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

What does the following code now return?

SQL> SELECT owner, COUNT(*)
     FROM DBA_OBJECTS
     WHERE status!='VALID';
     GROUP BY owner

Report message to a moderator

Re: Database up gradation [message #636958 is a reply to message #636946]

Wed, 06 May 2015 07:18

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 ....

Report message to a moderator

Re: Database up gradation [message #636959 is a reply to message #636958]

Wed, 06 May 2015 07:23

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Database up gradation [message #636960 is a reply to message #636958]

Wed, 06 May 2015 07:23

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

SQL> SELECT object_name, object_type, created
     FROM dba_objects
     WHERE status!='VALID' AND owner='SYS';

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 20:56:02 CST 2025