Oracle SOA - OSB -Problem during creating OSB domain Insufficient data while reading from the network - expected a minimum of 6 bytes and received only 0 bytes

SQL Test=SELECT 1 FROM SYS.SYSTABLES

If your database is Oracle 11g, then test SQL should be SELECT 1 FROM DUAL

I think you have not configured the datasource for Oracle DB, rather it is pointing to Derby database.

Make sure that while creating/extending the domain, on "Configure JDBC Component Schema" screen, you are selecting the checkbox against "OSB JMS Reporting Provider" and you are selecting "Oracle" as vendor. By default, "Derby" remains selected. Provide the connection details and click on next. On next screen, you test should be successful, and you should see lines similar to below -

Component Schema=OSB JMS Reporting Provider

Driver=oracle.jdbc.OracleDriver

URL=jdbc:oracle:thin:@localhost:1521:XE

User=DEV_SOAINFRA

Password=********

SQL Test=SELECT 1 FROM DUAL

CFGFWK-20850: Test Successful!