Wednesday, September 21, 2011

ORA-03115:unsupported network datatype or representation in toad 9.6

Cause: A user bind or define, or an Oracle function, is not supported by this heterogeneous Net8 connection.

Action: Upgrade the older version of Oracle and try again.


Problem:-
i am connecting remote oracle database 10g using oracle developer 6i home as a "installed clients" conncetion location in Toad.
its give me this above error, when i am trying to execute AWR report via toad.


Solution:
after then I change the conncetion location home to "oraDB10g_home" in replace of developer 6i home.
then above error is gone.

so this problem is happen for lower version of installed clients net8 connection home.

2 comments:

jo said...

hi,
may i ask, where's the "connection location home" was located?
thx

halimdba said...

first you should install oracle 10g client or database to your machine.
after then you can find this "oracle home" name to your "installed clients" conncetion location in Toad. just select it.

"connection location home" means oracle client or database installed home name in "installed clients" of toad.