2 Replies Latest reply: Nov 17, 2012 7:18 AM by Zack.L RSS

    ORA-12709

    Zack.L
      Hi all,

      Encountered the error after copying back some missing files to $ORACLE_HOME/sqlplus/mesg directory
      and trying to startup database:

      $sqlplus / as sysdba
      startup
      ORA-12709: error while loading create database character set.

      Database NLS_LANG has always being set to Simplified Chinese_China.ZHS16gbk.

      Currently do not access to MOS.

      Regards
      Zack
        • 1. Re: ORA-12709
          Shivananda Rao
          Zack.L wrote:
          Hi all,

          Encountered the error after copying back some missing files to $ORACLE_HOME/sqlplus/mesg directory
          and trying to startup database:

          $sqlplus / as sysdba
          startup
          ORA-12709: error while loading create database character set.

          Database NLS_LANG has always being set to Simplified Chinese_China.ZHS16gbk.

          Currently do not access to MOS.

          Regards
          Zack
          Hello again,

          I would suggest you to contact Oracle Support for this issue. Do you have multiple Oracle Homes on your server ?
          • 2. Re: ORA-12709
            Zack.L
            Hi Shivananda,

            Single installation.

            Looks like i had files missing from my server.
            After copying file from another server, am able to login to sqlplus and do startup.

            Question is why are files missing in the first place ?
            Human error would be the 1st guess....but to best of my knowledge, no one had login and did
            any file deletion in Linux server.

            Regards
            Zack

            Edited by: Zack.L on Nov 17, 2012 9:17 PM