Globalization

How to Resolve ORA-01843: not a valid month

Posted on
ORA-01843 ORA-01843: not a valid month means that SQL engine cannot recognize the month value of your input string under current NLS_DATE_LANGUAGE. In this post, I will talk about some error patterns of ORA-01843 listed below: Misspelled Month Value Unmatched Month Value Foreign Month Value ORA-01843 due to Misspelled Month Value There might be typos […]
Patching

How to Apply Patch in Oracle Database

Posted on
Keeping your database running with the newest release of Oracle software might be a critical job for DBA to implement, especially for production environments. Although I’ll talk about the steps that we apply patch, you should read readme.txt in patch files before taking any actions. Pre-Patching 1. Get the Latest OPatch Before any patching, you […]