Hi, Iam facing frequent problem of getting DB objects Invalid. The database is Oracle 10g RAC on Solaris OS. The application is under development stage and the schema is having all the necessary previleges. Executing utlrp.sql temporarily resolves this problem.
The parameter, PLSQL_CODE_TYPE is set to INTERPRETED.
My question is, Can I set this parameter to NATIVE in RAC environment. I came to know that by setting this parameter to NATIVE resolves the Invalid objects issue.
If this is true, what are the other parameters to be set. Like
PLSQL_NATIVE_LIBRARY_DIR, does the directory path should be on shared storage as this is RAC environment?
thanks,