Introduction:
During the installation of Oracle SOA Suite 11g, we saw errors related to a DRIVER_INFO error. Searching on the web revealed that this could be a RCU issue … however attempts to uninstall and reinstall the RCU Schemas caused nothing but more pain (errors related to missing Metadata repository, having to manually configure the data sources in Weblogic etc – I will recreate the scenario and blog about the errors and how to fix them soon).
Anyway, we still have problems with the DRIVER_INFO table … and are getting the following error (see below). If you look at the sql scripts in the RCU there is nothing for the DRIVER_INFO table.
So what is this table for and how do we install this? Could this be related to installing the Email/Messaging features? I am not sure yet but as soon as I find out more I will update this post.
Here’s my config -> OS: Windows 32-bit XP with 4GB RAM, quad core
Here are the errors:
"Error Code: 942
Call: SELECT DRIVER_NAME, MIME_TYPES, PROTOCOLS, CARRIERS, SENDER_ADDRESSES, COST, DELIVERY_TYPES, SPEED, STATUS_TYPES, CHECKSUM, SUPPORTS_CANCEL, ENCODINGS, SUPPORTS_REPLACE, SUPPORTS_TRACKING, SUPPORTS_STATUS_POLLING, DEFAULT_SENDER, CAPABILITY, LOCK_VERSION FROM DRIVER_INFO WHERE (DRIVER_NAME = ?)
bind => [Farm_soa_domain/soa_domain/soa_server1/usermessagingdriver-email:oracle_sdpmessagingdriver_email#Email-Driver]
Query: ReadObjectQuery(oracle.sdpinternal.messaging.config.DriverInfo)
at oracle.toplink.exceptions.DatabaseException.sqlException(DatabaseException.java:305)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:613)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:467)
at oracle.toplink.threetier.ServerSession.executeCall(ServerSession.java:447)"
Alok Mishra 