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
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.
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.
Recent Comments