6 Replies Latest reply: Jul 8, 2013 4:31 AM by user100012345 RSS

    Error while configuring the domain "Configure JDBC Component Schema"

    deekay
      Hi can anyone please help me ...all the jdbc component schema is failing for me while creating domain.

      please find the log.

      " {
      Component Schema=SOA Infrastructure
      Driver=oracle.jdbc.xa.client.OracleXADataSource
      URL=jdbc:oracle:thin:@localhost:1521/XE
      User=sys as sysdba
      Password=*********
      SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type='SOAINFRA' and version='11.1.1.5.0'

      CFGFWK-60850: Test Failed!
      CFGFWK-60853: A connection was established to the database but no rows were returned from the test SQL statement.

      Component Schema=User Messaging Service
      Driver=oracle.jdbc.OracleDriver
      URL=jdbc:oracle:thin:@localhost:1521/XE
      User=sys as sysdba
      Password=*********
      SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type='ORASDPM' and version='11.1.1.2.0'

      CFGFWK-60850: Test Failed!
      CFGFWK-60853: A connection was established to the database but no rows were returned from the test SQL statement.

      Component Schema=OWSM MDS Schema
      Driver=oracle.jdbc.OracleDriver
      URL=jdbc:oracle:thin:@localhost:1521/XE
      User=sys as sysdba
      Password=*********
      SQL Test=select 1 from schema_version_registry where
      owner=(select user from dual) and mr_type='MDS' and
      version='11.1.1.5.0'

      CFGFWK-60850: Test Failed!
      CFGFWK-60853: A connection was established to the database but no rows were returned from the test SQL statement.

      Component Schema=SOA MDS Schema
      Driver=oracle.jdbc.OracleDriver
      URL=jdbc:oracle:thin:@localhost:1521/XE
      User=sys as sysdba
      Password=*********
      SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type='MDS' and version='11.1.1.5.0'

      CFGFWK-60850: Test Failed!
      CFGFWK-60853: A connection was established to the database but no rows were returned from the test SQL statement.

      }
      "