Posts

Car Paint Maintenance - Water Spot Removal, old Wax removal

Following are cheap products that available in household to keep the car paint protected. To remove water stain, uses acidic liquid Citrix acid Vinegar To removes oil, grease, or old wax, uses ammonia base liquid Windex - any glass or window cleaner To removes oil or wax, uses alcohol base liquid: rubbing alcohol - 85% or higher This helps to prepare the car paint, or car rims/wheels before apply another layer of wax or ceramic coating.

WiFi Data Capturing on 2 Channels - Beginner Guide

Product: Linux Commands: airodump-ng, iw Overview I do not like to use the airmon-ng command to change the WiFi device name to follow its original device name, which it is hard for me to remember, e.g. device name wlp0s12u1. So in this post, I will use "iw" utility (previously called iwlist, iwconfig) that bundled with Fedora 41, or RedHat RHEL 9, to configure the WiFi adapter in monitor mode with my preferred device name.  The benefits are: I can define my own device name, e.g. wlan0mon I can use pre-defined device name in script "iw" utility offers more information in the WiFi network adapter as well as LAN NIC USB device detection is more accurate It can shows device name of my USB WiFi dongle without additional typing It can creates additional logical device that other new users like, such as wifi1, capture2024 Procedure Login to Linux as root, or use one of the following su - sudo su - Find out the physical device ID using "iw dev" command It will dis...

Oracle ORA-0600 on 17090 - When login with wrong password

Product: Oracle Database 19c Symptom When login to Oracle database to a specific user with wrong password, instead of getting ORA-01017, it shown following error, and disconnected the session $ sqlplus tester1/****** SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 26 11:12:16 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.  All rights reserved. ERROR: ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [],[], [], [], [] This only affecting 1 DB user, and not global Analysis Tested with several DB user, and found that only affecting 1 DB user account Checked alert.log file, and found the trc file that generated Following is the content of the trc file with additional failure detail: 2022-10-26T11:12:17.635430-07:00 Unified Audit record write to audit trail table failed due to ORA-1012. Writing the record to OS spillover file. Errors in file /dbf/diag/rdbms/ORCL/ORCL/trace/ORCL_ora_527371.trc  (incident=97297): ORA-00600: internal error cod...

Windows 10: Converting MBT to GPT+EFI Partition Type

Image
Product: Windows 10 Command: mbt2gpt.exe Sharing my experience to convert my MBT boot partition that run Windows 10 to GPT with EFI boot. Let me list down the step I took for my ASUS Z97-A motherboard: Run "CMD" as administrator Determine the disk number diskpart - utility to query disk partition Ref: https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/diskpart list - list all disks select disk 0 - this is my boot disk, i.e. C: detail - show all partitions. Ensure the partition size match my C: and double confirm disk 0 is correct Boot into recovery mode Click Start >  Settings to bring up Windows Setting (Control Panel) Click Update & Security menu Click Recovery menu Convert disk 0 MBT partition to GPT for entire disk.  This will convert entire disk to GPT partition design.  It is not possible to only convert specific partition mbt2gpt /convert /disk:0 Example output MBR2GPT will now attempt to convert disk 0. If conversion i...

AMD Custom Resolution Setting for BenQ EX3501R Ultra Wide Monitor

Image
 Product: BenQ EX3501R Ultra Wide 35" Monitor AMD Radeon Ver 2021/-511.1532.24954 GPU: AMD Radeon HD 7870 Bought the popular 35" ultra wide monitor that support 3440x1440 30Hz HDR.  Tried to configure it to work with older AMD GPU, but found that Windows 10 doesn't offer a list of this resolution. All the detected resolutions are leadings to improper size, and not fill up the entire monitor. After days of testing, and struggling, then I found that I have to install the full Radeon driver in order to launch AMD Radeon Softwere to be able to create custom display resolution. When I got into the custom display resolution screen, then I was confused with a series of values to enter.  BenQ homepage provides no help to fill in the values, so I have to look online how to derive all these parameters based on the resolution of 3440x1440 29.970Hz refresh rate (got the refresh rate from other GPU that works). Following are the values you should enter when creating a custom 3440x1440...

HP Laptop 15 da0022ca - Unable to Boot from USB Drive/SD Card Reader

Vendor: HP Product: HP Laptop 15 da0022ca Model: da0022ca Year Manufactured: 2018 CPU: Intel Core i3-8130U BIOS Firmware Version: F.04 Bought this 2 yr old model for under CAD$400 which has 8th Gen Intel Core technology that supports DDR4 RAM with higher capacity. The first issue I found in Internet about HP laptop is often it cannot boot from USB device, and card reader, which seems to experience by many earlier models.  This issue is encountered in my laptop that sold in 2018-2019 as well. Further testing found that booting from the build-in SD card reader is not available as well. The BIOS's boot order obviously is buggy, and don't allow to boot from both USB device, and build-in SD card reader Following is the procedure to follow in order to make bootable USB thumb drive.  These guideline could be applicable to other laptop models as well as these are general firmware programmer knowledge gap on various technologies and hardware. Option 1: BIOS Firmware Instruction: Upgrad...

Honda/Acura: Shift Knob Stuck at Parking Gear

Image
Listing out troubleshooting process when shift knob stuck at P (Parking) gear for Honda or Acura. 1. Press on BRAKE pedal - check whether rear brake light turns on If no light, see Solution 1 2. Check brake fluid - check it has brake fluid If low fluid, see Solution 2 3. Manually press on BRAKE switch above BRAKE pedal - ensure brake light turns on If switch doesn't turn on brake light on pressing, see Solution 3 4. Connects 12V to shift control solenoid to each pin connector (one pin control 1 solenoid) - it looks like below.  If no clicks when the pin touch 12V, see Solution 4 5. Test battery when cranking (starting) car - make sure it is above 11V If low battery, see Solution 5 6. If needs to drive the car immediately, and no time to diagnose the issue, see Solution 6 as temporary workaround Solution 1 - No brake light 1. Replace fuse for the brake light, if fuse burned 2. The brake light fuse control the gear locking solenoid 3. Temporary w...