Oracle SOA Suite 11g, wrong settings after re-installation of SOA domain

During my installation of the 11g SOA Suite, things go bad once in a while and domains need to be created and removed, etc.

After last remove and new installation of my domain i got the next error message during startup of the Admin Server :

javax.transaction.SystemException: 
weblogic.transaction.loggingresource.LoggingResourceException: 
java.sql.SQLException: JDBC LLR, table verify failed for table 'WL_LLR_ADMINSERVER', row 
'JDBC LLR Domain//Server' record had unexpected value 'soa11g_new_domain//AdminServer' expected 
'soa_domain//AdminServer'*** ONLY the original domain and server that creates an LLR table
may access it ***

Easy fix would be :

Start sqlplus and connect to ‘DEV_SOAINFRA’ schema.

update WL_LLR_ADMINSERVER
set    RECORDSTR = 'soa_domain//AdminServer'
where  XIDSTR    = 'JDBC LLR Domain//Server';

commit;
Advertisements

About Eric Elzinga
Eric Elzinga I'm an integration consultant located in The Netherlands. Mainly doing projects based on Oracle integration stacks (Oracle SOA Suite/Oracle Service Bus (OSB)), Java development, and opensource integration products.

8 Responses to Oracle SOA Suite 11g, wrong settings after re-installation of SOA domain

  1. Pingback: Oracle SOA Suite 11g, wrong settings after re-installation of SOA domain | Oracle .. Java .. OpenSource .. SOA

  2. Arvind says:

    Thanks ! This works for soa_server as well.

    We had to modify external server address and listen address to these values.

  3. Bikram says:

    Hey, thanks a lot for this solution. Worked like a charm. Even Oracle Discussion forums couldn’t solve this error. 😦

  4. Ruplim says:

    Hello Eric

    Thanks for the post. We saved lot of time.

  5. Mausami says:

    This solution worked magically. Thanks a lot !!!

  6. Alex says:

    Thank you very much…..saved the day ( and the next one 🙂 )

  7. Santosh says:

    Thank you very much …Cheers

  8. Phani Kumar says:

    Awesome. Thanks a lot for this post.. its saved my installation.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: