Re: ORA-12709 when starting the database

Check the environment variable ORA_NLS33; its probably not set or it's set incorrectly.

If you use sh Bourne or ksh :

    ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data     export ORA_NLS33

If you use C shell :

    setenv ORA_NLS33 $ORACLE_HOME/ocommon/nls/admin/data

This may fix the problem.

David Fitzjarrell

mgeiling_at_web.de (Michael Geiling) wrote in message news:<f22e5e67.0210092155.78c85564_at_posting.google.com>...
> Karsten Farell <kfarrell_at_medimpact.com> wrote in message news:<jIZo9.1710$826.131038382_at_newssvr21.news.prodigy.com>...
> > Michael Geiling wrote:
> > > We generated a DB using DBCA->new database; this seemed to work ok.
> > > When we used sqlplus to start the db (startup pfile=...) we get the
> > > error 12709 which is an internal error related to the database
> > > character set.
> > > Are there any tips who to get around this error.
> >
> > I typed 'ora-12709' into Google and got 50 matches. You didn't supply
> > enough info for me to diagnose your exact problem (like db or os
> > version) ... maybe one of the hits on Google has your answer. It's worth
> > a look.
>
> I did the same (after reading the docu which says: 'This in an
> internal error. Contact Oracle Support Services') but didn't get
> nowhere. The OSs I'm using is SuSE 8.0 and debian/woody along with
> Oracle 9iR2.
> Thanks
Received on Thu Oct 10 2002 - 12:50:07 CDT