This discussion is archived
2 Replies Latest reply: Nov 17, 2012 5:18 AM by Zack.L RSS

ORA-12709

Zack.L Explorer
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points