/etc/rhn.conf

comment out oci and add thin

#hibernate.connection.driver_proto=jdbc:oracle:oci
hibernate.connection.driver_proto=jdbc:oracle:thin

satellite-sync needs this to work

use_database_cache= 0
sat_cert_generation = 4

/usr/share/rhn/search/classes/com/redhat/satellite/search/db/config.xml

change this line

<property name="JDBC.ConnectionURL" value="${search.connection.driver_proto}:@${db_name}"/>

to this

<property name="JDBC.ConnectionURL" value="${search.connection.driver_proto}:@localhost:1521:xe"/>