Hello All,
I am working on Oracle 11g Exadata (11.2.0.4) RAC environemnt.
I have a procedure, which is calling from database orcl1 and inserting record in database orcl2 via dblink2.
I am often getting below error:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-03150: end-of-file on communication channel for database link
ORA-02063: preceding line from dblink5
Point is i dont have dblink5 anywhere in schema, nor using it anywhere in my code, it is present in another schema which i am not using.
Same is not replicating in lower environments and in production it is irregular so cannot trace it.
However, i have added some debug pointers and exception to catch this issue and write sqlerrm in one temporary table, but cannot deploy it in production right now.
I wanted to know what are the causes of this issue, or is there any other way to troubleshoot this.
Thanks