in sql plus to avoid exponentialvalues like this as result: 6.0044E+11
run the command below  to avoid exponential values.

SQL>set numformat 99999999999999999999

Apache restart no sockets issue

# ./apachectl start
(98)Address already in use: make_sock: could not bind to address 0.0.0.0:80
no listening sockets available, shutting down
Unable to open logs
Run this command when the parent process is killed:
#killall -9 httpd

and then restart apache:
./apachectl start OR /etc/init.d/httpd2 restart