Monthly Archives: September 2012

ORA-01843: not a valid month

Problem:

When trying to convert the char column (attribute9) to date using the to_date function in SQL Developer, the following error is displayed:

ORA-01843: not a valid month
01843. 00000 -  "not a valid month"
*Cause:   
*Action:

Solution:

Dates were stored in two different formats (mm/dd/yyyy) and (dd-mon-yyyy) in the attribute9 column. Convert all dates to one format (dd-mon-yyyy).

‘ap7001are.us.oracle.com’ Target Host in R12 Database Control

‘ap7001are.us.oracle.com’ Target Host in R12 Database Control

Problem:

After enabling and launching Database Control on an R12.1 instance, the instance ‘ap7001are.us.oracle.com’ is seen as a target host and ‘PROD_ap7001are.us.oracle.com’ as the listener.

Solution:

Drop and recreate the Enterprise Manager repository on the R12 instance.

Read more »

tzOffset for America/Caracas is -270(min), but agent is running with tzOffset -240(min)

Problem:

While configuring Enterprise Manager Database Control for an R12.1 instance on Windows 2008, the following error is encountered:

tzOffset for America/Caracas is -270(min), but agent is runnning with tzOffset 
-240(min)

Solution:

Change time zone in emd.properties and operating system.

Read more »