Failed: brconnect -u / -c -f check

[Former Member]

Any advice on the following when run by d3padm?

sdr3db1 35: brconnect -u / -c -f check

BR0801I BRCONNECT 6.40 (38)

BR0805I Start of BRCONNECT processing: cduepmby.chk 2006-12-18 13.42.34

BR0280I BRCONNECT time stamp: 2006-12-18 13.42.34

BR0301E SQL error -12705 at location db_connect-2

ORA-12705: invalid or unknown NLS parameter value specified

BR0310E Connect to database instance D3P failed

BR0280I BRCONNECT time stamp: 2006-12-18 13.42.34

BR0301E SQL error -12705 at location db_connect-2

ORA-12705: invalid or unknown NLS parameter value specified

BR0310E Connect to database instance D3P failed

BR0806I End of BRCONNECT processing: cduepmby.chk 2006-12-18 13.42.34

BR0280I BRCONNECT time stamp: 2006-12-18 13.42.34

BR0804I BRCONNECT terminated with errors

[Former Member · Accepted solution]

William,

You could have provided version details.

Ref note 592657,Hope this will help you

Regards

Vinod

[Former Member · Accepted solution]

I looked in the note.

Here is some more information.

SAP R/3 Enterprise

Kernel Release 640

Oracle 9.2.0.6

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

NLS_LANG=AMERICAN_AMERICA.UTF8

The files in ORA_NLS33=/oracle/D3P/920_64/ocommon/nls/admin/data all have permissions 644

THe br files have these permissions in /sapmnt/D3P/exe

sdr3db1 52: ll br*

-rwsrwxr-x 1 orad3p sapsys 3247080 Apr 2 2006 brarchive

-rwsrwxr-x 1 orad3p sapsys 3357240 Apr 2 2006 brbackup

-rwsrwxr-x 1 orad3p sapsys 4433712 Apr 2 2006 brconnect

-rwxr-xr-x 1 d3padm sapsys 3667808 Apr 2 2006 brrecover

-rwxr-xr-x 1 d3padm sapsys 1430384 Mar 31 2006 brrestore

-rwxr-xr-x 1 d3padm sapsys 4618360 Apr 2 2006 brspace

-rwsrwxr-x 1 orad3p sapsys 2025664 Apr 2 2006 brtools

As d3padm I can run sqlplus /

SQL> SELECT VALUE FROM V$NLS_PARAMETERS WHERE

PARAMETER = 'NLS_CHARACTERSET';

2

VALUE

-

---

UTF8

R3trans -d works

[Former Member · Accepted solution]

Hi

Check the enviornment variables of user d3padm. It might have some invalid NLS variables.

you can see it usinf env command

thanks

Prince Jose

[Former Member · Accepted solution]

Hello William,

please try to execute sapdba_role.sql script.

This should help.

Bye

Renato

[Former Member · Accepted solution]

I ran @sapdba_role.sql D3P UNIX

And it went okay.

But I still get the same error.

sdr3db1 21: cd /sapmnt/D3P/exe

sdr3db1 22: sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.6.0 - Production on Wed Dec 20 10:13:43 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.6.0 - Production

SQL> exit

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Producti

on

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.6.0 - Production

sdr3db1 23: sqlplus /NOLOG

SQL*Plus: Release 9.2.0.6.0 - Production on Wed Dec 20 10:13:54 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> @sapdba_role.sql D3P UNIX

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Producti

on

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.6.0 - Production

sdr3db1 24: tail -20 sapdba_role.log

Grant succeeded.

old 1: grant SELECT on &User..DBCHK to sapdba

new 1: grant SELECT on SAPD3P.DBCHK to sapdba

Grant succeeded.

old 1: grant SELECT on &User..DBDIFF to sapdba

new 1: grant SELECT on SAPD3P.DBDIFF to sapdba

Grant succeeded.

old 12: Statement := 'grant SELECT on &User..RSNSPACE to sapdba';

new 12: Statement := 'grant SELECT on SAPD3P.RSNSPACE to sapdba';

old 21: Statement := 'grant SELECT on &User..RSPSPACE to sapdba';

new 21: Statement := 'grant SELECT on SAPD3P.RSPSPACE to sapdba';

PL/SQL procedure successfully completed.

[Former Member · Accepted solution]

Hello William,

The error is related to the NLS files.

I assume that you are executing BRCONNECT with the user d3padm ( if not, tell me )

Please, let me know if the oracle client is installed or there are softlinks to the $ORACLE_HOME.

The ORA_NLS33 setting is not correct. It has to point to the oracle client location.

If you are on a 64 bit unix it is:

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

In case of a 32 bit it is:

ORA_NLS33=/oracle/client/92x_32/ocommon/nls/admin/data

[Former Member · Accepted solution]

Yes it was ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

I have 920_64 instead of 92x_64

Thanks!!!

[Former Member · Accepted solution]

Were you able to run brconnect -u / -c -f check when you log in as orad3p ?

Thanks

Prince Jose

[Former Member]

I have to restart the SAP intance and I'll be okay!

[Former Member]

Hello William,

Were you able to get this resolved?

We ran into the same situation at work and we have spent already 1 full day trying to figure out what went wrong.

Our scenario is exactly the same... (SID: Q2S)

1. we upgraded SAP Kernel from 620 --> 640.

2. installed orcl client 92x_64 under /oracle/client/92x_64/ -- (for Sun 9.x)

3. env variable ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

and brconnect doesn't work for oraq2s

Let me know if you have fixed this issue. Thanks.

Sri

[Former Member]

Hi,

does brconnect fail from the command line or only DB13?

what are the environment variables?

is this a DB+CI server? -> Do not install physically the oracle client, use the script CROCLLNK

Regards

Fidel

[Former Member]

This how we got it to work:

On there server I can now get "brconnect -u / -c -f check" to work by adding this env variable:

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

along with the already exsiting:

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

[Former Member]

Fidel,

Thanks for your response.

Here are my responses to your queries:

...- brconnect fails from the command line.

...- env vars:

........ ORA_NLS33=/oracle/Q2S/920_64/ocommon/nls/admin/data

........ NLS_LANG=AMERICAN_AMERICA.WE8DEC

...- this is a CI plus DB server

...- I installed the oracle client (download from marketplace) manually and I did not use CROCLLNK. I installed the orcl client in /oracle/client/92x_64/ocommon/nls/admin/data

We upgraded our SAP kernel from 620 to 640 (patch set 139) a couple of months ago. brconnect and sapdba were working just fine.

Then, we applied the latest kernel patch set (155) couple of days ago, we started seeing issues with brconnect and sapdba for ora<sid> user.

Solution:

We figured out the problem with this issue. Here is what worked out for us. We did not have to muck around with the ORA_NLS33 var at all.

edit these files and fix the LD_LIBRARY_PATH

--> .dbenv_q2s-db.csh

--> .dbenv_q2s-db.sh

LD_LIBRARY_PATH

before:

-

---

> /usr/sap/Q2S/SYS/exe/run

after:

-

---

> /usr/sap/Q2S/SYS/exe/run:/oracle/Q2S/920_64/lib

Here is what my understanding is: once you apply latest kernel patch set, there is a need to add the $ORACLE_HOME/lib to the LD_LIBRARY_PATH var. Looks like the latest SAP kernel (640) patch set (155) has a requirement to access the libs from the $ORACLE_HOME/lib directory. I may be wrong, but this is what has worked for us.

Thanks.

[Former Member]

my mistake, brconnect was working from orad3p

Even after changing ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data in d3padm, brconnect still gets errors.

(R3trans -d stll connects in d3padm)

[Former Member]

It is curious.

Can you tell me the kernel version you are using?

Perhaps your kernel does not uses the OCL 9i and this is not properly installed.

Also, the output of

ls -l /oracle/client/92x_64

ls -l /oracle/client/92x_64/ocommon/nls/admin/

Thanks

[Former Member]

1) kernel Release: 640

2) ls -l /oracle/client/92x_64

total 76872

-rwxrwxrwx 1 202 dba 39277282 Nov 2 10:23 OCL92064.SAR

drwxr-xr-x 5 202 dba 4096 Sep 23 2005 jdbc

drwxr-xr-x 2 202 dba 4096 Sep 23 2005 lib

drwxr-xr-x 3 202 dba 4096 Sep 23 2005 network

drwxr-xr-x 3 202 dba 4096 Sep 23 2005 ocommon

drwxr-xr-x 4 202 dba 4096 Sep 23 2005 oracore

drwxr-xr-x 3 202 dba 4096 Sep 23 2005 rdbms

-rw-rr 1 202 dba 9811 Nov 2 10:33 trans.log

3) ls -l /oracle/client/92x_64/ocommon/nls/admin/

total 88

drwxr-xr-x 2 202 dba 45056 Sep 23 2005 data

[Former Member]

Hi,

Try the following

1) rename /oracle/client/92x_64 to /oracle/client/92x_64.old ( for example )

2) execute the script CROCLLNK

Note 539922 indicate where you can find the script and how to execute it.

The script only creates a softlink from the oracle client directory to the oracle home. That way BR* tools and the kernel will be using the same client as the oracle_home.

This is the recomended method on the database server.

Let me know if it works

[Former Member]

check your environnement and change the variable NLS in your session, if it's OK.

change it in the all files

[Former Member]

On there server I can now get "brconnect -u / -c -f check" to work by adding this env variable:

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

along with the already exsiting:

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

But it still doesn't work from DB13?

Do I have to restart SAP?

[Former Member]

Hello,

Yes, You have to restart SAP in order to read the new shell variables. This variable should be set for the user <sid>adm.

[Former Member]

Hello William,

Unfortunatelly, if you make any changes on the environment variables for the <sid>adm user, they are not "picked" until the sap instance is restarted.

[Former Member]

Hello Gurus,

Did you get any breakthrough in this issue. Because i am also facing the same issue while installling the NW04 with oracle 9.0.2.0 but during "Update Statistice" step of Database instance installation it is giving me below error.

"Unable to find library 'libclntsh.so.10.1"

I already have 3 instance running fine on the same server of ECC 5.0 which i installed with oracle 9 same database.

Please help me if you have any clue about the same my OS is HPUX-11.23.

I dont know why installation is looking for oracle 10 library.

Thanks and Regards

Dheeraj Thareja

[Former Member]

Hi,

Your installation is looking for 'libclntsh.so.10.1' because it is using BRCONNECT 700.

For other messages on the forum, seems that this is delivered now even when the DB installs 9.2.

A quick solution is to install BR* tools 6.40. Another option is to install oracle instantclient 10g

[Former Member]

brconnect 700 was also causing me troubles. Copying DBA Tools 6.40 fixed this problem.

For the record, I was having the same problem with shared libraries, during R3 install with Oracle 9.2:

brconnect: error when loading shared libraries: libclntsh.so.10.1

[former_member204746]

brtools 7.0 do not work with Oracle 9i. that why using brtools 6.40 fixed the problem becasue 6.40 supprot Oarcle 10g.