-
Invalid Procedures......
Hi all,
I am getting INVALID PROCEDURES suddenly in my database. I think
RPC execution has been terminated. What I have to do get the valid
procedures in my database ?
Thanx in Adv
prasad.
Prasad
-
Re: Invalid Procedures......
@$ORACLE_HOME/rdbms/admin/utlrp.sql
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Hi
When i run Utlrp.sql then some of the procedures get valid and others are not. What I have to do to compile invalid procedures ?
Can i run CATPROC.SQL when the users are connected ? if u have any
other script ,pls.send it.
thanx in adv
prasad.
Prasad
-
Originally posted by prasadvd
Hi
When i run Utlrp.sql then some of the procedures get valid and others are not. What I have to do to compile invalid procedures ?
prasad.
This is wat oracle does when u run Utlrp.sql...
Rem NAME
Rem utlrp.sql - UTiLity script Recompile invalid Pl/sql modules
Rem
Rem DESCRIPTION
Rem This is a fairly general script that can be used at any time to
Rem recompile all existing invalid PL/SQL modules in a database.
Rem
I dont think recompling aging would bring them to valid state...
find the root cause of procs being in invalid state...
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
-
Amar,
I am getting following error when i try to execute invalid proc individually.
Error at line 1:
ora-01436:Connect by loop in user data
ora-06512:at "SYS.DBMS_UTILITY" LINE 195
ORA-06512:AT LINE 1
Processing invalid object
===========================
sqlplus kesav/kesav<
prompt Compiling kesav Objects....
execute dbms_utility.compile_schema('KESAV');
show err;
quit;
eof;
What is the solution u suggest ?
prasad
Prasad
-
Originally posted by prasadvd
Amar,
I am getting following error when i try to execute invalid proc individually.
Error at line 1:
ora-01436:Connect by loop in user data
ora-06512:at "SYS.DBMS_UTILITY" LINE 195
ORA-06512:AT LINE 1
Processing invalid object
===========================
sqlplus kesav/kesav<
prompt Compiling kesav Objects....
execute dbms_utility.compile_schema('KESAV');
show err;
quit;
eof;
What is the solution u suggest ?
prasad
Run it as SYS (as sysdba)
And if some objects cannot be compiled with UTLRP.SQL, then they have errors that need to be fixed.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
sometimes you have to run utlrp several times to compile all invalid objects
-
Originally posted by pando
sometimes you have to run utlrp several times to compile all invalid objects
Why?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Well what it happens to me many times is once I had 200 invalid objects in Orace Financials, after first utlrp it left with around 100 invalid objects, after second around 30 were left it was in the third utlrp which compilaed all succesfully.
In fact when we release new procedures, functions and packages to production it is not unuusal es we have to run our own compile several times. So in our home-made compile script it cycles untl all objects are compiled
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|