OraFAQ Forum: Server Administration » ORA-28527: Heterogeneous Services datatype mapping error

Home » RDBMS Server » Server Administration » ORA-28527: Heterogeneous Services datatype mapping error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-28527: Heterogeneous Services datatype mapping error [message #109824]

Tue, 01 March 2005 04:10

gnani
Messages: 3
Registered: March 2005
Location: india

Junior Member

I am trying to migrate my database from Oracle 8i to Oracle 9.2.
The oracle database communicates to a DB2 database using Java SDK 1.4. I am using a JDK1.4

JVM.

If I set ojdbc14.jar in the CLASSPATH, as is required for 9.2 and JVM 1.4, I get the

following error:
java.sql.SQLException: ORA-28527: Heterogeneous Services datatype mapping error

If I set classes12.jar in the CLASSPATH, it works fine.

Why am I not able to make the same stuff work with ojdbc14.jar. Any one has any inputs?

Report message to a moderator

Re: ORA-28527: Heterogeneous Services datatype mapping error [message #109848 is a reply to message #109824]

Tue, 01 March 2005 08:05

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

seems like oracle bug#1871365.
caths.sql is NOT run duirng upgdrade ( but is run by defualt with
9i installation) and hence you face certain issues with Heterogenous databases.

login as sys and check whether object dbms_hs_utl is valid.
Else
take a complete / valid backup.
and run $ORACLE_HOME/rdbms/admin/cath.sql ( logged in as sys).

UPDATE:

I believe you neet to run utlrp.sql following the cath.sql

[Updated on: Tue, 01 March 2005 08:06]

Report message to a moderator

Re: ORA-28527: Heterogeneous Services datatype mapping error [message #109854 is a reply to message #109848]

Tue, 01 March 2005 08:47

gnani
Messages: 3
Registered: March 2005
Location: india

Junior Member

hi Mahesh
Thank you for your reply
i checked dbms_hs_utl from user_objects , it is valid.

please tell me what backup we have to take before running that script(utlrp.sql,cath.sql)

Report message to a moderator

Re: ORA-28527: Heterogeneous Services datatype mapping error [message #109855 is a reply to message #109854]

Tue, 01 March 2005 09:01

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Following error:
>>java.sql.SQLException: ORA-28527: Heterogeneous Services datatype >>mapping error

could you post the complete error message, with the scenario ( like this error shoots when this statement is executed from this tool)??

did you login as sys and check the status?
and the script is caths.sql.
take any and all backup you can.
i mean cold backup/hotbackup/rmanbackup and export (if the volume of data is less).
It is your system...what if something goes wrong?
What if I AM completely wrong and your system crashes?
Its better to open a TAR with oracle support.

Report message to a moderator

Re: ORA-28527: Heterogeneous Services datatype mapping error [message #109856 is a reply to message #109854]

Tue, 01 March 2005 09:17

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

There is this other bug that occurs while querying ALL_VIEWS.
If it is applicable to you, apply the latest patchsets for 9i.
Again, before doing anything, always backup.

Report message to a moderator

Re: ORA-28527: Heterogeneous Services datatype mapping error [message #109942 is a reply to message #109856]

Wed, 02 March 2005 02:40

gnani
Messages: 3
Registered: March 2005
Location: india

Junior Member

hi
I am trying to migrate my database from Oracle 8i to Oracle 9.2
this is working fine.

At the same time is there any data changes in my database i have to update DB2 database using DBLINK,while updating db2 database i'm getting the error only data datatype field.

this is the error
ERROR during BO INSERT!!!
Main Table : if515t
if515_customer_id = DSLGG
java.sql.SQLException: ORA-28527: Heterogeneous Services datatype mapping error
ORA-02063: preceding line from E008DB8.ESB

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code))

NOTE:
the same code if i'm using classes12.jar it's working fine

the problem is we have to update db2 database also

Report message to a moderator

Re: ORA-28527: Heterogeneous Services datatype mapping error [message #109986 is a reply to message #109942]

Wed, 02 March 2005 10:46

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

My knowledge in java is very limited ( minuscule.. to be precise).
A contact of mine said to use

"oracle.jdbc.driver.OracleDriver"
Instead of
"oracle.jdbc.OracleDriver" for all jdk compliant systems.
I dont know what exactly it means.
I suggest you better open an TAR with oracle support.

Report message to a moderator

Previous Topic:	Tables and Table Counts
Next Topic:	Changing Database Owners

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 03:32:37 CST 2025