Oracle Enterprise Server not available

Just one thought came up due to consulting some friend: nice and complete OER installation done and service started but not available on host:7101/oer
In most of development cases everything installed on one machine (including DB) and OER might listen on loop-back address. Solution is easy - take a IP address of external host and configure listen on it (WL console -> OER server properties).

AIA 3.0 silent installation

Due to node manager was not working on some machine - needed to install only files and do silent installation

Pretty well described in user manual but took time to cut all scripts


1. antExit -f C:\\OracleHome\\Infrastructure\\Install\\AID\\AIACreateInstance.xml -DPropertiesFile=C:\\OracleHome\\aia_instances\\AIA\\config\\AIAInstallProperties.xml
2. antExit -f C:\\OracleHome\\Infrastructure\\Install\\AID\\AIAInstallDriver.xml -DDeploymentPlan=C:\\OracleHome\\config\\FPInstallDP.xml PreInstallScript -DPropertiesFile=C:\\OracleHome\\aia_instances\\AIA\\config\\AIAInstallProperties.xml
3. antExit -f C:\\OracleHome\\Infrastructure\\Install\\AID\\AIAInstallDriver.xml -DDeploymentPlan=C:\\OracleHome\\config\\FPInstallDP.xml Configurations -DPropertiesFile=C:\\OracleHome\\aia_instances\\AIA\\config\\AIAInstallProperties.xml -logfile=c:\\FPInstall.log
4. antExit -f C:\\OracleHome\\Infrastructure\\Install\\AID\\AIAInstallDriver.xml -DDeploymentPlan=C:\\OracleHome\\config\\FPInstallDP.xml Deployments -DPropertiesFile=C:\\OracleHome\\aia_instances\\AIA\\config\\AIAInstallProperties.xml -logfile=c:\\FPInstallDeploy.log
5. antExit -f C:\\OracleHome\\Infrastructure\\Install\\AID\\AIAInstallDriver.xml -DDeploymentPlan=C:\\Middleware11g\\config\\FPInstallDP.xml PostInstallScript -DPropertiesFile=C:\\OracleHome\\aia_instances\\AIA\\config\\AIAInstallProperties.xml -logfile=c:\\FPInstallPost.log
6. ant –f AIACreateInstance.xml -DPropertiesFile=C:\OracleHome\Oracle_SOA1/config/AIAInstallProperties.xml

7. In case would like to install DEMO: ant –f C:\OracleHome\Oracle_SOA1\samples\AIADemo\config\deployDemo.xml

For these actions would suggest to switch default java homes to 64bit (installed separately) due to fact memory requirements are over 2gb for single run.

AIA MetaData Manual Load/Update

Just to write down scripts:
WLST

connect('weblogic','weblogic1','t3://host:8001')

importMetadata(application='soa-infra',server='soaserver',fromLocation='C:\\bring\\AIAComponents\\**',docs='/apps/AIAComponents/**')

Error for each and every composite with BPEL after upgrade from 11.1.1.2 to 11.1.1.4

[2011-02-23T12:48:15.800+00:00] [soaserver] [ERROR] [] [oracle.soa.bpel.engine] [tid: weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@1f5176f] [ecid: 0000ItIYUTz0nny707V^6F1DPG1w000000,0] [APP: soa-infra] Unable to activate process ProvABCSImplProcess[[
ORABPEL-01005

Failed to compile bpel generated classes.
failure to compile the generated BPEL classes for BPEL process "ABCSImplProcess" of composite "default/ProvABCSImpl!1.0*4eb6b352-2814-4693-8d13-2a308c0e835a"
The class path setting is incorrect.
Ensure that the class path is set correctly. If this happens on the server side, verify that the custom classes or jars which this BPEL process is depending on are deployed correctly. Also verify that the run time is using the same release/version.

at com.collaxa.cube.lang.compiler.template.CubeProcessGenerator.compile(CubeProcessGenerator.java:304)
at com.collaxa.cube.lang.compiler.template.CubeProcessGenerator.generate(CubeProcessGenerator.java:164)
at com.collaxa.cube.lang.compiler.BPEL1Processor.transform(BPEL1Processor.java:257)
at com.collaxa.cube.lang.compiler.BPEL1Processor.process(BPEL1Processor.java:161)
at com.collaxa.cube.lang.compiler.BPEL1Processor.build(BPEL1Processor.java:514)
at com.collaxa.cube.lang.compiler.BPEL1Processor.handleLoadProblems(BPEL1Processor.java:485)
at com.collaxa.cube.lang.compiler.BPEL1Processor.loadProcess(BPEL1Processor.java:431)
at com.collaxa.cube.lang.compiler.BPEL1Processor.createCubeProcess(BPEL1Processor.java:367)
at com.collaxa.cube.engine.deployment.CubeProcessFactory.create(CubeProcessFactory.java:62)
at com.collaxa.cube.engine.deployment.CubeProcessLoader.create(CubeProcessLoader.java:111)
at com.collaxa.cube.engine.deployment.DeploymentManager.deployProcess(DeploymentManager.java:240)
at com.collaxa.cube.engine.deployment.DeploymentManager.deployComponent(DeploymentManager.java:185)
at com.collaxa.cube.ejb.impl.CubeServerManagerBean._deployOrLoadComponent(CubeServerManagerBean.java:818)
at com.collaxa.cube.ejb.impl.CubeServerManagerBean.deployComponent(CubeServerManagerBean.java:119)
at com.collaxa.cube.ejb.impl.bpel.BPELServerManagerBean.deployComponent(BPELServerManagerBean.java:87)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.bea.core.repackaged.springframework.jee.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:104)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor$1.run(JpsAbsInterceptor.java:94)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor.runJaasMode(JpsAbsInterceptor.java:81)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor.intercept(JpsAbsInterceptor.java:112)
at oracle.security.jps.ee.ejb.JpsInterceptor.intercept(JpsInterceptor.java:105)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.bea.core.repackaged.springframework.jee.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:69)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy275.deployComponent(Unknown Source)
at com.collaxa.cube.ejb.impl.bpel.BPELServerManagerBean_bp05wg_ICubeServerManagerLocalBeanImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:39)
at com.collaxa.cube.ejb.impl.bpel.BPELServerManagerBean_bp05wg_ICubeServerManagerLocalBeanImpl.deployComponent(Unknown Source)
at oracle.fabric.CubeServiceEngine.load(CubeServiceEngine.java:885)
at oracle.fabric.CubeServiceEngine.load(CubeServiceEngine.java:128)
at oracle.integration.platform.blocks.deploy.CompositeDeploymentConnection.deployComponents(CompositeDeploymentConnection.java:242)
at oracle.integration.platform.blocks.deploy.CompositeDeploymentConnection.deploy(CompositeDeploymentConnection.java:93)
at oracle.integration.platform.blocks.deploy.CompositeDeployerImpl.deploy(CompositeDeployerImpl.java:149)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at oracle.integration.platform.blocks.deploy.DeploymentEventPublisher.invoke(DeploymentEventPublisher.java:69)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy292.deploy(Unknown Source)
at oracle.integration.platform.kernel.FabricKernelInitializerServlet$1.run(FabricKernelInitializerServlet.java:524)
at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:120)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:183)
at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)

]]

1h later: what can I say - redeploy AIA (silent installation) and BPEL processes from jDev 11.1.1.4

Upgrade from 11.1.1.2 to 11.1.1.4

Lately did upgrade on Windows 7 from 11.1.1.2 to 11.1.1.4 - just for testing purposes. So, in total it took 1 day due to fact that fight for memory on 32bit java I lost. Needed to install 64bit version.
So some notes which comes up in my mind:
1. At least 6Gb RAM (WL takes only 600Mb, SOA Suite while starting require almost 2Gb);
2. All additional modules like OER/BAM and/or Webcenter easy to upgrade, schema upgrades went perfect comparing to 10g to 11g upgrade;
3. ..
Drafted..

UPGAST-01044: unable to connect to the target database

UPGAST-01044: unable to connect to the target database, Database user name: SYS AS SYSDBA IO Error: The Network Adapter could not establish the connection while upgrade DEV_MDS or DEV_SOAINFRA schema.

Some solutions say: ./psa -dbType Oracle -dbConnectString 'host:1521:serviceName' -dbaUserName sys -schemaUserName DEV_MDS

Right would be: ./psa -dbType Oracle -dbConnectString host:1521:serviceName -dbaUserName sys -schemaUserName DEV_MDS

weblogic 10.3.2 to 10.3.4

Usable entry point might be: https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1073776.1

By some keywords in metalink found PDF saying:

Downloading the Installer From Oracle E-Delivery
To download the installer from the Oracle E-Delivery Web site:
1. Enter the Oracle E-Delivery URL (http://edelivery.oracle.com/) in a Web
browser.
2. Choose your language and click Continue.
3. Complete the Export License Agreement as instructed on the site, and then click
Continue.
4. On the Media Pack Search page, select Oracle Fusion Middleware from the Select
a Product Pack drop-down list.
5. Select your platform from the Platform drop-down list and click Go. The Results
list shows all products that match your selections.
6. Click the Oracle Fusion Middleware 11g Media Pack link.
7. Click the Download link for the WebLogic Server installer you want to download.
8. Click Save.
9. Browse to the directory where you want to save the file. Click Save to start the file
download. A compressed ZIP file is downloaded.
10. Extract the ZIP file to a directory of your choice.

This can't be included in some note?

Btw note describing bugs fixed: Fixed Bugs List - Oracle WebLogic Server 10.3.4 [ID 1240413.1]

AIA and jDeveloper and Wizzard

While used 10g - a AIA artifact generator for ABCS's generation

When use 11g - a AIA Project Generator for ABCS's

How it works:
1. Create any input (file, DB adapter, WS);
2. Create a ESB (let's be modern - MEDIATOR);
3. Let's create mapping:
a) File -> New
b) "AIA Service Component Project"
c) Fill data asked;
d) Wait for great Result!

Some detail notes about naming:
CreateMyProcessReqABCSImpl consist of following input values:
1. Create comes from field "Service Operation";
2. MyProcess comes from "Application Short Name" + "Object Name"
3. Req comes from Request
4. Rest is extension

AIA 3.0 to 3.1

While great upgrade project run - Oracle release AIA 3.1

Perfect, instead of 11.1.1.2 I'll get 11.1.1.4

Overall release doc is annoying documents but nth really changed, certified on later version as mentioned earlier.