Application Development Software

Hi,

I apologize if the question has been posted and answered.. I had searched but couldn't find anything in this forum.

My post is a bit lengthy as I will be providing as much details as possible.. sorry about that.. :)

I am new to Weblogic server and Weblogic Portal.. in fact I have never worked on portals. I have installed the Weblogic Portal 10.3.2 along with the Weblogic. I have used quickstart to create a domain. There I have configured the following data sources:

appsGroupSpaceDataSource
cgDataSource
cgDataSource-nonXA
p13nDataSource
portalDataSource
portalDataSourceAlwaysXA
portalDataSourceNeverXA

My database is oracle 11g. I have created a user and granted the user all the admin roles and priviledges

The database connection test had worked for all the sources except appsGroupSpaceDataSource where the test query SELECT COUNT(*) FROM SYSTABLES failed as there was no such table in the database.

I had run the following scripts:

Drop/Create Groupspace Database Objects (appsGroupSpaceDataSource )

Drop/Create P13N Database Objects (p13nDataSource)
Drop/Create Content Database Objects (p13nDataSource)
Drop/Create Portal Database Objects (p13nDataSource)

There were no scripts to run for the other data sources.

After installation whenever I am starting the admin server I am seeing this error in the console:

<Sep 17, 2010 12:48:05 PM IST> <Error> <JDBC> <BEA-001112> <Test "SELECT COUNT(*) FROM SYSTABLES" set up for pool "appsGroupSpaceDataSource" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
".>
<Sep 17, 2010 12:48:05 PM IST> <Error> <JDBC> <BEA-001112> <Test "SELECT COUNT(*) FROM SYSTABLES" set up for pool "cgDataSource" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
".>
<Sep 17, 2010 12:48:06 PM IST> <Error> <JDBC> <BEA-001112> <Test "SELECT COUNT(*) FROM SYSTABLES" set up for pool "cgDataSource-nonXA" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
".>
<Sep 17, 2010 12:48:06 PM IST> <Error> <JDBC> <BEA-001112> <Test "SELECT COUNT(*) FROM SYSTABLES" set up for pool "p13nDataSource" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
".>
<Sep 17, 2010 12:48:07 PM IST> <Error> <JDBC> <BEA-001112> <Test "SELECT COUNT(*) FROM SYSTABLES" set up for pool "portalDataSource" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
".>


And the errors are happening in an infinite loop....

I checked and there is no table created in that name in the database.. and being totally new to weblogic I am not sure where else to check.

It would be great if some one could help me track the cause and resolve this..

Thanks a lot for reading the long post.. and double thanks for a reply.. :)

Edited by: 795423 on Sep 17, 2010 12:17 AM