Re: database link problem from unix to nt (ORA-03113)

From: Uchakra <uchakra_at_aol.com>
Date: 02 Feb 2001 04:33:22 GMT
Message-ID: <20010201233322.18449.00000357@ng-mj1.aol.com>

I had an experience which could
give some clues although it was not
like your situation.

Because of some firewall issue, I was
not able to do sqlplus over two hops
( i.e, from one machine to a second machine via an intermediate machine
( ALL NT servers ).

To keep the long story short, eventually the solution was to add two different
network cards to the intermediate box,
where Machine1 used the first NC to
communicate with the intermediate box and the machine2 used the second network card to communicate with the intermediate box and thereby, Machine1 and Machine2 were able to communicate via the intermediate box,

e.g

from Machine1 database
sqlplus>connect database_at_intermediate
sqlplus> from intermediate connect
database_at_machine2

---

from machine1 database sqlplus_at_machine2 database was not allowed because these two were in
incompatabile segments.

Hope, this weird, meandering story
throws some light into your problem.
I personally won't enjoy going through this convoluted situation any more. However,
a DBA's life is going to be always full of fun like this.

Regards
Willy Received on Thu Feb 01 2001 - 22:33:22 CST