Archive

Archive for September, 2012

ORA-28528: Heterogeneous Services datatype conversion error

September 28, 2012 Leave a comment

My database version 11gR2.0.2, there is a db link connecting to a postgre db. Once issue select * from testing_table. The errors returns

ORA-28528: Heterogeneous Services datatype conversion error
ORA-02063: preceding line from NICEIEXLK

Solution.

Add the optional below into HS agent configuration ($ORACLE_HOME/hs/admin). The problem is fixed. The details refer to the Oracle Support (Datatype Conversion Error ORA-28528 Using Dg4odbc With Informix, MySQL or SQL*Server 64-bit ODBC Drivers on Unix Platforms [ID 55440])

HS_FDS_SQLLEN_INTERPRETATION=32

Categories: ORA-XXX

FAL[client, ARC3]: Error 16191 connecting to dbm for fetching gap sequence

September 17, 2012 Leave a comment

When I start the standby database,  I got the message below from alert file

 

Error 1017 received logging on to the standby
————————————————————
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
————————————————————
FAL[client, ARC3]: Error 16191 connecting to dbm for fetching gap sequence

 

The root cause is that the password of SYS for standby database is not same the one of master. After sync. the SYS password between master and standby. The problem is fixed.

 

Categories: Data Guard