It is not advisable to run those scripts. But still if you want to, have a good physical backup and proceed.
Before do anything that you don't know, please read about what you will do:
CATALOG.sql --> create the view of the data dictionary tables (DBA_XXXX), grant public access to synonyms and create public synonyms.
CATPROC.sql --> execute all scripts used with PL/SQL
UTLRP.sql --> recompile invalid objects.
VALIDATE "Oracle Database Packages and Types" won't solve your bug problem, but will validate the package.
Then what could be possible fix.
Thanks in ADV
1) apply patch to fix the bug
2) upgrade database
3) contact with oracle support for any workaround
SUPRIYO DEY wrote:
Yes i agree
Then it is better that you edit and remove the pasted link as it would only create confusion for subsequent reader(s) .
We have a client with 22.214.171.124 and server with 126.96.36.199 DB.
issue: select * from t1@db_link where t1_name like '%Ram'; fails with ora -03113 end-of-file communication channel.
select * from t1@db_link where t1_name='Ramgoel'; works fine.
What could be the possible fix?
Thanks in ADV.
I guess you are from Oracle itself, why can't you refer to MOS support links and existing bugs
Verify with your peers in your team
- Pavan Kumar N
Thanks for your update.
Nothing found in Metalink. May be new bug.