Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
RE: 10g ORA-12709: Error while loading create database character set
(FIXED)

RE: 10g ORA-12709: Error while loading create database character set
(FIXED)

2004-03-14       - By Jay


RE: 10g ORA-12709 (See ORA-12709.ora-code.com): Error while loading create database character setDear
All,
I coped all the NLS related files from installer extraction
(/Disk1/stage/Components/oracle.rfs.nlsrtl_rsf/10.1.0.2.0/1/DatFiles/onls.ja
r

Thanks
Sami
-- --Original Message-- --
From: David Sharples [mailto:oracle-l-bounce@(protected)]On Behalf Of
David Sharples
Sent: Sunday, March 14, 2004 8:02 PM
To: oracle-l@(protected)
Subject: RE: 10g ORA-12709 (See ORA-12709.ora-code.com): Error while loading create database character
set


cant you just reinstall the software again - safest way I reckon


-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---
--
From: oracle-l-bounce@(protected) on behalf of Jay
Sent: Sun 14/03/2004 22:24
To: oracle-l@(protected)
Subject: RE: 10g ORA-12709 (See ORA-12709.ora-code.com): Error while loading create database character
set


Dear All,

Could someone send me these file from Linux 10g environment?

> On the assumption that your characterset was we8iso8859p1 the files you
may have
> lost are
> LX2001F.NLB for the characterset
> LX00001.NLB for the American Language
> LX10001.NLB for the American Territory

Thanks
Jay

-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Michael Moller
Sent: Sunday, March 14, 2004 5:04 PM
To: oracle-l@(protected)
Subject: Re: 10g ORA-12709 (See ORA-12709.ora-code.com): Error while loading create database
character set


Hi Jay,

now why would you do such a silly thing? (nothing like getting salt rubbed
into
your wounds, is there? ;-) Sorry about the (mild) tease.

On the assumption that your characterset was we8iso8859p1 the files you
may
have
lost are
LX2001F.NLB for the characterset
LX00001.NLB for the American Language
LX10001.NLB for the American Territory
(blank) for BINARY sort
There also is a bootstrap file LX0BOOT.NLB and LX1BOOT.NLB
Yes, you can copy them from another kit of the same platform (roughly the
same
will be good enough). I 'm still waiting for my 10g to boot to doubly
confirm
the
filenames for 10g, the ones I gave are from 9i and they most probably
remain
the
same for 10g. You probably can copy from a 9i kit.

Usde the Locale Builder in Open File by Object type to identify other
filenames
for other languages (that 's what I did)
M-square

Jay wrote:

> Dear All,
>
> Version 10g, Linux.
>
> Mistakely I did delete some files under $ORACLE_HOME/nls dir and now I
am
> getting
> "ORA-12709 (See ORA-12709.ora-code.com): Error while loading create database character set "
>
> Is there any easy workaround to fix this issue? I created my DB with
default
> characterset(WE...).
> Is it possible to copy the files(from some other linux installation)
which
I
> deleted ?
>
> Any help would be really appreciated.
> Thanks
> Jay
>
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> To unsubscribe send email to: oracle-l-request@(protected)
> put 'unsubscribe ' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --

-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --

-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML > <HEAD > <TITLE >RE: 10g ORA-12709 (See ORA-12709.ora-code.com): Error while loading create database character set </TITLE >
<META http-equiv=Content-Type content= "text/html; charset=iso-8859-1 " >
<META content= "MSHTML 5.50.4926.2500 " name=GENERATOR > </HEAD >
<BODY >
<DIV > <SPAN class=383093302-15032004 > <FONT face=Arial color=#0000ff size=2 >Dear
All, </FONT > </SPAN > </DIV >
<DIV > <SPAN class=383093302-15032004 > <FONT face=Arial color=#0000ff size=2 >I
coped all the NLS related files from installer extraction
(/Disk1/stage/Components/oracle.rfs.nlsrtl_rsf/10.1.0.2.0/1/DatFiles/onls.jar </FONT > </SPAN > </DIV >
<DIV > <SPAN class=383093302-15032004 > <FONT face=Arial color=#0000ff
size=2 > </FONT > </SPAN >  </DIV >
<DIV > <SPAN class=383093302-15032004 > <FONT face=Arial color=#0000ff
size=2 >Thanks </FONT > </SPAN > </DIV >
<DIV > <SPAN class=383093302-15032004 > <FONT face=Arial color=#0000ff
size=2 >Sami </FONT > </SPAN > </DIV >
<BLOCKQUOTE dir=ltr style= "MARGIN-RIGHT: 0px " >
<DIV class=OutlookMessageHeader dir=ltr align=left > <FONT face=Tahoma
size=2 >-- --Original Message-- -- <BR > <B >From: </B > David Sharples
[mailto:oracle-l-bounce@(protected)] <B >On Behalf Of </B >David
Sharples <BR > <B >Sent: </B > Sunday, March 14, 2004 8:02 PM <BR > <B >To: </B >
oracle-l@(protected) <BR > <B >Subject: </B > RE: 10g ORA-12709 (See ORA-12709.ora-code.com): Error while
loading create database character set <BR > <BR > </FONT > </DIV >
<DIV id=idOWAReplyText29140 dir=ltr >
<DIV dir=ltr > <FONT face=Arial color=#000000 size=2 >cant you just reinstall the
software again - safest way I reckon </FONT > </DIV > </DIV >
<DIV dir=ltr > <BR >
<HR tabIndex=-1 >
<FONT face=Tahoma size=2 > <B >From: </B > oracle-l-bounce@(protected) on behalf
of Jay <BR > <B >Sent: </B > Sun 14/03/2004 22:24 <BR > <B >To: </B >
oracle-l@(protected) <BR > <B >Subject: </B > RE: 10g ORA-12709 (See ORA-12709.ora-code.com): Error while
loading create database character set <BR > </FONT > <BR > </DIV >
<DIV >
<P > <FONT size=2 >Dear All, <BR > <BR >Could someone send me these file from Linux
10g environment? <BR > <BR >> On the assumption that your characterset was
we8iso8859p1 the files you <BR >may have <BR >> lost are <BR >> LX2001F.NLB
for the characterset <BR >> LX00001.NLB for the American Language <BR >>
LX10001.NLB for the American
Territory <BR > <BR >Thanks <BR >Jay <BR > <BR >-- --Original Message-- -- <BR >From:
oracle-l-bounce@(protected) <BR >[ <A
href= "mailto:oracle-l-bounce@(protected) " >mailto:oracle-l-bounce@(protected) </A >]On
Behalf Of Michael Moller <BR >Sent: Sunday, March 14, 2004 5:04 PM <BR >To:
oracle-l@(protected) <BR >Subject: Re: 10g ORA-12709 (See ORA-12709.ora-code.com): Error while loading
create database <BR >character set <BR > <BR > <BR >Hi Jay, <BR > <BR >now why would you
do such a silly thing? (nothing like getting salt rubbed <BR >into <BR >your
wounds, is there? ;-) Sorry about the (mild) tease. <BR > <BR >On the assumption
that your characterset was we8iso8859p1 the files you may <BR >have <BR >lost
are <BR >LX2001F.NLB for the characterset <BR >LX00001.NLB for the American
Language <BR >LX10001.NLB for the American
Territory <BR >(blank)            
for BINARY sort <BR >There also is a bootstrap file LX0BOOT.NLB and
LX1BOOT.NLB <BR >Yes, you can copy them from another kit of the same platform
(roughly the <BR >same <BR >will be good enough). I 'm still waiting for my 10g to
boot to doubly confirm <BR >the <BR >filenames for 10g, the ones I gave are from
9i and they most probably remain <BR >the <BR >same for 10g. You probably can copy
from a 9i kit. <BR > <BR >Usde the Locale Builder in Open File by Object type to
identify other <BR >filenames <BR >for other languages (that 's what I
did) <BR >M-square <BR > <BR >Jay wrote: <BR > <BR >> Dear All, <BR >> <BR >>
Version 10g, Linux. <BR >> <BR >> Mistakely I did delete some files under
$ORACLE_HOME/nls dir and now I am <BR >> getting <BR >> "ORA-12709 (See ORA-12709.ora-code.com): Error
while loading create database character set " <BR >> <BR >> Is there any easy
workaround to fix this issue? I created my DB with <BR >default <BR >>
characterset(WE...). <BR >> Is it possible to copy the files(from some other
linux installation) which <BR >I <BR >> deleted ? <BR >> <BR >> Any help
would be really appreciated. <BR >> Thanks <BR >> Jay <BR >> <BR >>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >>
Please see the official ORACLE-L FAQ: <A
href= "http://www.orafaq.com " >http://www.orafaq.com </A > <BR >>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >> To
unsubscribe send email to:  oracle-l-request@(protected) <BR >> put
'unsubscribe ' in the subject line. <BR >> -- <BR >> Archives are at <A
href= "http://www.freelists.org/archives/oracle-l/ " >http://www.freelists.org/archives/oracle-l/ </A > <BR >>
FAQ is at <A
href= "http://www.freelists.org/help/fom-serve/cache/1.html " >http://www.freelists.org/help/fom-serve/cache/1.html </A > <BR >>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- <BR > <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >Please
see the official ORACLE-L FAQ: <A
href= "http://www.orafaq.com " >http://www.orafaq.com </A > <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >To
unsubscribe send email to:  oracle-l-request@(protected) <BR >put
'unsubscribe ' in the subject line. <BR >-- <BR >Archives are at <A
href= "http://www.freelists.org/archives/oracle-l/ " >http://www.freelists.org/archives/oracle-l/ </A > <BR >FAQ
is at <A
href= "http://www.freelists.org/help/fom-serve/cache/1.html " >http://www.freelists.org/help/fom-serve/cache/1.html </A > <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- <BR > <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >Please
see the official ORACLE-L FAQ: <A
href= "http://www.orafaq.com " >http://www.orafaq.com </A > <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >To
unsubscribe send email to:  oracle-l-request@(protected) <BR >put
'unsubscribe ' in the subject line. <BR >-- <BR >Archives are at <A
href= "http://www.freelists.org/archives/oracle-l/ " >http://www.freelists.org/archives/oracle-l/ </A > <BR >FAQ
is at <A
href= "http://www.freelists.org/help/fom-serve/cache/1.html " >http://www.freelists.org/help/fom-serve/cache/1.html </A > <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- <BR > </FONT > </P > </DIV > </BLOCKQUOTE > </BODY > </HTML >