Thursday, October 23, 2014

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 

Wednesday, October 22, 2014

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_free_kbytes = 512000 
  • Add the following to /etc/security/limits.conf:

oracle soft nproc 16384
oracle hard nproc 63536
oracle soft nofile 16384
oracle hard nofile 63536

  •  Add the following to /etc/pam.d/login:
session required /lib/security/pam_limits.so


Thank you
Osama Mustafa

Monday, October 13, 2014

SF 34004 Serivce initialization failed error

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

Sunday, October 12, 2014

ORA-01465: Invalid Hex Number



Solution :-

With your Query Use the below function :- RAWTOHEX( raw )

For More information how to use this function read here:-



Thank you 
Osama Mustafa

Saturday, September 27, 2014

Dublin TECH SIG Day Impression

Third time in Dublin, and i still love this country i arrived to Dublin on 23-Sept to present about Oracle Security Features and how to protect Oracle Database it was exciting trip regarding to my reservation i supposed to be in Dublin at 2:00 PM But What i didn't notice that my flight delayed Therefore i missed my flight and arrived to Dublin at 8:00 PM.

However TECH SIG was really amazing day meeting the people chatting with them, and presenting about Oracle Security with Full Room of people.


After the event me and Pete start chatting about Oracle Security and Talking about other stuff, my next Stop to SF Oracle Open World 2014.

Looking forward to meet everyone there.

Good time with Good People.

Thank you
Osama Mustafa

Monday, September 22, 2014

the version of the data that you are trying to import is not compatible with current dac version

This Error Appear On DAC Server when trying to Import Data  from the following :

Tools --> DAC Repository Management --> import

This error appears :-

the version of the data that you are trying to import is not compatible with current dac version

After trying to many Solution with no luck , i discover new Solution for this error and it's simple :-

export from tools ( Empty files ) will generate 3 folder in DAC Folder Leave this folder without any copy or replace.



Now in my case i installed BIAPPS Copy the folder without Replace the old one.



after start copying the windows will ask dont replace these three folders DON'T REPLACE IT.


Start Import successfully.





Now The Import is done,


Thank you 
Osama Mustafa


Monday, September 8, 2014

My Presentation in OOW14



If you are joining oracle open world 2014 this year , Join me at EOUC short talk and let's chat :)

Session Number :- 
12 Looks at Oracle Database 12c: EOUC Short Talks [UGF8949]

Welcome anytime


More Information Press Here

Thank you for Debra, Jonthan and Kashif for this opportunity

Thank you
Osama Mustafa