Posts

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 code, argume
Post a Comment
Read more

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 is success
Post a Comment
Location: Toronto, ON, Canada
Read more

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
Post a Comment
Location: Toronto, ON, Canada
Read more

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: Upgrade
Post a Comment
Location: Toronto, ON, Canada
Read more

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
Post a Comment
Read more

LG G4: Bypass "Verify your account" or Factory Reset Protection

Image
Product: LG G4 Model: H810, H812, H820, H830 Tested Country: Canada Other related product: LG G3, G4, G5, G6 and newer I bought a used LG G4, and without considering Android's Factory Reset Protection, I went into Setting, and done a "Factory Data Reset" from the menu. After boot up, then I am shock that I have to login as previous owner's Google account in order to use the phone. I went into firmware hard reset page below to reset it, but still can't bypass Factory Reset Protection (FRP): With the phone off, hold both Power + Volume Down buttons to power it up When the very first LG logo (static picture) appears, temporary release Power button while holding Volume Down button Within split second, hold both  Power  +  Volume Down  buttons again.  Some internet homepage said keep holding, and some said release both temporary, but I found both are not applicable to my phone The phone should still be in the static LG logo, and not in the animated
Post a Comment
Read more

Internet Thunderbird E-Mail Client: Missing Yahoo Spam Folder

Image
Product: Thunderbird My Yahoo Spam Folder disappeared from Thunderbird, and I do not see the "Bulk Mail" folder any more. Following is the configuration steps to re-enable it: 1. Subscribe to Spam folder 1.1. Right-click on Yahoo.com account 1.2. In the pop up context menu, select " Subscribe... " 2. Select " Bulk Mail " folder, which is Spam  folder in Yahoo web mail 3. Repeat step 1.1, and select " Setting... " to configure spam folder configuration 3.1. Under Yahoo account, select Junk Setting  menu item 3.2. Select radio button "Junk" folder on: Yahoo.com  entry 4. Now Bulk Mail  will be visible under Yahoo account in Thunderhead
Post a Comment
Location: Toronto, ON, Canada
Read more