Disruptive technology = > Order of magnitude cheaper , order of magnitude lower quality, order of magnitude lower margin captured by the vendor
Saturday, June 29, 2013
Sunday, June 16, 2013
$ sqlplus sys as sysdba;
Enter the passed for sys when prompted.
If your application makes many connections and the number of processes allowed to be created by the oracle db is smaller than that, you will get the error
ORA-12519: TNS:no appropriate service handler found
To solve this issue, first view the number of processes allowed by oracle.
SQL> select * from v$resource_limit where resource_name = 'processes';
If you are using oracle express edition, this value would be 40.
Now increase number of allowed the processes
SQL>alter system set processes=300 scope=spfile;
Sunday, June 2, 2013
There are multiple ways to log information from a BPEL process to the server logfile.
One options is to write your own extension activity and use it to log information to the log where necessary. However, there is a simple and easy way to write logs without writing your own extension. That is to use the E4X extension activity.
In order to use E4X extension within your bpel process, follow the following steps.
1. Add xpath 2.0 namespaces to the process definition.
2. Define e4x as an extension.
<bpel:extension namespace="http://ode.apache.org/extensions/e4x" mustUnderstand="yes"/>
3. Include the e4x extension operation where you want to log information.
<bpel:assign validate="no" name="AssignE4X">
<![CDATA[ print(“My Log message from bpel process"); ]]>