SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

External procedure call error in RAC

800918Sep 27 2010

I met a strange problem today with Oracle RAC 10.2.0.4:

Situation I:
In the sequence of tnsnames.ora or TAF, put NodeA before NodeB, everything works well. Even if NodeA is down and only NodeB works.

Situation II:
If put NodeB before NodeA, strange things happened.
1) I can connect to via type2(tnsnames) or type4(url) via sqlplus, and I can also call my extproc in sqlplus.
2) If I call external procedure via API, whatever type2 or type4, it will report "ORA-06576: not a valid function or procedure name"

RAC should share anything on both nodes, why Situation I and Situation II have different behaviour? Can anyone help me? Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2010

Added on Sep 27 2010

0 comments

265 views