dbafusion

1) Edit /etc/hosts file and map --LBR Hostname-- to --LBR IP-- on each node 2) Set enableCluster to true and assign a name to the clusterName property in ORACLE_HOME/bpel/system/config/collaxa-config.xml on each node 3) Set mcast-addr and mcast-port in ORACLE_HOME/bpel/system/config/jgroups-protocol.xml on each node 4) Set the soapServerURL to the same value as the load balancer internal URL and the soapCallbackUrl to the same value of the load balancer external URL, using the BPELADMIN console on each node 5) Configure these properties on all the nodes in the cluster: 6) In the ORACLE_HOME/bpel/utilities/ant-orabpel.properties file, set cluster to true. 7) Set oc4jinstancename to SOA_GROUP (the name of the OC4J group that has the Oracle BPEL Process Manager deployed to it). 8) Restart the OC4J_SOA instances on all nodes.

a) Use Discovery Server method for OPMN Cluster b) Designate --node1-- as the discovery server and apply the below configuration c) Edit opmn.xml file and the below config --notification-server-- --topology-- --discover list="--node1:--ONS_Port--"/-- --/topology-- ... --/notification-server-- d) Run the command ./opmnctl reload Apply the step a to d on all the nodes. e) After doing on all nodes , execute :- ./opmnctl startall and thus opmn gets clustered

Suddenly a requirement came to me that whether the IP address is published over the net or outside network or not. Then for a quick solution , instead of going into the server apache configuration files , i found that there are many sites available over the internet which can provide IP to HOST or HOST to IP resolution so if it will resolve to my IP then it is published over the net.So this cheeky solution worked.

1) Installing OHS on Red Hat Linux 4.0 on virtual VMWare , faced a problem that http server not gettng started and threw below error. 10/01/28 11:15:14 Start process -------- /data1/oracle/app10gR3/ohs/ohs/bin/apachectl startssl: execing httpd /data1/oracle/app10gR3/ohs/ohs/bin/httpd: error while loading shared libraries: libdb-3.3.so: cannot open shared object file: No such file or directory. 2) Found that on blogs that libdb-3.3.so is an OS (RED HAT) library file which is missing. 3) Found on the google the link . i.e. ftp://mahe.inrialpes.fr/linux/freshrpms/redhat/7.0/updates/i386/db3-3.3.11-6.i386.rpm Now the link will not work so replace ftp with http , and download it. 4) Executed RPM 5) Retry the installation & http server will start successfully

Some Important Java Terms you can come across while working & monitoring SOA Suite :- BPEL Versioning :- Oracle BPEL Control is also useful for deciding when a process is ready for production mode. For example, assume that you compiled and deployed version 1.0 of your BPEL process and subsequently a newer version, version 2.0. After testing and verification of your BPEL process, you can use Oracle BPEL Control to mark one of the versions as the default. Then new instances are started using this definition. The Java Database Connectivity (JDBC) :- The Java Database Connectivity (JDBC) API is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases – SQL databases and other tabular data sources, such as spreadsheets or flat files. The JDBC API provides a call-level API for SQL-based database access. JDBC technology allows you to use the Java programming language to exploit "Write Once, Run Anywhe

Usually platform id is picked up from the file : $ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml To override the value :- Set :- OPATCH_PLATFORM_ID export OPATCH_PLATFORM_ID=0 set OPATCH_PLATFORM_ID=0

This problem comes when we try to access any OC4J instances other than HOME, the Application Server will deny the access and gives following error on the screen: Unable to make a connection to OC4J instance instance_name on Application Server application_server_name. A common cause for this failure is an authentication error. The administrator password for each OC4J instance in the Cluster must be the same as the administrator password for the OC4J instance on which Application Server Control is running. This means that all the OC4J instances in the application server should have same oc4jadmin password. Perform below steps to debug the above error :- Before changing the oc4jadmin password for HOME instance, change the oc4jadmin password for all other instances using the following steps: 1. Click on OC4J instance 2. Click on Administration tab 3. Edit sub-task Security Providers under Security task 4. Edit any application name under Application Level Security 5.

Overview of applying Oracle Application Server 10g R3 patchset 4 (10.1.3.4) on existing 10g R3 (10.1.3) Key Points for 10.1.3.4 Upgrade 1. Patch Number for OAS 10g R3 patchset 4 (10.1.3.4) is 7272722 2. 10g R3 patchset 4 (10.1.3.4.0 - 7272722) is cumulative and includes all fixes from 10.1.3.0, 10.1.3.1, 10.1.3.2 and 10.1.3.3 3. 10g R3 patchset 4 (10.1.3.4.0) is NOT complete software, you need to install in on top of one of existing software i.e. 10.1.3.n (10.1.3.0, 10.1.3.1, 10.1.3.2 or 10.1.3.3) 4)10g Rel 3 patchset 1 (10.1.3.1.0) is starting point for Oracle SOA Suite (BPEL, ESB…) and 10g Rel 3 patchset 2 (10.1.3.2.0) is starting point for WebCenter Suite (ContentDB, WebCenter Services). If you are using Oracle SOA Suite or Oracle Web Center then you need to do additonal steps before upgrade like – upgrade_10131_10134_oracle.sql (10.1.3.1) or – upgrade_10133_10134_oracle.sql (10.1.3.3) (For BPEL from ORABPEL schema) – upgrade_10133_10134_oracle.sql (For ESB from O

1) Set ORACLE_HOME,OPATCH/bin under PATH. 2) Shut down the application server by $opmnctl shutdown command 3) Extract the MLR6 on the server & move inside the directory. 4) Execute below command :- bash-3.2$ ./opatch apply /u01/data/8279781/ Oracle Interim Patch Installer version 1.0.0.0.58 Copyright (c) 2007 Oracle Corporation. All Rights Reserved.. We recommend you refer to the OPatch documentation under OPatch/docs for usage reference. We also recommend using the latest OPatch version. For the latest OPatch version and other support related issues, please refer to document 293369.1 which is viewable from metalink.oracle.com Oracle Home : /u01/app/OAS/10.1.3.1/OH Oracle Home Inventory : /u01/app/OAS/10.1.3.1/OH/inventory Central Inventory : /home/appsoad/oraInventory from : /var/opt/oracle/oraInst.loc OUI location : /u01/app/OAS/10.1.3.1/OH/oui OUI shared library : /u01/app/OAS/10.1.3.1/OH/oui/lib/hpunix/liboraInstaller.so Java locatio

I have collected below brief information about some of the performance metrices used in OC4J monitoring in SOA Suite . This is a brief idea. Have a look :- CPU (%) Description: The percentage of the CPU currently being used by the OC4J instance, or--on the JVM Metrics page--the selected Java Virtual Machine (JVM). User Action: Use this metric to determine how much of the CPU is in use by the OC4J instance or JVM. If you encounter consistent high readings for this metric, try to isolate the problem by monitoring individual applications and services that are running on the OC4J instance. If no problems are found, consider obtaining additional hardware resources or load balancing solutions. Memory (MB) Description: Indicates how much of your total physical memory is in use by the current OC4J instance, or--on the JVM Metrics page--by the selected Java Virtual Machine (JVM). User Action: Use this metric to monitor memory use by the OC4J instance or JVM. Compare this with h

You may get an out of memory exception if the Oracle WSM is configured so that its runtime memory requirements exceed the JVM default configuration. One known situation where this can occur is if you patch Oracle WSM 10.1.3 to 10.1.3.1. To avoid this error, you need to increase the size of the Java heap. To change the values of the Java heap 1. Log in to Oracle Enterprise Manager 10g Application Server Control. 2. In the Cluster Topology page, locate the Members section, and click home. 3. Click Administration. 4. Find Server Properties in the Task Name list, and click the Go to Task icon. 5. Edit the values for Maximum heap size (1024 Mb) and Initial heap size (512 Mb). 6. Add a row for the -XX:MaxPermSize (256 Mb) and -XX:PermSize (128 Mb) parameters and provide a value. 7. Click Apply. 8. Restart the server. Note: The values in parentheses are provided as an example only. These values were derived assuming that all components in the Oracle Application Server

It is important to ensure that only authorized consumers can call the web services that are exposed. The below solution applies only to security internal web services. All the internal web services will be secured using OWSM Server Agents. This document consists of steps to be taken on order to deploy server agents. To configure a server agent component in Oracle Web Services Manager Point your browser to the Web Services Manager Control Console and log in using your user name and password. The Web Services Manager Control Console is accessed with a URL of the form: http:// :port_number/ccore For example: httphttp://dceapocxxxx:8888/ccore/index.jsp 2. Click Add New Component. 3. On the Add New Component page, define: ■Component name ■Component type ■Container type Click Register. Define Policy Set for Server Agent To define the policy set for the server agent: 1. At the Web Services Manager Control Console, click Policy Management, then click Mana

1)Log in to Web Services Manager Control. 2) In the navigation pane, select Policy Management. 3) Click Edit for each Oracle WSM Agent and Gateway in your instance. 4) Edit the the cfluent.messagelog.db.password, replacing the value that is there presently with the ORAWSM schema password. Save these change susing the Save button, then press the Ok button on the page that appears. 5) Press the Policies link beside the component altered, then click the Commit link to completely accept the changes. Note that steps 4 and 5 have to be completed for each gateway and agent in your system. Once this process has been completed, try testing your system again to see if you can see the Message Logs page

Steps to be performed:- 1) Copy “TestBPEL” build folder in the server. 2) Go to $BPEL_HOME/utilities/ant-orabpel.properties • Change revision as :- rev=1.0.1 3) Go to the BPEL/Deployments where the build.xml is present Execute exact below command:- ant TestBPELP

Below error :- INFO: Unable to determine operation id from SOAP Message. INFO: Unable to determine operation id from SOAP Message. WARNING: Unable to connect to URL: http://xyz.test.com:80/testapp/testappSoapHttpPort due to java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Bad response: 404 Not Found WARNING: Unable to connect to URL: http://xyz.test.com:80/testapp/testappSoapHttpPort due to java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Bad response: 404 Not Found 1) Check OC4J on which the "testapp" deployed is up and running or not. 2) Check the "testapp" is up and running or not. 3) Check whether testapp is deployed or not 4) Check the wsdl if it is going to correct URL and port or not. 5) Check whether the proxy in the browser is correct or not needed. 6) Check whether the opmn.xml has the entry of OC4J is disabled or enabled.

Problem: “No domains accessible to the users” message is displayed while logging to the bpel console. We tried to create the domains using create domain link, we found from the error Messages that it is using a different port. And also the bpel user account is getting locked. Cause: The console is not able to find the default domains in the database Solution: 1) Check the database is up and running or not. if not, make it up otherwise check the error and follow point 2 2) We changed the URL which it is trying to connect while creating a new domain In the following path: EM console  OC4J Home  Click Administration tab  In Services Go To JDBC Resources  in Connection Pools Click BPELPM_CONNECTION_POOL  In the URL box edit the URL and revert the change. We edited the port and remaining is to resolve bpeluser account locking. We proceeded with the following (Source Google) Recently we’ve had quite a few migrations to 10g Release 2 and several times been h

Check the status of "ascontrol" application: /export/home/oracle/zainsoa/opmn/bin/opmnctl status -app If it is not "started", start it: /export/home/oracle/zainsoa /opmn/bin/opmnctl startproc application=ascontrol

How to register SSO in OID (Oracle Application Server) Ø Run Below in the OID Home OID Home = abc.test.com SSO URL = http://xyz.tes1.com:7783 $ORACLE_HOME/sso/bin/ssoreg.sh -site_name abc.test.com -mod_osso_url http://xyz.tes1.com:7783 -config_mod_osso TRUE -oracle_home_path $ORACLE_HOME -remote_midtier -config_file $ORACLE_HOME/Apache/Apache/conf/osso/osso_abc.conf Copy the osso_abc.conf to SOA Home in below direcoty. $ORACLE_HOME= Home of SSO URL Appliction Server Ø $ORACLE_HOME/Apache/Apache/conf/osso and rename to osso.conf. Ø Login to middle tier server as owner and backup $ORACLE_HOME/Apache/Apache/conf/httpd.conf file before making changes. Open httpd.conf file and uncomment the following line include "<$ORACLE_HOME>/Apache/Apache/conf/mod_osso.conf" Ø Backup $ORACLE_HOME/Apache/Apache/conf/mod_osso.conf file before making changes. Open mod_osso.conf file and add the following line right after OssoConfigFile <$ORACLE_HOME>/Apache/Apache/conf/osso/osso.con

Unix Commands to create group,user,directory as a prerequisite of installation of any oracle product. groupadd oinstall groupadd dba useradd -m -g oinstall -G dba oracle id oracle passwd oracle mkdir -p /u01/app/oracle chown -R oracle:oinstall /u01/app/oracle chmod -R 775 /u01/app/oracle

OWSM Gateway 1. Make sure that OracleAS / OC4J hosting OWSM is running. 2. Open $OC4J_HOME/owsm/config/gateway/logging.xml and replace all “INFO” with “FINEST”. 3. Go to $OC4J_HOME/owsm/bin directory, and run the following command wsmadmin deploy gateway 4. The changed log level for the gateway application is in effect now. Look for the detailed logs in $OC4J_HOME/j2ee/OC4J_Instance/log/gateway.log OWSM Control 1. Make sure that OracleAS / OC4J hosting OWSM is running. 2. Open $OC4J_HOME/owsm/config/ccore/logging.xml and replace all “INFO” with “FINEST”. 3. Go to $OC4J_HOME/owsm/bin directory, and run the following command wsmadmin deploy control 4. The changed log level for the OWSM Control application is in effect now. Look for the detailed logs in $OC4J_HOME/j2ee/OC4J_Instance/log/ccore.log OWSM Policy Manager 1. Make sure that OracleAS / OC4J hosting OWSM is running. 2. Open $OC4J_HOME/owsm/config/policymanager/logging.xml and replace all “INFO” with “FINEST”. 3. Go to $OC4J_HOME

Create a read only user to OWSM Console. 1) Go to the below path $OH/owsm/bin 2) Open manageUserGroups.properties file and given parameters :- user_id=vinay_r user_name=vinay singla user_password=welcome123 user_email=vinayncce1@gmail.com bash-3.2$ vi manageUserGroups.properties "manageUserGroups.properties" [Incomplete last line] 46 lines, 1089 characters ^M #============== User Parameters^M # Sample User Values^M #user_id=ctang^M #user_name=Administrator^M #user_password=mypasswrod^M #user_email=admin@admin.com^M ^M user_id=vinay_r user_name=vinay singla user_password=welcome123 user_email=vinayncce1@gmail.com ^M ^M "manageUserGroups.properties" 46 lines, 1134 characters You have mail in /var/mail/appsid 3) Save the file and in the same directory execute below command . it will successfully create a user for OWSM Console:- bash-3.2$ sh wsmadmin.sh manageUserGroups addUser Buildfile: /u01/app/OAS/10.1.3.1/SID1/owsm/bin/../scrip

How to change connection pool from unix console Steps :- 1) Go to the $OH/j2ee/oc4j_soa/config path 2) take backup of data-sources.xml like below :- bash-3.2$ cp data-sources.xml data-sources.xml_bkp200110 3) Then open the same file as bash-3.2$ vi data-sources.xml 4) just execute the global replacement command like 1,$s/xyz/abc/g 5) save the file 6) Restart the container to effect the change opmnctl restartproc

OutOfMemoryError: unable to create new native thread 10/01/14 11:06:10 java.lang.OutOfMemoryError: unable to create new native thread 10/01/14 11:06:10 at java.lang.Thread.start0(Native Method) 10/01/14 11:06:10 at java.lang.Thread.start(Thread.java:574) 10/01/14 11:06:10 at com.evermind.util.ReleasableResourcePooledExecutor.addThread(ReleasableResourcePooledExecutor.java:236) 10/01/14 11:06:10 at EDU.oswego.cs.dl.util.concurrent.PooledExecutor.execute(PooledExecutor.java:997) 10/01/14 11:06:10 at com.evermind.util.ThreadPool.launch(ThreadPool.java:283) 10/01/14 11:06:10 at com.evermind.server.rmi.RMIServerConnection.startConnection(RMIServerConnection.java:141) 10/01/14 11:06:10 at com.evermind.server.rmi.RMIServer.createRMIServerConnection(RMIServer.java:812) 10/01/14 11:06:10 at com.evermind.server.rmi.RMIServer.connect(RMIServer.java:805) 10/01/14 11:06:10 at com.evermind.server.rmi.RMIServer$Listener.acceptNewConnection(RMIServ

BPEL Crash with ping attempt timeout error 09/12/30 23:02:42 [ons-connect] Passive connection 100.00.00.000,6024 missing connect 10/01/14 11:01:48 [libopmnoc4j] OC4J ping attempt timed out 10/01/14 11:01:48 [libopmnoc4j] Process Ping Failed: BPEL~oc4j_soa~default_group~1 (345181855:4176) 10/01/14 11:02:38 [libopmnoc4j] OC4J ping attempt timed out 10/01/14 11:02:38 [libopmnoc4j] Process Ping Failed: BPEL~oc4j_soa~default_group~1 (345181855:4176) 10/01/14 11:03:28 [libopmnoc4j] OC4J ping attempt timed out 10/01/14 11:03:28 [libopmnoc4j] Process Ping Failed: BPEL~oc4j_soa~default_group~1 (345181855:4176) 10/01/14 11:04:18 [libopmnoc4j] OC4J ping attempt timed out 10/01/14 11:04:18 [libopmnoc4j] Process Ping Failed: BPEL~oc4j_soa~default_group~1 (345181855:4176) 10/01/14 11:05:08 [libopmnoc4j] OC4J ping attempt timed out 10/01/14 11:05:08 [libopmnoc4j] Process Ping Failed: BPEL~oc4j_soa~default_group~1 (345181855:4176) 10/01/14 11:05:58 [libopmnoc4j] OC4J ping attempt timed out 10/01/14 11

Identity Service Authentication failure --2010-01-14 10:34:33,032-- --ERROR-- --oracle.bpel.services.workflow-- --::-- Identity Service Authentication failure. Identity Service Authentication failure. Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable. ORABPEL-10528 Identity Service Authentication failure. Identity Service Authentication failure. Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable. at oracle.tip.pc.services.identity.jazn.xml.XMLAuthenticationService.authenticateUser(XMLAuthenticationService.java:150) at oracle.tip.pc.services.identity.jazn.xml.XMLIdentityService.authenticateUser(XMLIdentityService.java:426) at oracle.bpel.services.workflow.verification.impl.VerificationService.authenticateUser(VerificationService.java:341) 1) Check username/password used in worklist is correct or not. 2) Add correct password in the descriptor of BPEL Process throwi

How to disable a container not to ping and display in em or at server . 1) stop the application server by using opmnctl @cluster stopproc 2) go to $OH/opmn/conf file 3) open opmn.xml file and find below :- --/process-set-- --/process-type-- --/ias-component-- --ias-component id="group_xyz" status="enabled"-- --process-type id="xyz" module-id="OC4J" status="enabled"-- --module-data-- --category id="start-parameters"-- --data id="java-options" value="-server -Dcom.sun.management.jmxremote -mx1792M -ms1792M -XX:MaxPermSize=300M -XX:AppendRatio=3 -Djava.security.policy=$ORACLE_HOME/j2ee/xyz/c onfig/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false -Xbootclasspath^/p $OH/j2ee/xyz/applib/jtds-1.2.2.jar -XX:PermSize=300m -Duser.tim ezone=GMT+4 -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -XX:+UseParallelGC -XX:ParallelGCThreads=4 -XX:SurvivorRatio=32"/-- --/category-- --category id="stop-paramete

This is a stale connection issue :- : The Adapter Framework was unable to establish an outbound JCA connection due to the following issue: ORABPEL-11929 SQL error while creating managed (database) connection. SQL error while creating managed (database) connection: Unable to get a physical connection from the database...there are no connections available. Please examine the log file to determine the problem. [Caused by: Unable to get a physical connection from the database...there are no connections available.] 1) Check database for the stale connections. 2) Oracle Suggests MLR9 patch to remove this issue. 3) Configure Connection pools analyzing current transactions 4) For immediate solution , restart the container and thus connections will get released.

OC4J denotes the anonymous user as the OC4J user when an application is initiated that does not have an authenticated user. The anonymous user may also be used during EJB RMI access Below error will come :- This load was initiated at hw_services.root:0.0.0 using the Class.forName() method. The missing class is available from the following locations: 1. Code-Source: $OH/bpel/system/services/lib/bpm-services.jar (from in $OH/SOA/j2ee/oc4j_soa/config/server.xml) This code-source is available in loader oracle.bpel.common:10.1.3. This shared-library can be imported by the "hw_services" application. 1) Check hw_services sub-application up and running in orabpel appliation in em console 2) check anonymous user exist in jazn of BPEL container 3) if not, create with any password. 4) start the container

Clicking to the chart display incur performance issues , which can be disables through below process. Take a backup and Edit the following jsp file; $OH/j2ee/oc4j_soa/applications/customworklist/customworklist/TaskList.jsp 2. Go to the below section in the jsp; String chartButtonDisplay = " "; …………. Modify the above section as folows;String chartButtonDisplay = " "; Save and Exit

1) Set ANT_HOME, BPEL_HOME,ORACLE_HOME 2) Copy BPEL Artifacts to the location of app server 3) Edit ant-orabpel.properties in ($BPEL_HOME/utilities) and provide the domainname under which deployment has to be made and the revision no. (BPEL control revision no.) Change domain = domainname rev =0.12.6.0 Note : Make sure that there is no space after domainname and rev(revision no.) 4) Go to Copied BPEL Folder and to the sub-directory where the “build.xml” is present. 5) Execute ant $ant deployProcess: [echo] [echo] -------------------------------------------------------------- [echo] Deploying bpel process Xyz on hostname, port 7777 [echo] -------------------------------------------------------------- [echo] [deployProcess] Deploying process /u03/app/BPEL/Xyz/output/bpel_Xyz_0.12.6.0.jar [deployProcess] Successfully deployed the process "Xyz" on server "hostname" and port "7777" deployTaskForm: [echo] [echo] ----------------

1) Create a folder logs in following location :- /opt/hpws/apache/htdocs drwxrwxrwx 7 root sys 8192 Jun 1 2009 logs bash-3.2$ pwd /opt/hpws/apache/htdocs 2) Create folders in logs :- apachelogs opmnlogs bash-3.2$ ls -ltr total 32 drwxrwxrwx 2 root sys 96 Feb 12 2009 opmnlogs drwxrwxrwx 2 root sys 96 Feb 12 2009 apachelogs Note :- a) Replace “/u03/app/home” with ORACLE HOME PATH b) Use this command to make a soft link :- ln –s logs /u03/app/home/opmn/logs 3) Go to opmnlogs :- Create a folder logs and create a soft link like below:- bash-3.2$ ls -ltr total 0 lrwx------ 1 root sys 26 Feb 12 2009 logs -> /u03/app/home/opmn/logs 4) Go to apachelogs :- Create a folder logs and create a soft link like below:- bash-3.2$ cd apachelogs/ bash-3.2$ ls -ltr total 0 lrwx------ 1 root sys 35 Feb 12 2009 logs -> /u03/app/home/Apache/Apache/logs bash-3.2$ 5) Restart apache server ./apachectl stop ./apachectl start