brtools - SQL error -12705 ?????

[Former Member]

These are the NLS values that are valid.

SQL> SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';

VALUE

-

---

UTF8

gtbwdb1 25: echo $NLS_LANG

AMERICAN_AMERICA.UTF8

I am using Oracle 9.2.0.7 on HP-UX 11.11

[fidel_vales · Accepted solution]

Hi,

I assume that you are getting ORA-12705 when running BRTools.

Usually this error is due to wrong environment variables.

1st question is the kernel that you are using

2nd question is the user that tries to execute brtools

3rd question is the environment variables of that user

4th question is the version of your oracle client

Final question, what is the output of "ls -l /oracle/client/92x_64"

[Former Member · Accepted solution]

1st question is the kernel that you are using

SAP BASIS 640, level: 19, Support Pack: SAPKB64019

2nd question is the user that tries to execute brtools

both oraewp & ewpadm

3rd question is the environment variables of that user

oraewp env...

TZ=MST7

HOME=/oracle/EWP

SHELL=/usr/bin/csh

PATH=/oracle/EWP/920_64/bin:/oracle/EWP:/usr/sap/EWP/SYS/exe/runU:/usr/sap/EWP/S

YS/exe/run:/usr/bin:/usr/ccs/bin:/usr/bin/X11:/usr/contrib/bin:/usr/local/bin:.

LOGNAME=oraewp

SAPSYSTEMNAME=EWP

DIR_LIBRARY=/usr/sap/EWP/SYS/exe/run

SHLIB_PATH=/usr/sap/EWP/SYS/exe/run:/usr/sap/EWP/SYS/exe/runU

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=EWP

dbs_ora_schema=SAPEWP

ORACLE_PSRV=EWP

ORACLE_SID=EWP

DB_SID=EWP

ORACLE_HOME=/oracle/EWP/920_64

ORACLE_BASE=/oracle

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

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/EWP

TERM=xterm

WINDOWID=4194319

DISPLAY=7.248.9.148:0.0

COLUMNS=80

LINES=24

4th question is the version of your oracle client

How can you tell what client you are using?

Final question, what is the output of "ls -l /oracle/client/92x_64"

ls -l /oracle/client/92x_64

total 48

drwxrwxr-x 5 oraewq dba 4096 Jan 10 2007 jdbc

drwxrwxr-x 2 oraewq dba 4096 Jan 10 2007 lib

drwxrwxr-x 3 oraewq dba 4096 Jan 10 2007 network

drwxrwxr-x 3 oraewq dba 4096 Jan 10 2007 ocommon

drwxrwxr-x 4 oraewq dba 4096 Jan 10 2007 oracore

drwxrwxr-x 3 oraewq dba 4096 Jan 10 2007 rdbms

[Former Member · Accepted solution]

The kernel is 640, patch level 155

[fidel_vales · Accepted solution]

Hello William,

Thanks for the info.

The "issue" is here:

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

From the "ls -l" I can "see" that you have "physically" installed the oracle client 9i (there is a post around indicating how to find the correct version, I'll post the link when I find it)

when you execute any of the BR* tools, the oracle library is taken from /oracle/client/92x_64/lib

Unless you have copied in one of the directories in SHLIB_PATH (which is incorrect)

But the nls files are taken from the ORACLE_HOME

Your oracle home is 9.2.0.7, probably your client is older.

There are "known" incompatibilities between NLS versions.

For this reason, SAP recommends not to install "physically" the oracle client on the database server, instead you should "softlink" the directories from the client to the ORACLE_HOME. That is done with the "CROCLNK" tool (script)

The SAP Note 539922 "Installing the ORACLE client software 9.2.X for UNIX" has details on the correct ORA_NLS33 values and on how to use CROCLLNK

[Former Member · Accepted solution]

Would this also cause the problem.

- Up until April 27th brtools was working in production.

- Our QA & PRD systems use a NAS file system for /oracle/client.

- I found out yesterday that someone upgraded the client to 9208 on QA (kernel patch level 196).

- The Prd kernel patch level is 155.

Should I upgrade the PRD kernel to 196?

[fidel_vales · Accepted solution]

Hello William,

If I understand properly, all your system share the same Oracle client directory.

If so, the cause is the upgrade. Oracle client version is 9.2.0.8 and your RDBMS is 9.2.0.7

The kernel change will not help.

Better would be to change the ORA_NLS33 to point to the oracle client directory.

Try it and let us know if it works

[Former Member · Accepted solution]

login as oraewp

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

unsetenv ORA_NLS33

setenv ORA_NLS33 /oracle/client/92x_64/ocommon/nls/admin/data

I still get the error...

more /oracle/EWP/sapcheck/cdxppttd.cln

BR0801I BRCONNECT 6.40 (47)

BR0805I Start of BRCONNECT processing: cdxppttd.cln 2008-04-02 08.36.37

BR0484I BRCONNECT log file: /oracle/EWP/sapcheck/cdxppttd.cln

BR0280I BRCONNECT time stamp: 2008-04-02 08.36.37

BR0301E SQL error -12705 at location db_connect-2

ORA-12705: invalid or unknown NLS parameter value specified

BR0310E Connect to database instance EWP failed

BR0280I BRCONNECT time stamp: 2008-04-02 08.36.38

BR0301E SQL error -12705 at location db_connect-2

ORA-12705: invalid or unknown NLS parameter value specified

BR0310E Connect to database instance EWP failed

BR0806I End of BRCONNECT processing: cdxppttd.cln 2008-04-02 08.36.37

BR0280I BRCONNECT time stamp: 2008-04-02 08.36.38

BR0804I BRCONNECT terminated with errors

[Former Member · Accepted solution]

You need to execute the BRTOOLS with user SIDADM. Change the ORA_NLS33 from this user, from ORASID it's must to be the ORA_NLS33=/oracle/EWP/920_64/ocommon/nls/admin/data

and from

SIDADM ORA_NLS33 /oracle/client/92x_64/ocommon/nls/admin/data

Regards.

[Former Member · Accepted solution]

We separated the /oracle/client on the QA & PRD.

Then we replaced 92x_64 with what was there last week.

Now everything in brtools works except for backups.

When I do an archive backup, the job hangs here...

BR0002I BRARCHIVE 6.40 (47)

BR0006I Start of offline redo log processing: adxpqrtf.cds 2008-04-02 13.07.03

BR0484I BRARCHIVE log file: /oracle/EWP/saparch/adxpqrtf.cds

BR0049W Last BRARCHIVE run was probably killed

BR0477I Oracle pfile /oracle/EWP/920_64/dbs/initEWP.ora created from spfile /oracle/EWP/920_64/dbs/spfileEWP.ora

Any advice?

[Former Member · Accepted solution]

Hi William. I'm do not understood where job hangs here ??

If BRARCHIVE or BRBACKUP terminate..The process number of the running program is stored in these files.If the system finds that a process with this number is no longer active (BRARCHIVE/BRBACKUP can no longer run) when you next call these programs, the following warning is output:

BR049W Last BRARCHIVE/BRBACKUP run was probably killed and the processing is continued.

It's only warning not error. Provide full log... Also i'm think your answer about the "brtools - SQL error -12705 ?????"

is comlete and you need to close this thread (If I have correctly understood you). Regards.

[Former Member]

What is your question ?