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.
Printable View
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.
@$ORACLE_HOME/rdbms/admin/utlrp.sql
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.
This is wat oracle does when u run Utlrp.sql...Quote:
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.
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.
No need to run catproc unless the invalid objects belong to sys...Quote:
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 ?
Can i run CATPROC.SQL when the users are connected ? if u have any
other script ,pls.send it.
thanx in adv
prasad.
try compiling individual objects and see what error it shows after compiling...
use show error... :)
most possible reasons (other than logical error and syntax error) are lack of grants like select,insert,update,delete or execute.
HTH
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)Quote:
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
And if some objects cannot be compiled with UTLRP.SQL, then they have errors that need to be fixed.
sometimes you have to run utlrp several times to compile all invalid objects
Why?Quote:
Originally posted by pando
sometimes you have to run utlrp several times to compile all invalid objects
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