Thursday, 23 March 2017


here are my notes on how to recompile if that helps
Compiling invalid objects  1. Log on to sqlplus and run : SELECT COUNT  FROM obj$ WHERE status IN (4, 5, 6);
This will show how many objects in database are in invalid state.
2. Run SELECT COUNT  FROM UTL_RECOMP_COMPILED; to find objects in valid state.
3. Run $ORACLE_HOME/rdbms/admin/utlrp.sql script in sqlplus to compile all objects in one go.
This script identifies the object dependency and opens up multiple session depending upon number of CPUs.
4. In large systems, compilation takes lot of time. To monitor the progress run the sqls in item 1 & 2 from a different SqlPlus session.
5. After the utlrp.sql script finishes execution, run again the first Sql to see if there are any invalid objects.
6. If any, run select OWNER,OBJECT_NAME,OBJECT_TYPE from dba_objects where STATUS='INVALID'; and send it to ASGs to determine what those objects are and what they intend to do. As far as DBA's role is concerned, we can do nothing in getting it compiled other than running select * from UTL_RECOMP_ERRORS; and letting ASG know the output.
.
which is what i ran for you



How to check if certificate is going to be expired or not

In Internet Explorer

  1. Go to Tools > Internet Options.
  2. Click the Content tab, then click the Certificates button (middle of the window).
  3. In the Certificates window, click the Personal tab.
    Result: Your personal certificates should be listed. The expiration date is given in the column headed "Expiration Date".
  4. Close the Certificates window, then click OK in the Internet Options window.

No comments:

Post a Comment