Weblogic Portal : 10.3.2 : Installation : SYSTABLES

" SELECT COUNT(*) FROM SYSTABLES; ORA-00942: table or view does not exist"

- Weblogic Server Domain Creation Wizard

You'll see this error when you are creating a Domain for Oracle Weblogic Portal 10.3.2.

The Weblogic Server DataSource uses this query to check if the connection is valid to a Database ( including an Oracle Database ! ) :-

SELECT COUNT(*) FROM SYSTABLES;

The error is so infuriating that at time, the Server forcefully shuts down quoting that the tables is not present. The Table is not required to be present in an Oracle Database.

Aw, well, you are in a tight deadline and you don't want to fuss over this :-

Go ahead and create a dummy table SYSTABLES in your Database Schema :-

CREATE TABLE SYSTABLES ( DUMMY NUMBER );

The Domain Creation Wizard is happy, you are happy and you can move ahead to more interesting tasks.

If you have spare time ( if you really have ), go ahead and take a look under the $WEBLOGIC_DOMAIN_HOME/config/jdbc folder - you'll see the XML files for your Data Sources. You can go ahead and change the Testing Query used in the files and bounce your server.