BR0301E SQL error -12705 at location BrDbConnect-2

[Former Member]

Hi All,

We are getting the below error while running the backup through cron. The backup runs fine when manually executed or through brtools.

There are 2 databases on this server and we have upgraded one database(R3S) to 9.2.0.8 and the other database which is causing problem is on 9.2.0.7.

The error log:

BR0051I BRBACKUP 6.40 (44)

BR0055I Start of database backup: bdycqvwn.anf 2008-06-10 11.05.01

BR0484I BRBACKUP log file: /oracle/REH/sapbackup/bdycqvwn.anf

BR0280I BRBACKUP time stamp: 2008-06-10 11.05.02

BR0301E SQL error -12705 at location BrDbConnect-2

ORA-12705: invalid or unknown NLS parameter value specified

BR0310E Connect to database instance REH failed

BR0280I BRBACKUP time stamp: 2008-06-10 11.05.02

BR0301E SQL error -12705 at location BrDbConnect-2

ORA-12705: invalid or unknown NLS parameter value specified

BR0310E Connect to database instance REH failed

BR0056I End of database backup: bdycqvwn.anf 2008-06-10 11.05.02

BR0280I BRBACKUP time stamp: 2008-06-10 11.05.02

BR0054I BRBACKUP terminated with errors

Any help will be much appreciated.

Regards

Amit.

[Former Member]

Hi Markus,

Cron does execute the .dbenv_cntdr01.sh or .dbenv_cntdr01.csh before executing the backup.

Amit.

[Former Member]

The orareh does have the read permission to access those files. Implementing the new client will be the last option.

Is there any workaround apart from that which can be done to resolve this issue.

[markus_doehr2]

Do you explicitly source the environment before you execute the command when you use cron?

I mean, do you do something like

(for csh):

 
source .dbenv_<hostname>.csh

or

(for ksh/sh):

. dbenv_<hostname>.sh

or do you just call the brbackup tool?

Markus

[Former Member]

Hello,

set this parameter

BR_ORA_NLS33 = /oracle/client/92x_<bits>/ocommon/nls/admin/data

[Former Member]

We had tried initaially with the same but we were encountering the same error.

Initially it was set to ORA_NLS33=/oracle/REH/920_64/ocommon/nls/admin/data

I had read from the forum, that we need to change the ORA_NLS33 parameter to point to the new client.

[markus_doehr2]

Has the user "orareh" the correct permissions to read that directory?

I wouldn't point that environment to a different ORACLE_HOME but install an Oracle client itself for that instance.

Markus

[markus_doehr2]

What are the values of the NLS* environment variables for the user executing that backup? Cron does not take them automatically.

Markus

[Former Member]

The NLS values are

NLS_LANGUAGE AMERICAN

NLS_TERRITORY AMERICA

NLS_CHARACTERSET WE8DEC

And env has been set to:

HOME=/oracle/REH

PATH=/oracle/REH/920_64/bin:.:/oracle/REH:/usr/sap/REH/SYS/exe/run:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/fc/bin:/opt/fcms/bin:/opt/upgrade/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/perf/bin://opt/perl/bin:/opt/resmon/bin:/usr/sbin/diag/contrib:/opt/pred/bin:/opt/hparray/bin:/opt/graphics/common/bin:/opt/ignite/bin:/opt/networker/bin:/opt/OV/bin/OpC:/opt/OV/bin:/opt/prm/bin:/opt/ssh/bin

LOGNAME=orareh

SHELL=/bin/csh

TERM=xterm

COLUMNS=126

LINES=45

MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/share/man:/usr/dt/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/samba/man:/opt/perf/man/%L:/opt/perf/man://opt/perl/man:/opt/resmon/share/man:/opt/pred/share/man/%L:/opt/pred/share/man:/opt/hparray/share/man/%L:/opt/hparray/share/man:/opt/graphics/common/man:/opt/networker/man:/opt/prm/man/%L:/opt/prm/man:/opt/ssh/share/man

TZ=EST5EDT

SAPSYSTEMNAME=REH

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

SHLIB_PATH=/usr/sap/REH/SYS/exe/run:/oracle/REH/920_64/lib

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=REH

dbs_ora_schema=SAPREH

ORACLE_PSRV=REH

ORACLE_SID=REH

DB_SID=REH

ORACLE_HOME=/oracle/REH/920_64

ORACLE_BASE=/oracle

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

NLS_LANG=AMERICAN_AMERICA.WE8DEC

SAPDATA_HOME=/oracle/REH

Regards

Amit.

[markus_doehr2]

> HOME=/oracle/REH

> ORA_NLS33=/oracle/R3S/920_64/ocommon/nls/admin/data

If the ORACLE_HOME is /oracle/REH, you should adapt the ORAL_NLS33 parameter accordingly....

Markus