Database Administration (MOSC)

MOSC Banner

ORA-00955 being returned running utlrp.sql

edited Feb 25, 2013 6:02AM in Database Administration (MOSC) 5 commentsAnswered ✓
This error was being returned infrequently when the utlrp.sql script was being executed, but it has started being returned every time the script is run on just one of our databases.  There are no invalid objects on the database.   I thought it might be caused by the same recompile command being executed at the same time by another process, but this is not the case.

Platform information:

   Oracle EE 10.2.0.5 on Linux RH 5

Command being executed from a Linux shell script:

recompile()
{
sqlplus -s / as sysdba <<EOF
@$ORACLE_HOME/rdbms/admin/utlrp.sql
exit;
EOF
}

Messages/Error Returned:

 

TIMESTAMP

--------------------------------------------------------------------------------

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