Tuesday, December 20, 2016

ORA-12801: error signaled in parallel query server , ORA-27090: Unable to reserve kernel resources

ORA-12801: error signaled in parallel query server , ORA-27090: Unable to reserve kernel resources


ORA-12801: error signaled in parallel query server , ORA-27090: Unable to reserve kernel resources

Problem:
-------------------
 
ORA-12801: error signaled in parallel query server P006, instance
mdvreddy.markmotels.com:mdvreddy (1)
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O and hence change

Solution:
------------------

Run as root:

modify  fs.aio-max-nr value to  3145728 in /etc/sysctl.conf


 

###fs.aio-max-nr = 1048576
fs.aio-max-nr= 3145728

Save the file and Run to make the changes permanent

 sysctl -p



Read the actual parameters with sysctl.

 
sysctl -a

Sunday, December 18, 2016

OHS not starting after giving opmnctl startall with error make_sock: could not bind to address xx.x.x:80

OHS not starting after giving opmnctl startall  with error make_sock: could not bind to address xx.x.x:80


[2016-12-19T05:51:07.1888+00:00] [OHS] [INCIDENT_ERROR:32] [OHS-9999] [core.c] [host_id: mdvreddy.markmotels.com] [host_addr: xx.100.100.100] [pid: 8256] [tid: 140065001035584] [user: mdvreddy] [VirtualHost: main] (13)Permission denied:  make_sock: could not bind to address xx.100.100.100:80

[2016-12-19T05:51:07.1888+00:00] [OHS] [INCIDENT_ERROR:20] [OHS-9999] [core.c] [host_id: mdvreddy.markmotels.com] [host_addr: xx.100.100.100] [pid: 8256] [tid: 140065001035584] [user: mdvreddy] [VirtualHost: main]  no listening sockets available, shutting down

[2016-12-19T05:51:07.1888+00:00] [OHS] [ERROR:32] [OHS-9999] [core.c] [host_id: mdvreddy.markmotels.com] [host_addr: xx.100.100.100] [pid: 8256] [tid: 140065001035584] [user: mdvreddy] [VirtualHost: main]  Unable to open logs

[2016-12-19T05:51:09.0676+00:00] [OHS] [INCIDENT_ERROR:32] [OHS-9999] [core.c] [host_id: mdvreddy.markmotels.com] [host_addr: xx.100.100.100] [pid: 8263] [tid: 140187892651840] [user: mdvreddy] [VirtualHost: main] (13)Permission denied:  make_sock: could not bind to address xx.100.100.100:80

[2016-12-19T05:51:09.0676+00:00] [OHS] [INCIDENT_ERROR:20] [OHS-9999] [core.c] [host_id: mdvreddy.markmotels.com] [host_addr: xx.100.100.100] [pid: 8263] [tid: 140187892651840] [user: mdvreddy] [VirtualHost: main]  no listening sockets available, shutting down

[2016-12-19T05:51:09.0676+00:00] [OHS] [ERROR:32] [OHS-9999] [core.c] [host_id: mdvreddy.markmotels.com] [host_addr: xx.100.100.100] [pid: 8263] [tid: 140187892651840] [user: mdvreddy] [VirtualHost: main]  Unable to open logs


cd  /u01//Oracle_WT1/ohs/bin 

Change permissions of .apachectl from


-rwxr-x---. 1 mdvrd mdvrd  12315 Feb  8  2013 .apachectl
[mdvrd@mdvreddy.markmotels.com bin]$

execute the following command to the required changes

su root 
chown root .apachectl
chmod 6750 .apachectl
su mdvreddy
to

-rwsr-s---.  1 root      mdvreddy  13278 Feb  8  2013 .apachectl

cd /u01//Oracle_WT1/instance/instance1/bin  ./opmnctl stopall
 ./opmnctl startall
 ./opmnctl status

 I see it is working..


 for other problems, there is a very good blog on similar issues
 https://sreejithsna.wordpress.com/2015/09/04/ohs-not-starting-after-giving-opmnctl-startall/