Dear All
I don't know did anyone come across the Oracle Error ORA 03123 (operation would block),ORA03127 (no new operation allow...) before?
I get this error when I try to access data from a remote database using 3rd party non oracle supply SQL client software:-
We use the normal select * from <table>@<db_link> statement (execute from the 10g 10.2.0.3.0 database) to retrieve records belongs to 10g express database.
If I execute the same select statement but via a 9i db (using 3rd party SQL client software again), everything work okay.
The strange thing is if I use Oracle SQL*plus, it works fine for both 9i and 10g db.
I search on google, some people say that some SQL client software may not be able to handle multi-thread problem, can that be the reason why? I thought 9i also use multi-thread query too?
It is my first time installing an Oracle database, can it be some setting I need to do for the 10g database to allow 3rd party SQL client software to work, did I need to set PGA or SGA correctly?
regards
Ivan