Windows

Window Maintenance Tips

Regular maintenance is important for your home’s windows. It can help them last longer, perform better and look great. Well-maintained windows will also serve to enhance the security and appearance of your home, guarding against the effects of temperature fluctuations, weather and debris. Follow these maintenance tips from Rescom’s expert window technicians to help keep your windows in shape. Visit reliablewindowandsiding.net for more information about professional maintenance.

Cleaning

Wipe down windows regularly with a damp cloth to remove dust and dirt. Don’t use too much water, especially on wood frame windows, as moisture can lead to rot. For vinyl windows, used a combination of warm water, a mild detergent and a soft scrubbing brush.

Use a glass cleaner in between deep cleans to keep the windows sparkling. Don’t neglect the window casing and adjacent wall area, in an effort to remove that build-up of dirt and debris in hard-to-reach components. Window jams can occur when dirt is allowed to accumulate in those areas.

Regular Inspections

In spring and fall, perform a thorough inspection of your windows, being sure to check the condition of the window frame and sash. Keep an eye out for signs of rot, especially on wood frames, that can indicate moisture infiltration.

Be on the lookout for moisture in double- or triple-paned windows, which could mean the seal has failed and must be replaced. Allowing a failed seal to remain will reduce the insulation capacity of your windows.

Have the sun’s harsh UV rays caused areas of the frame to become brittle and warp? Is paint peeling in certain areas? Is the weather stripping still intact? Replace, repair and repaint as needed. Caulk any gaps between the wall and window casing.

Sealing

Gaps around your window allow for energy leakage, increasing your bills and reducing the efficiency of your home. For optimal sealing, replace all worn rubber seals to keep air and water leaks at bay and further secure the window in place. You can also use spray insulation or caulking to do the job.

Damaged Parts

Repair any cracks, holes, and splinters in the window to avoid further deterioration. If you notice cracked or broken glass, get it repaired or replaced immediately to prevent energy leakage and accidental cuts. This task is best left up to professionals.

Check the Fit

Frames and sashes can change subtly in size over time, thanks to usage and exposure to temperature cycles. As a result, gaps can form between window components, allowing air and water infiltration. Carefully check the fit of all window components. Make sure they can open all the way and that they close and lock completely. Swelling or warping of the window frame or sash means moisture is present.

Which Extra Cost Oracle Options is my Windows Server Running?

It’s always nice to know which extra cost Oracle options are enabled, whether deliberately or silently as the result of some patching that has taken place.
Keep yourself and your server room cool with blaux wearable ac.

Continue reading Which Extra Cost Oracle Options is my Windows Server Running?

Dropping Temporary Tables (With Bonus, Broken Check Constraints!)

I found a broken check constraint, one that simply wouldn’t work, on a database. It was created as:

... CHECK(COLUMN_NAME IN ('Y','N',NULL)) ;

Try it yourself, it doesn’t work! Anyway, I needed to find if there were any other check constraints broken in this manner, so I did the following:

Continue reading Dropping Temporary Tables (With Bonus, Broken Check Constraints!)

How to Start an Oracle Database When You Are Not in the DBA Group

This applies to Linux, Unix as well as Windows, but affected me on a Windows 2012 Server running Oracle 11.2.0.4 Enterprise Edition.

My user on the server was an administration user, but not in the ora_dba group. This is required to connect / as sysdba within SQL*Plus. The SYS password had been changed recently but whoever did it, did not update the password vault. The users were urgently requiring their database be started, I was the only DBA in the office, the SYS password was unknown, and my user didn’t belong directly to the ora_dba group. What to do? Continue reading How to Start an Oracle Database When You Are Not in the DBA Group

RMAN Connection Troubles, RMAN-03010 & RMAN-10038

For no reason, after many weeks of use, RMAN suddenly cannot connect:

rman target sys/******@dbadb01 catalog ...

...
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03010: fatal error during library cache pre-loading
RMAN-10038: database session for channel default terminated unexpectedly

Continue reading RMAN Connection Troubles, RMAN-03010 & RMAN-10038

Tnsnames.ora, IFILE and Network Drives on Windows

I’ve recently begun a new contract migrating a Solaris 9i database to Oracle 11gR2 on Windows, in the Azure cloud. I hate windows with a vengeance and this hasn’t made me change my opinion!

One of the planned improvements is to have everyone using a standard, central tnsnames.ora file for alias resolution. A good plan, and the company has incorporated my own tnsnames checker utility to ensure that any edits are valid and don’t break anything.

I found that the tnsnames.ora in my local Oracle Client install, was not working. Here’s what I had to do to fix it. Continue reading Tnsnames.ora, IFILE and Network Drives on Windows

Printing, Completing & Scanning PDF Documents

As a contractor I often have to fill in and sign various contract agreements. These are usually tens of pages in length, and while I only have to sign one page, I still must scan in and send back each and every page, even the untouched ones. It would help if a PDF with form filling abilities was supplied, but hey, that’s only rarely the case. This is how I do it. (On Linux – Windows users mileage may vary!) Continue reading Printing, Completing & Scanning PDF Documents

Does Your Raspberry Pi 3 Lose WiFi Connections After a While?

If you find that your Raspberry Pi 3 (or any above), those with built in WiFi and Bluetooth, loses the WiFi connection after a period of inactivity, then this thread on the Raspberry Pi Forums, which will open in a new tab, might be of interest. Have a read. If you want to miss out on the preliminaries of the thread, start reading here instead.

The problem is likely to be the power saving mode of the Wifi. To check the current setting:

sudo iw dev wlan0 get power_save

If you are/will be affected, it will reply with:

power_save: on

If so, all you need to do is:

sudo iw dev wlan0 set power_save off

I’m not affected yet, but I’m making a note here, just in case!

Trace Collier – An Oracle Utility to Mine 10046 Trace Files

Have you ever needed to trawl through an Oracle Trace file to extract the SQL statements executed and found a whole load of bind variables have been used, so you need to find the BINDS section, extract the values, and virtually paste them into the parsed SQL statement?

No? This utility isn’t for you then. Continue reading Trace Collier – An Oracle Utility to Mine 10046 Trace Files

Turn Off Task Bar Thumbnail Previews on Linux Mint Cinnamon 17.3

I hate it when I click on a task bar icon to open up a snoozing application, and a couple of seconds later, there’s a preview of the application showing at the bottom of the screen. I don’t need it as the icon tells me what it is, thanks! Getting rid is easy: Continue reading Turn Off Task Bar Thumbnail Previews on Linux Mint Cinnamon 17.3