Oracle SOA DB Poller Error-Caused by BINDING.JCA-11608 Connection Already Closed Exception.

Error :
 BINDING.JCA-11624[[
DBActivationSpec Polling Exception.
Query name: [pollALPSelect], Descriptor name: [pollALP.IfAlpOwner]. Polling the database for events failed on this iteration.
Caused by BINDING.JCA-11608
Connection Already Closed Exception.
This [javax.resource.cci.Connection] is already closed.
This should not happen when running within a packaged application like BPEL or ESB but may occur when the adapter is used standalone.

Reason :
 Made changes to the weblogic server data source / Connection factory leads to a DB adaptor redeploy and that DB adaptor incidences will fail with the same error.


Solution :
Retire all DB Pollers which have encountered this error.
Activate all DB  Pollers.

The issue will be fixed.

ADRS_DOMAIN_PASSWORD environment variable not set in SOA Suite 12.2.1

 I have installed the JDeveloper on Windows10 but hitting an issue while I try to start the server (Integrated Web logic Server). The below is the error message:

Process started
wlst > 
wlst > Initializing WebLogic Scripting Tool (WLST) ...
wlst > 
wlst > Welcome to WebLogic Server Administration Scripting Shell
wlst > 
wlst > Type help() for help on available commands
wlst > 
wlst > Failed to get environment, environ will be empty: (0, 'Failed to execute command ([\'sh\', \'-c\', \'env\']): java.io.IOException: Cannot run program "sh": CreateProcess error=2, The system cannot find the file specified')
wlst > Error:  ADRS_DOMAIN_PASSWORD environment variable not set.
wlst > 
wlst > 
wlst > Exiting WebLogic Scripting Tool.
wlst > 
wlst > Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=384m; support was removed in 8.0
Elapsed time:  12308 ms

Cause

Weblogic jython libraries do not recognize the operating system.

Solution

Oracle generated the patch 22138883. This patch fixes the problem ...

You could follow the steps as below (Added all the steps since I have seen may of the post reference links are missing or removed from corresponding sites), Steps to follow: Copy jython-modules.jar file from "\WL_Home\wlserver\common\wlst\modules*" as a backup. Unzip it (Use Winrar, 7-zip., etc) Open javashell.py file in editor from unzipped folder "Eg:\WL_Home\wlserver\common\wlst\modules\jython-modules\Lib" Search for the following text "_osTypeMap". _osTypeMap = ( ( "nt", ( 'nt', 'Windows NT', 'Windows NT 4.0', 'WindowsNT', 'Windows 2000', 'Windows 2003', 'Windows XP', 'Windows CE', 'Windows Vista', 'Windows Server 2008', 'Windows 7', 'Windows 8', 'Windows Server 2012')), ( "dos", ( 'dos', 'Windows 95', 'Windows 98', 'Windows ME' )), ( "mac", ( 'mac', 'MacOS', 'Darwin' )), ( "None", ( 'None', )), ) Add 'Windows 10' next to the 'Windows Server 2012' as mentioned below, _osTypeMap = ( ( "nt", ( 'nt', 'Windows NT', 'Windows NT 4.0', 'WindowsNT', 'Windows 2000', 'Windows 2003', 'Windows XP', 'Windows CE', 'Windows Vista', 'Windows Server 2008', 'Windows 7', 'Windows 8', 'Windows Server 2012','Windows 10')), ( "dos", ( 'dos', 'Windows 95', 'Windows 98', 'Windows ME' )), ( "mac", ( 'mac', 'MacOS', 'Darwin' )), ( "None", ( 'None', )), ) Open the command prompt mostly in admin mode, then execute the command jar –cvf jython-modules.jar * as show in image below (Make sure your jdk path shouldn't have any space, I have faced issue so just copied complete jdk fodler into C-Drive),  Copy the latest jar file which is generated in "WL_HOME\wlserver\common\wlst\modules\jython-modules" into "WL_HOME\wlserver\common\wlst\modules". Now start the IntegratedWebLogicServer from yout JDeveloper. It will create based on new domain credentials and you could able to access the server console after successful creation of domain.