ORA-12709: error while loading create database character set


Well, it so happens that I started a recently upgraded 11.2.0.4 DB and got this error. It also meant that the DB wouldn’t mount.

It turns out that the default ORA_NLS10 variable to set to a wrong value (I am suspecting EBS autoconfig, but this research is still pending). Setting it to the correct value fixed the issue for me. I also updated the EBS environment setting script with the correct value.

ORA_NLS10=$ORACLE_HOME/nls/data
export ORA_NLS10

 

Reference: ORA_NLS (ORA_NLS32, ORA_NLS33, ORA_NLS10) Environment Variables explained. (Doc ID 77442.1)

Leave a comment

Your email address will not be published. Required fields are marked *