Skip to main content

utlrp scipts

utlrp script

+ What is UTLRP.SQL?
This script recompiles invalid PLSQL modules.

+ What this script does?
This script recompiles all existing invalid PL/SQL modules in a database.
This is a fairly general script that can be used at any time to recompile all existing invalid PL/SQL modules in a database If run as one of the last steps during migration/upgrade/downgrade this script will validate all PL/SQL modules (i.e. procedures, functions, packages, triggers, types, views, libraries) during the migration step itself.

+ Any other script called within UTLRP.SQL?
Yes. It invokes utlrcmp.sql

Where are these SCRIPTS located?
============================

The scripts are found in the standard admin directory of the Oracle Home.
$ORACLE_HOME/rdbms/admin

Which script is better?
=================

-> UTLRP.SQL - Validates all invalid objects and can be run anytime. (this in-turn is called by utlirp.sql)

What is invalid ? you can find out by doing this In sqlplus :
15:03:58 SQL> select Object_name, Object_type from dba_objects where status = ‘INVALID’ and OWNER <> ‘SYS’:

[ fayoubi on mars :] echo $ORACLE_HOME
/z01/app/oracle/product/10.2.0
[ fayoubi on mars :] ls -lrt $ORACLE_HOME/rdbms/admin/utlrp.sql
-rw-r–r– 1 oracle dba 3221 Aug 15 2003 /z01/app/oracle/product/10.2.0/rdbms/admin/utlrp.sql

Of course as oracle you can see the file:
[ fayoubi on mars :] vi $ORACLE_HOME/rdbms/admin/utlrp.sql

Comments

Post a Comment

Popular posts from this blog

Script to Collect Data Guard Physical Standby Diagnostic Information

Script to Collect Data Guard Physical Standby Diagnostic Information [ID 241438.1] -------------------------------------------------------------------------------- Modified 20-APR-2011 Type SCRIPT Status PUBLISHED Overview -------- This script is intended to provide an easy method to provide information necessary to troubleshoot Data Guard issues. Script Notes ------------- This script is intended to be run via sqlplus as the SYS or Internal user. Script ------- - - - - - - - - - - - - - - - - Script begins here - - - - - - - - - - - - - - - - -- NAME: DG_phy_stby_diag.sql -- ------------------------------------------------------------------------ -- AUTHOR: -- Michael Smith - Oracle Support Services - DataServer Group -- Copyright 2002, Oracle Corporation -- ------------------------------------------------------------------------ -- PURPOSE: -- This script is to be used to assist in collection information to help -
1 comment
Read more

ORA-01501: CREATE DATABASE failed

Problem: ======== During the creation of a new database the CREATE DATABASE command fails with the following errors: ORA-01501: CREATE DATABASE failed ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 406 ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 2192 bytes of shared memory ("shared pool", "unknown object","KQLS heap","KQLS MEM BLOCK") Solution: ========= 1. Increase the shared_pool_size parameter in the init .ora file. 2. Shutdown abort your database. 3. Startup nomount your database. 4. Execute the CREATE DATABASE command again. Explanation: ============ If your shared_pool_size is too small, the CREATE DATABASE command cannot finish successfully. This happens typically on small test instances when you just want to test anything on an empty instance and do not want to waste too much memory on a server. In this case you often edit in
Post a Comment
Read more