Recently,i tried to install oracle soa 11g in 64 bit windows 7 (i love linux though ) .Everything went fine,but when configuring the domain for weblogic server,at step “Configure JDBC Component Schema” ,i got an error like this :
1. BAM Schema- Failed
2. SOA Infrastructure-Failed
3. User Messaging Service-Failed
4. OWSM MDS Schema-Failed
5. SOA MDS Schema-Failed
Component Schema=BAM Schema
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@localhost:1521/XE
User=DEV_ORABAM
Password=*******
SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’BAM’ and version=’11.1.1.6.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 Infrastructure
Driver=oracle.jdbc.xa.client.OracleXADataSource
URL=jdbc:oracle:thin:@localhost:1521/XE
User=DEV_SOAINFRA
Password=*******
SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’SOAINFRA’ and version=’11.1.1.6.0′
CFGFWK-60850: Test Failed!
CFGFWK-60853: A connection was established to the database but no rows were returned from the test SQL statement.
………
Solution:
This is most irritating error developers face while installing the software. I tried many different ways,and atlast with some deep thinking i came up with a solution.
Open the sql developer and connect the respective Schema User .First i will connect to
DEV_SOAINFRA
1. Now i used the query
select * from schema_version_registry;
to see the data in the table and figured out that there is a mismatch as the version in the table is less than the version it is comparing.
2. So i dropped the table
drop table schema_version_registry;
3. Then i created a new table and inserted a row :
create table schema_version_registry(owner varchar2(30),mr_type varchar2(10),version varchar2(50));
insert into schema_version_registry(owner,mr_type,version)values(‘DEV_SOAINFRA’,’SOAINFRA’,’11.1.1.6.0′);
4. Finally committed it.
Repeat the same step for other users as well . change the “mr_type” accordingly
And most important while doing the same for DEV_MDS you need to give the user admin rights like this:
select username from dba_users;
grant DBA to DEV_MDS;
then simply give this query :
update schema_version_registry set version=’11.1.1.6.0′; where owner= ‘dev_mds’;
Thats all . All the best 🙂