Wednesday, February 26, 2014

soft limit maximum user processes/Oracle Linux



As Root User access to
[root@EM12C Packages]# vi /etc/security/limits.conf

Then add the below line or modify it :

oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  4096
oracle              hard    nofile  65536
oracle              soft    stack   10240


Thank you
Osama Mustafa 

Thursday, February 20, 2014

LAOUC Webinar

You Can Join me In LAOUC Webinar  5 March the Topic for the Webinar will be

Top 10 Database Threats 

You can Register Here

All Thanks Goes to Francisco Munoz Alvarez  For His Amazing Effort in Oracle Community.


Thank you
Osama Mustafa

Sunday, February 16, 2014

HTTP3094: 1 listen sockets could not be created / Oracle IPlant

When Trying to Startup iplant Instance the below error Appearing every-time :

TEST siebel: :/Siebel/iPlanet/webserver7/https-Osama_TST/bin\>./startserv
Oracle iPlanet Web Server 7.0.15 B04/19/2012 21:52
info: CORE5076: Using [Java HotSpot(TM) 64-Bit Server VM, Version 1.6.0_24] from [Sun Microsystems Inc.]
startup failure: could not bind to port 8080 (Address already in use)
failure: HTTP3127: http-listener-1: http://TEST:8080: Error creating socket (Address already in use)
failure: HTTP3094: 1 listen sockets could not be created
failure: server initialization failed


From the above error you notice that Port 8080 is already in use.

The Solution :

ps -ef |grep webservd

and Use Kill -9

Try Again Now

Thank you
Osama Mustafa

Sunday, February 9, 2014

ORA-12505 SCAN Listener And JDBC


The Above Error Appears when trying to connect RAC database Using SCAN Listener through JDBC, I checked everything and it was working without any problem, I could not find any reason why this issue happened, nothing in the Listener.log.

So I Used the below connection String instead of above one.

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SCAN-LISTENER-NAME)(PORT=1530))(CONNECT_DATA=(SERVICE_NAME=Service-name)))

Thank you
Osama Mustafa