Oracle Database 18c

How to Resolve ASMLib Fails to Open Disk Candidates

by Ed Chen
October 5, 2018February 13, 2023

ASMLib Seems Good In my grid installation plan for 18c database, I use ASMLib to make device path persistent for ASM candidate disks. As a… Read More »

How to Delete Old Audit Files in Oracle

by Ed Chen
May 17, 2018October 8, 2022

ADUMP Cleanup Audit files cannot be deleted like trace files deletion by ADR Command Interpreter (ADRCI), so we need to delete them at OS-level by… Read More »

How to Resolve ORA-28040: No matching authentication protocol

by Ed Chen
April 27, 2018December 11, 2022
35 Comments

ORA-28040 When I tried to connect to a 12.1 database from an Oracle client 9.2, it failed with ORA-28040: No matching authentication protocol. I knew… Read More »

How Oracle Enable EM Express

by Ed Chen
February 18, 2018May 24, 2023

Enable EM Express After installing 12c database, you may want to enable dbconsole just like 10g and 11g, but in fact, there's no emctl command… Read More »

How Oracle Enable ARCHIVELOG Mode

by Ed Chen
September 25, 2010December 11, 2022

What is Archivinglog Mode? The process of copying inactive redo log files into archived files is called archiving. Archiving is only effective on databases which… Read More »

JavaScript is not enabled. Please enable it and reload the page.