Re: export errors

From: Tom Sterin <sterin_at_telocity.com>
Date: Mon, 19 Aug 2002 21:29:59 -0400
Message-ID: <3d619aa9$1_1@nopics.sjc>

On Mon, 19 Aug 2002 18:08:20 -0400, Sybrand Bakker wrote:

> On Mon, 19 Aug 2002 17:42:49 -0400, Tom Sterin <sterin_at_telocity.com>
> wrote:
> 

>>On Mon, 19 Aug 2002 17:09:07 -0400, Sybrand Bakker wrote:
>>
>>> On Mon, 19 Aug 2002 16:09:41 -0400, Tom Sterin <sterin_at_telocity.com>
>>> wrote:
>>>
>>>>I tried that earlier. It doesn't change the behavior. I also tried 2
>>>>other settings for NLS_LANG. Don't remember exactly what they were,
>>>>but I believe it was the same with some letters lower-case and one
>>>>with a different string at the end (following the .)
>>>
>>> add
>>> export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
>>>
>>> to your .profile
>>>
>>> Hth
>>>
>>>
>>> Sybrand Bakker, Senior Oracle DBA
>>>
>>> To reply remove -verwijderdit from my e-mail address
>>
>>
>>Still doesn't work. Adding the env variable didn't change the behavior.
>>I tried it with and without the NLS_LANG variable set.
>>
>>Are the two problems (export and sqlplus not finding the message file)
>>the same problem?
>>
>>Thanks.
>>
>>Tom

> 
> they are.
> please verify there is actually something in $ORA_NLS33 and you have the
> <facility><language>.msb files installed ( you must have because oerr
> works but anyway)
> 
> Hth
> 
> 
> Sybrand Bakker, Senior Oracle DBA
> 
> To reply remove -verwijderdit from my e-mail address
 
 

Yes, there are files named lx____.nlb in $ORA_NLS33

/opt/app/oracle:> echo $ORA_NLS33
/opt/app/oracle/product/8.1.6/ocommon/nls/admin/data
/opt/app/oracle:> ls -1 $ORA_NLS33 | wc -l

    453
/opt/app/oracle:>

I believe the .msb files you are asking about are in $ORACLE_HOME/rdbms/mesg. There are files including oraus.msb, oraus.msg, expus.msb, expus.msg, and others.

Any other thoughts? Or could it be time to reinstall Oracle? I have the same problem in my applications but can work around them with oerr. But now I really need to do this export.

Thanks. Received on Mon Aug 19 2002 - 20:29:59 CDT