brbackup - getting ORA-12705: invalid or unknown NLS parameter value

[Former Member]

I am using:

Kernel: 640

Oracle: 9.2.0.6

NLS_LANG=AMERICAN_AMERICA.UTF8 (The CHECKS.SQL script says this is okay.)

ORA_NLS33=/oracle/DWD/920_64/ocommon/nls/admin/data

Latest 9.2 client: /oracle/92x_64

Is there anything I should look at to fix this error?

[Former Member · Accepted solution]

Sometime it also cause wrong NLS_LANG settting. You might want try NLS_LANG =AMERICAN_AMERICA.WE8DEC

[Former Member · Accepted solution]

The DWD (Oracle 9.2.0.6) used to work okay, until I upgraded the client to 9207.

I needed the client 9207 for the kernel 640 and the Oracle 10g instance.

On the box I have 2 instances:

DWD - Kernel 640 - Oracle 10.2.0.2 <== This needs the 9207 client

DWT - Kernel 640 - Oracle 9.2.0.6 <== This now doesn't work with 9207 client

Clients: /oacle/client/10x_64 & /oacle/client/92x_64

The 92x_64 is the latest 9207 client.

Is there a way to get the Oracle 9.2.0.6 tpo work with vlient 9207, Or do I hhave to upgarde to Oracle 9.2.0.7 or 10.2.0.2?

[former_member185954 · Accepted solution]

Hi,

I hope you have installed your oracle client using the procedure in this note:

Note 886783 - Installing Oracle 9207 Client Software on UNIX

Also please check the following note:

Note 964783 - Updating Oracle client on host with multiple SAP systems

The above note should resolve your issue.

Regards,

Siddhesh

Message was edited by:

Siddhesh Ghag

[Former Member · Accepted solution]

Note 964783 did the trick!

[former_member185954 · Accepted solution]

Hi,

Glad that the problem is resolved, i have never faced this problem, but I just searched it out cause it was interesting , thanks to your problem, now even I have this info.

This is what I like about Forums, its all about knowledge sharing.

Good luck with your SAP instance

Regards,

Siddhesh

[Former Member]

HI

Check Note 592657 and 175636. Make sure that all the softlinks are properly maintained in oracle/client/92x_64.Usually if you go in /oracle/client/92x_64 you can see lib directory and there will be a soft link to /oracle/<sid>/920_64/lib

eg:

20] % pwd

/oracle/client/92x_64

[21] % ls -l

total 0

lrwxr-xr-x 1 ora<sid> dba 22 Jul 6 2005 lib -> /oracle/<sid>/920_64/lib

Thanks

Prince Jose

Message was edited by:

Prince Jose

[Former Member]

I think my problem may be this????

Note 180430 - "Therefore, the database release that you use can be higher than the clinet release suitable for the R/3 kernel, but it can never be lower'

On the box I have 2 instances:

DWD - Kernel 640 - Oracle 10.2.0.2

DWT - Kernel 640 - Oracle 9.2.0.6

Clients: /oacle/client/10x_64 & /oacle/client/92x_64

The 92x_64 is the latest 9207 client.

Does that mean Oracle 9.2.0.6 cannot use the upgraded 92x_64 client?

[former_member185954]

Hi William,

Is the environment set correctly for the userid which you are using to initiate br*tools ?

It could be that since you have 2 clients (Oracle 10g and 9i), your NLS_LANG is not set properly and is confusing the br*tools.

Also i noticed, that you have mentioned:

ORA_NLS33=/oracle/DWD/920_64/ocommon/nls/admin/data

in your first post,

however in your 2nd post you have mentioned :

DWT = Oracle 9

and DWD = Oracle 10g

So you can change your variable ORA_NLS33 to :

ORA_NLS33=/oracle/<b>DWT</b>/920_64/ocommon/nls/admin/data

Regards,

Siddhesh

Message was edited by:

Siddhesh Ghag