I recently setup a All-in-One AdminServer to save some resources of my laptop for Oracle SOA Suite 11g, before i was running AdminServer and other Managed Servers as separate engines which eats up all the memory. So by googling and asking experts thanks to Edwin Biemond he suggested me the solution is to merge all ManagedServers into the a single AdminServer.
Steps can be found at this blog and Oracle wiki
so, to end the story i created a new domain with the configuration but was unable to start the new domain i thought problem with existing domain so i deleted my existing old domain that i created before.
We will look at the deleting domain step as well as the fix later.
Deleting a Oracle Weblogic Server Domain:
- Deleting a WLS domain is not a rocket science its just a configuration files so for this only delete the directories exists on your machine.
\user_projects\domains\domain_nameIn my case i deleted the directory soa_domain11g E:\Oracle\Middleware\user_projects\domains\soa_domain11g
- Delete the domain name from the "nodemanager.domains" file, the file exists on the following location
\In my case it is E:\Oracle\Middleware\wlserver_10.3\common\nodemanager \common\nodemanager\
Problem table verify failed for table 'WL_LLR_ADMINSERVER'
- Still i was unable to run the AdminServer by looking at the log file following error was appearing
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 'soadev//AdminServer' expected 'soa_domain11g//AdminServer'*** ONLY the original domain and server that creates an LLR table may access it ***
After googling found a easy fix
- Connect to DEV_SOAINFRA schema and update the name to new domain name. Note: The prefix DEV depends on your prefix while you installed SOA Suite repository
update WL_LLR_ADMINSERVER set RECORDSTR = 'soadev//AdminServer' where XIDSTR = 'JDBC LLR Domain//Server'; commit;
Hope it helps,