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


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])


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