NP_SOAINFRA.WL_LLR_ADMINSERVER Access Failed

 java.sql.SQLException: JDBC LLR, table verify failed for table ‘NP_SOAINFRA.WL_LLR_ADMINSERVER’, row ‘JDBC LLR Domain//Server’ record had unexpected value

The above error appeared when trying to start Adminserver nothing changed on the Domain

Solution :-

  • Goto  domain location –> config folder.
  •  remove this line from the config.xml file, Take backup before you do this.


    wlsbjmsrpDataSource
    AdminServer,osb_server1
    jdbc/wlsbjmsrpDataSource-jdbc.xml
 

Thank you
Osama Mustafa 

Oracle Application Adapter installation.

Regarding to Oracle Documentation :-

The Application Adapter installer for 11g Release 1 (11.1.1.3.0) is applicable for the Oracle Service-Oriented Architecture (SOA) Suite and Oracle Service Bus (OSB). The Application Adapters that are installed can be used with Business Process Execution Language (BPEL), Mediator, Business Process Management (BPM), and OSB components. Using this installer, Application Adapters can be installed in a standalone SOA environment, standalone OSB environment, or mixed (SOA and OSB) environment.

You can check from here

The installation is not that hard , it’s all about configuration. i will post about later.

You Can Download it from here.

Operating system : Oracle Linux.

Installation Steps :-

As You see you should installed Oracle SOA Or Oracle OSB.
If you are using Oracle SOA the path will be like the below :-
\Oracle_SOA1\
For Oracle OSB :-
\Oracle_OSB1\
Be Notice this application installed in the following Path :-
\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\
Thank you 
Osama mustafa