1) When we use the following SQL statement
INSERT INTO “temptable” (DELIVER_DATE) VALUES (TO_DATE(’27-Jun-2007 15:57:30′,’DD-MON-YYYY HH24:MI: SS’))
Runtime error occurred: 1843 (ORA-01843: invalid month) The 
database will report an ORA-01843 error. This is because the client is in a Chinese environment, and the format mon cannot be written in English. It must be written in Chinese
If you don’t want to modify the sql statement to run in June , you need to use the alter session command to modify nls_date_language to american before executing the statement, as follows:
alter session set nls_date_language=’american’ –display the date in English
2)
Today An error of ORA-01843 has occurred. This error represents an invalid month, which is usually prompted when the date is converted. 
Solution 
alter session set NLS_DATE_FORMAT=’DD-MON-YY’; 

Read More:

• How to Solve mysql [Err] 1067-Invalid default value for
• [Solved]ERROR 1067 (42000): Invalid default value for ‘end_time‘ Mysql
• [Solved] MySQL5.6.44 [Err] 1067 – Invalid default value for create_date settlement programme
• MYSQL Create TIMESTAMP and Save Error: ERROR 1067 (42000): Invalid default value for ‘last_updated_on’
• Mysql :error 1111. Invalid use of group function
• [Two Methods] Ora-00904: invalid group by error identifier
• Database mirroring connection error 4’An error occurred while receiving data: ‘10054(An existing connection was forcibly closed by the remote host.)
• Mysql ERROR 1067: Invalid default value for ‘date’ [How to Solve]
• Idea connect mysql error Server returns invalid timezone. Go to’Advanced’ tab and set’serverTimezone’ property
• pymysql Error: File “/usr/local/lib/python2.7/site-packages/PyMySQL-1.0.2-py2.7.egg/pymysql/connections.py”, line 167 SyntaxError: invalid syntax
• mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin
• MySQL automatically creates partitions through events
• How to release Oracle PLSQL data lock table
• Bulk Update Error: #Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax； check the m
• [Solved] MySQL: Syntax error or access violation: 1055 Expression #1 of SELECT list is not …
• [Solved] ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost‘
• MYSQL Insert Data Error: check the manual that corresponds to your MySQL server version for the right syntax
• ORA-04088: error during execution of trigger [How to Solve]
• Front end error: exceptionmessage: null [How to Solve]