Useful commands to show RAID level of internal hard disks. On HP blade servers: /usr/sbin/hpacucli controller all show status /usr/sbin/hpacucli controller slot=0 logicaldrive all show On other servers: cat /proc/mdstat
Read More RAID internal hard disks linuxProblem: Client suffers intermittent ORA-12545 “Connect failed because target host or object does not exist” trying to connect to oracle RAC database. Solution: Edit server side (not client side) listener.ora and tnsnames.ora files to have fully qualified hostnames. Thanks to David Yahalom for flagging this – it doesn’t appear to be covered in metalink/my oracle […]
Read More Intermittent ORA-12545 with oracle RAC database(Update: Firewalls can prevent DRCP functioning correctly – details at end of this post) Database Resident Connection Pooling is new with 11g, and should be used for PHP applications. It will allow them to use the same type of connection pooling that java applications have had for a long time – largely equalising performance differences with […]
Read More Database Resident Connection PoolingFor older versions of unix/linux, crons running at 01.* (anything from 01:00 to 01:59) do not run during the Spring Sunday time change. Those sames crons will run twice during the Autumn time change. So it is important to not use 01.* times in your cron entries, for anything which runs on a Sunday. Newer […]
Read More Cron during British Summer Time / Daylight Saving TimeGo to your wordpress dashboard, click on ‘Appearance’ > ‘Editor’. This will open up a Stylesheet (style.css) editor. Here you can change the colours for ‘link’, ‘visited’, and ‘hover’, like this: a:link { color: #hexcodelinkcolor; } a:visited { color: #hexcodeyouwantvisitedlinktobe; } a:hover { color: #FF0000 } A lot of hex colour codes are listed at […]
Read More Change WordPress colours for link visited hoverHowto create a popup dialog box in Oracle Forms – called ‘alerts’ although can be used for all kinds of purposes, not just alerting. First create a new alert. Alerts are listed in the forms developer object navigator, immediately underneath Triggers. You can specify text and button names in the property palette of this new […]
Read More Oracle Forms popup dialog alert boxA strange one – but it is a documented feature in oracle. If you import specifying option ‘rows=n’, then statistics for all imported tables will be locked after the import operation is finished. That is only for import – an export with ‘rows=n’ is fine, doesn’t lock anything. That’s probably not what you want to […]
Read More ORA-38029 Object Statistics Are Locked – due to import with rows=nWindows Server 2008 and Windows 7 both hide printers that use the same port as another printer. But the printers aren’t really gone, they just take a little more effort to see – details at http://blogs.technet.com/b/askperf/archive/2010/03/02/windows-7-where-are-my-printers.aspx Your friends will be amazed.
Read More Windows 2008 Disappearing Printers Trickhttp://www.spotht.com/2010/11/check-if-you-work-on-virtualphysical.html
Read More Check if you work on a virtual/physical machine in LinuxFiles /etc/hosts.allow and /etc/hosts.deny control tcp wrapper permissions for incoming requests to linux servers. Ftp access is normally controlled by the ‘vsftpd’ line, e.g.: vsftpd: 138.134.116. 138.134.117. That would allow ftp connections from IP addresses like 138.134.116.x and 138.134.117.x. If your IP address is not in the allow list, ftp attempts will fail with an […]
Read More FTP 421 service not available tcp wrapper hosts.allow