Posts

Showing posts from October, 2014

Pool EDNLocalTxDataSource is Suspended, cannot allocate resources to applications..

Image
Connection test failed with the following exception: weblogic.common.resourcepool.ResourceDisabledException: Pool EDNLocalTxDataSource is Suspended, cannot allocate resources to applications..

This Error Appeared on Weblogic Depend on Managed Server, Tuning Connection Pool By Increasing Maximum Capacity parameter in Datasource.

My Case Datasource EDNLOCALTXDatasource as the above error.

Solution :-




Increase depend on your application.

Thank you  Osama Mustafa


Oracle SOA Tablespace Is full

When Creating Domain for Oracle SOA it's Mandatory to Run Oracle RCU before to create SOA Repository, This will create tables configuration and information about Oracle SOA.

But What happened the this tablespace was getting full, increase it 20GB is not enough which mean it's strange case and not acceptable.

after investigation Table Called "REFERENCE_INSTANCE" include information about Running Composite in SOA ans instances. the size for this table 18GB.

Select * from Reference_instance; 
Check the data in the above query, just in case you can use export data-bump utility for this table, however after this Truncate the table and from full tablespace toonly 2% usage.


Thank you
Osama Mustafa


NP_SOAINFRA.WL_LLR_ADMINSERVER Access Failed

java.sql.SQLException: JDBC LLR, table verify failed for table 'NP_SOAINFRA.WL_LLR_ADMINSERVER', row 'JDBC LLR Domain//Server' record had unexpected value
The above error appeared when trying to start Adminserver nothing changed on the Domain

Solution :-


Goto  domain location --> config folder. remove this line from the config.xml file, Take backup before you do this.


wlsbjmsrpDataSource
AdminServer,osb_server1
jdbc/wlsbjmsrpDataSource-jdbc.xml


Thank you
Osama Mustafa

Resource temporarily unavailable in tsStartJavaThread

Resource temporarily unavailable in tsStartJavaThread (lifecycle.c:1096).
Java heap 3G reserved, 3G committed
Paged memory=3145728/36425712K.
Your Java heap size might be set too high.
Try to reduce the Java heap size using -Xmx: (e.g. "-
java.lang.OutOfMemoryError: Resource temporarily unavailable in tsStartJavaThread (lifecycle.c:1096).
Java heap 6G reserved, 6G committed
Paged memory=3145728/36425712K.
Your Java heap size might be set too high.
Try to reduce the Java heap size using -Xmx:

The Above error appeared on OEDQ when trying to run the process this error related to Java Heap Size the OS control the Heap Size to solve this issue add the below parameters depend on your enviroment  :-


Add the following to /etc/sysctl.conf:
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 4194304
net.core.wmem_max = 4194304
fs.file-max = 134283264
fs.aio-max-nr = 1048576
vm.min_fr…

SF 34004 Serivce initialization failed error

Image
This error appeared on informtica when you are trying to create informtica services to solve this error all you have to do :-

Change the following Exclusive to Normal.



Thank you  Osama Mustafa

ORA-01465: Invalid Hex Number

Image
Solution :-
With your Query Use the below function :- RAWTOHEX( raw )
For More information how to use this function read here:-


Thank you  Osama Mustafa