brconnect: "ORA-01017: invalid username/password; ...

Hello,

I have a Problem with our SAP-System on AIX 5.3 TL6 SP7 (64bit)

I have Upgrade from Oracle 9.2.0.7 to Oracle 10.2.0.2, AIX 5.3 ML3 to AIX 5.3 TL6 SP7, DBA-Tools 7.0 (33) + Patches (...., and Patch for AIX TL5 or higher 5496862)

Now i have the Problem that brconnect do not work, for example:

brconnect -c -u / -f stats -t all -f collect

brconnect -u / -c -f check

this worked before, but not now.

Only i set user+password then i works.

brconnect -u system/mypassword -c -f check

Is it possible that there a changes in Oracle + brconnect ?

Or need i a password file or something else from Version 9.2.0.7 ?

saparchive is working for example (backint)

thanks

dennis

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (4)

Hi,

Please change the password for ABAP Schema and then re-start the system.. Then this issue will be resolved..

Do the password reset via brtools..

Regards

Thilip Kumar

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

From Note 113747:

brarchive, brbackup, brconnect, brtools have permission 4775:

-rwsrwxr-x ora is not created in the database. So if you want to start it with that user, try to create it in the database.

Edited by: Martin Goulet on Sep 11, 2008 10:27 PM

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello Martin,

i think so

-rwxrwxr-x 1 orats1 sapsys 5012623 Sep 09 12:01 brarchive

-rwsrwxr-x 1 orats1 sapsys 5139856 Sep 09 12:06 brbackup

-rwsrwxr-x 1 orats1 sapsys 6670666 Sep 09 12:06 brconnect

-rwxrwxr-x 1 ts1adm sapsys 5604458 Sep 09 12:07 brrecover

-rwxrwxr-x 1 ts1adm sapsys 2106255 Sep 09 12:07 brrestore

-rwxrwxr-x 1 orats1 sapsys 6897192 Sep 09 12:06 brspace

-rwsrwxr-x 1 orats1 sapsys 2735316 Sep 09 12:06 brtools

Is your OPS$orasid user created in the database?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

brconnect -u / -c -f check

This will connect using the user OPS$<user>

brconnect -u system/mypassword -c -f check

This obvously connects with the system user.

So your problem is either, you cannot connect with the OPS$-user, or he is not having the permission to logon. Did you apply the sapdba_role.sql already? Just to make sure, check if brconnect has the correct file permissions:


sidadm> ls -l /usr/sap/SID/SYS/exe/run/brconnect
-rwsrwxr-x 1 orasid sapsys 5337376 Feb  6  2008 /usr/sap/SID/SYS/exe/run/brconnect

Regards

Michael

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Michael,

>Did you apply the sapdba_role.sql already?

Oh, no i dont !

>Just to make sure, check if brconnect has the correct file permissions:

ls -la brconnect

-rwsrwxr-x 1 orasap1 sapsys 6670666 Sep 09 12:06 brconnect

Hi Martin,

>Is your OPS$orasid user created in the database?

Yes it is

SQL> select * FROM DBA_USERS WHERE USERNAME = 'OPS$SAP1ADM';

USERNAME USER_ID PASSWORD

ACCOUNT_STATUS LOCK_DATE EXPIRY_DA

DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED

PROFILE INITIAL_RSRC_CONSUMER_GROUP

EXTERNAL_NAME

OPS$SAP1ADM 61 EXTERNAL

OPEN

PSAPUSER1D PSAPTEMP 30-JUN-08

USERNAME USER_ID PASSWORD

ACCOUNT_STATUS LOCK_DATE EXPIRY_DA

DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED

PROFILE INITIAL_RSRC_CONSUMER_GROUP

EXTERNAL_NAME

DEFAULT DEFAULT_CONSUMER_GROUP

After i do:

SAPCAR -xvf sapdba_role_ora10.SAR

sqlplus /nolog @sapdba_role SAP1

BR0801I BRCONNECT 7.00 (33)

BR0805I Start of BRCONNECT processing: cdytzcct.sta 2008-09-10 07.15.19

BR0484I BRCONNECT log file: /oracle/SAP1/sapcheck/cdytzcct.sta

BR0280I BRCONNECT time stamp: 2008-09-10 07.15.19

BR0301E SQL error -1017 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance SAP1 failed

BR0280I BRCONNECT time stamp: 2008-09-10 07.15.19

BR0301E SQL error -1017 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance SB1 failed

BR0806I End of BRCONNECT processing: cdytzcct.sta 2008-09-10 07.15.19

BR0280I BRCONNECT time stamp: 2008-09-10 07.15.19

BR0804I BRCONNECT terminated with errors

sapdba_role.log

Grant succeeded.

old 1: grant ALL on &User..DBAGRP to sapdba

new 1: grant ALL on SAPR3.DBAGRP to sapdba

Grant succeeded.

old 1: grant ALL on &User..DBAERR to sapdba

new 1: grant ALL on SAPR3.DBAERR to sapdba

Grant succeeded.

old 1: grant ALL on &User..DBATRIAL to sapdba

new 1: grant ALL on SAPR3.DBATRIAL to sapdba

Grant succeeded.

old 1: grant ALL on &User..DBSTATC to sapdba

new 1: grant ALL on SAPR3.DBSTATC to sapdba

Grant succeeded.

old 1: grant ALL on &User..DBSTATTORA to sapdba

new 1: grant ALL on SAPR3.DBSTATTORA to sapdba

Grant succeeded.

old 1: grant ALL on &User..DBSTATIORA to sapdba

new 1: grant ALL on SAPR3.DBSTATIORA to sapdba

Grant succeeded.

old 1: grant ALL on &User..DBSTATHORA to sapdba

new 1: grant ALL on SAPR3.DBSTATHORA to sapdba

Grant succeeded.

old 1: grant ALL on &User..DBSTAIHORA to sapdba

new 1: grant ALL on SAPR3.DBSTAIHORA to sapdba

Grant succeeded.

old 1: grant ALL on &User..DBMSGORA to sapdba

new 1: grant ALL on SAPR3.DBMSGORA to sapdba

Grant succeeded.

old 1: grant ALL on &User..DBCHECKORA to sapdba

new 1: grant ALL on SAPR3.DBCHECKORA to sapdba

Grant succeeded.

old 1: grant ALL on &User..MLICHECK to sapdba

new 1: grant ALL on SAPR3.MLICHECK to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.TGORA to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.IGORA to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.TSORA to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.TAORA to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.IAORA to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.SVERS to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.DD02L to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.DD09L to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.DDNTT to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.DDART to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.DARTT to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.DBCHK to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.DBDIFF to sapdba

Grant succeeded.

old 12: Statement := 'grant ALL on &User..SAPLIKEY to sapdba';

new 12: Statement := 'grant ALL on SAPR3.SAPLIKEY to sapdba';

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

new 21: Statement := 'grant SELECT on SAPR3.RSNSPACE to sapdba';

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

new 30: Statement := 'grant SELECT on SAPR3.RSPSPACE to sapdba';

PL/SQL procedure successfully completed.

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

new 1: grant SELECT on SAPR3.DARTT to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.DBCHK to sapdba

Grant succeeded.

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

new 1: grant SELECT on SAPR3.DBDIFF to sapdba

Grant succeeded.

old 12: Statement := 'grant ALL on &User..SAPLIKEY to sapdba';

new 12: Statement := 'grant ALL on SAPR3.SAPLIKEY to sapdba';

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

new 21: Statement := 'grant SELECT on SAPR3.RSNSPACE to sapdba';

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

new 30: Statement := 'grant SELECT on SAPR3.RSPSPACE to sapdba';

PL/SQL procedure successfully completed.

A scheduled Job: UpdateStatistics, has this Joblog

Parameter: -u / -jid STATS20080910050000 -c -f stats -t ALL

exec(): 0509-036 Cannot load program brconnect because of the following errors:

#0509-150 Dependent module libclntsh.a(shr.o) could not be loaded.

#0509-022 Cannot load module libclntsh.a(shr.o).

#0509-026 System error: A file or directory in the path name does not exist.

External program terminated with exit code 255

BRCONNECT returned error status E

Edited by: Dennis Schneck on Sep 10, 2008 7:46 AM

Hi Denis,

I'm a little confused.

I thought the <SAPSID> or <DBSID> in a SAP environment had only 3 letters.

But in your case it has 4 -> SAP1

-rwsrwxr-x 1 orasap1 sapsys 6670666 Sep 09 12:06 brconnect

SQL> select * FROM DBA_USERS WHERE USERNAME = 'OPS$SAP1ADM';

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance SAP1 failed

i have to say that it is very curious.

Also, the latest error indicate that the oracle client is not properly installed and/or environment variables issues.

could you

1-> tell us the exact name of the user that is executing the BRCONNECT

2-> tell us the exact <SAPSID> or <DBSID>

3 -> provide environment variables

Hi Fidel,

>I'm a little confused.

Such was not my intention.

the SID is TS1

-rwsrwxr-x 1 orats1 sapsys 6670666 Sep 09 12:06 brconnect

select * FROM DBA_USERS WHERE USERNAME = 'OPS$TS1ADM';

SQL> select * FROM DBA_USERS WHERE USERNAME = 'OPS$TS1ADM';

USERNAME USER_ID PASSWORD

ACCOUNT_STATUS LOCK_DATE EXPIRY_DA

DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED

PROFILE INITIAL_RSRC_CONSUMER_GROUP

EXTERNAL_NAME

OPS$TS1ADM 61 EXTERNAL

OPEN

PSAPUSER1D PSAPTEMP 30-JUN-08

USERNAME USER_ID PASSWORD

ACCOUNT_STATUS LOCK_DATE EXPIRY_DA

DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED

PROFILE INITIAL_RSRC_CONSUMER_GROUP

EXTERNAL_NAME

DEFAULT DEFAULT_CONSUMER_GROUP

>1-> tell us the exact name of the user that is executing the BRCONNECT

orats1

2-> tell us the exact <SAPSID> or <DBSID>

ts1

3 -> provide environment variables

from user: orats1

oraTS1> env

_=/bin/env

ESCDELAY=5000

LANG=en_US

THREAD=NOPS

STAGING_AREA=/oracle/stage/1020_64

ORACLE_PSRV=TS1

PATH=/oracle/TS1/1020_64/bin:/usr/sap/TS1/SYS/exe/run:/bin:/usr/bin:/usr/sbin:/usr/bin/X11:/usr/ucb:/usr/ccs/bin:/usr/local/bin:/etc:.

SAPBACKUP=/oracle/TS1/sapbackup

NLS_LANG=AMERICAN_AMERICA.US7ASCII

ORACLE_BASE=/oracle

LC__FASTMSG=true

TLS=/hnteu1/tls

EDITOR=vi

HISTFILE=/oracle/TS1/.sh_history

LOGNAME=oraTS1

SAPTRACE=/oracle/TS1/saptrace

MAIL=/usr/spool/mail/oraTS1

ORACLE_SID=TS1

LOCPATH=/usr/lib/nls/loc

oraTS1>

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

USER=oraTS1

DSM_LOG=/usr/tivoli/tsm/client/ba/log

SHR=/hntmnt/share

AUTHSTATE=files

LANGUAGE=American_America.US7ASCII

TNS_ADMIN=/usr/sap/trans

ORA_NLS10=/oracle/TS1/1020_64/nls/data

CC=/oracle/TS1/1020_64/bin/oraxlc

DISPLAY=192.168.1.11:0.0

SHELL=/usr/bin/ksh

ODMDIR=/etc/objrepos

SAPDATA_HOME=/oracle/TS1

HOME=/oracle/TS1

SAPARCH=/oracle/TS1/saparch

cc=/oracle/TS1/1020_64/bin/oraxlc

ADSM=/usr/tivoli/tsm/client/ba

FCEDIT=vi

TERM=xterm

MAILMSG=[YOU HAVE NEW MAIL]

DSM_DIR=/usr/tivoli/tsm/client/ba/bin

ORACLE_HOME=/oracle/TS1/1020_64

PWD=/oracle/TS1

TZ=NFT-1DFT,M3.5.0,M10.5.0

dbms_type=ORA

ENV=/oracle/TS1/.kshrc

SAPREORG=/oracle/TS1/sapreorg

AIXTHREAD_SCOPE=S

SAPSYSTEMNAME=TS1

LIBRARY_PATH=/oracle/TS1/1020_64

A__z=! LOGNAME

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

LIBPATH=/oracle/TS1/1020_64/lib:/oracle/TS1/1020_64/lib32:/oracle/client/92x_64/lib:

from user ts1adm

TS1adm> env

_=/usr/bin/env

ESCDELAY=5000

LANG=en_US

THREAD=NOPS

ORACLE_PSRV=TS1

PATH=/oracle/TS1/1020_64/bin:.:/home/TS1adm:/usr/sap/TS1/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin

NLS_LANG=AMERICAN_AMERICA.WE8DEC

ORACLE_BASE=/oracle

LC__FASTMSG=true

TLS=/hnteu1/tls

EDITOR=vi

HISTFILE=/home/TS1adm/.sh_history_dev_pts_3

LOGNAME=TS1adm

RFCEXEC_SEC_FILE_PATH=/sapmnt/TS1/exe

MAIL=/usr/spool/mail/TS1adm

dbs_ora_tnsname=TS1

ORACLE_SID=TS1

LOCPATH=/usr/lib/nls/loc

TS1adm>

DB_SID=TS1

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

USER=TS1adm

DSM_LOG=/usr/tivoli/tsm/client/ba/log

SHR=/hntmnt/share

AUTHSTATE=files

TNS_ADMIN=/usr/sap/trans

DISPLAY=192.168.1.11:0.0

dbs_ora_schema=SAPR3

SHELL=/usr/bin/ksh

ODMDIR=/etc/objrepos

SECUDIR=/usr/sap/TS1/DVEBMGS00/sec

HISTSIZE=200

SAPDATA_HOME=/oracle/TS1

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

HOME=/home/TS1adm

ADSM=/usr/tivoli/tsm/client/ba

FCEDIT=vi

TERM=xterm

MAILMSG=[YOU HAVE NEW MAIL]

DSM_DIR=/usr/tivoli/tsm/client/ba/bin

ORACLE_HOME=/oracle/TS1/1020_64

PWD=/home/TS1adm

TZ=NFT-1DFT,M3.5.0,M10.5.0

dbms_type=ora

ENV=/home/TS1adm/.kshrc

SAPSYSTEMNAME=TS1

MAILCHECK=60

A__z=! LOGNAME="*MAILCHECK

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

LIBPATH=/usr/lib:/lib:/usr/sap/TS1/SYS/exe/run

Edited by: dennis schneck on Sep 11, 2008 7:41 AM

Hi,

Thank you for the information.

Now it makes a little sense

OK, the last error is clear, lets see if you realize:

> select * FROM DBA_USERS WHERE USERNAME = 'OPS$TS1ADM';

> 1-> tell us the exact name of the user that is executing the BRCONNECT

> orats1

little teasing so you thing what is wrong here

OK, you are showing us that the OPS$ user for the TS1ADM user is created. But you are telling us that you are trying to execute BRCONNECT with the user ORATS1.

1) BRCONNECT is not supposed to be executed by ORA<SID>

2) for the previous reason, by default there is no OPS$ user created for ORA<SID>

3) I assume that you do not have created the OPS$ORATS1, if this is true then the following will always fail:

> brconnect -u / <any option>

if i run "brconnect -u / -c -f check" as user ts1adm

i get this error

ts1adm> brconnect -u / -c -f check

exec(): 0509-036 Cannot load program brconnect because of the following errors:

0509-150 Dependent module libclntsh.a(shr.o) could not be loaded.

0509-022 Cannot load module libclntsh.a(shr.o).

0509-026 System error: A file or directory in the path name does not exist.


> if i run "brconnect -u / -c -f check" as user ts1adm
> 
> i get this error
> 
> ts1adm> brconnect -u / -c -f check
> exec(): 0509-036 Cannot load program brconnect because of the following errors:
>         0509-150   Dependent module libclntsh.a(shr.o) could not be loaded.
>         0509-022 Cannot load module libclntsh.a(shr.o).
>         0509-026 System error: A file or directory in the path name does not exist.

I forgot about that.

The issue is that BRCONNECT cannot find the oracle library.

Environment variables are not correct.

Do not set:

> ORA_NLS10=/oracle/TS1/1020_64/nls/data

this is wrong:

> LIBPATH= /oracle/TS1/1020_64/lib:/oracle/TS1/1020_64/lib32:/oracle/client/92x_64/lib:

SAP does not like much this shell, you should use csh

>SHELL=/usr/bin/ksh

take a look at the note 819829 Oracle Database 10g: Instant Client 10.x on Unix

Note that

> NLS_LANG=AMERICAN_AMERICA.US7ASCII

is not supported in Oracle 10g. You will have to change the characterset.

see note 819830 Oracle Database 10g: Additional Information on upgrade:UNIX

Hi Fidel,

is this ENV now correct ?

oraTS1> env

_=/bin/env

ESCDELAY=5000

LANG=en_US

THREAD=NOPS

STAGING_AREA=/oracle/stage/1020_64

ORACLE_PSRV=TS1

PATH=/oracle/TS1/1020_64/bin:/usr/sap/TS1/SYS/exe/run:/bin:/usr/bin:/usr/sbin:/usr/bin/X11:/usr/ucb:/usr/ccs/bin:/usr/local/bin:/etc:.

SAPBACKUP=/oracle/TS1/sapbackup

NLS_LANG=AMERICAN_AMERICA.WE8DEC

ORACLE_BASE=/oracle

LC__FASTMSG=true

TLS=/hnteu1/tls

EDITOR=vi

HISTFILE=/oracle/TS1/.sh_history

LOGNAME=oraTS1

SAPTRACE=/oracle/TS1/saptrace

MAIL=/usr/spool/mail/oraTS1

ORACLE_SID=TS1

LOCPATH=/usr/lib/nls/loc

oraTS1>

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

USER=oraTS1

DSM_LOG=/usr/tivoli/tsm/client/ba/log

SHR=/hntmnt/share

AUTHSTATE=files

LANGUAGE=American_America.US7ASCII

TNS_ADMIN=/usr/sap/trans

CC=/oracle/TS1/1020_64/bin/oraxlc

DISPLAY=10.1.0.104:0.0

SHELL=/usr/bin/ksh

ODMDIR=/etc/objrepos

SAPDATA_HOME=/oracle/TS1

HOME=/oracle/TS1

SAPARCH=/oracle/TS1/saparch

cc=/oracle/TS1/1020_64/bin/oraxlc

ADSM=/usr/tivoli/tsm/client/ba

FCEDIT=vi

TERM=xterm

MAILMSG=[YOU HAVE NEW MAIL]

DSM_DIR=/usr/tivoli/tsm/client/ba/bin

ORACLE_HOME=/oracle/TS1/1020_64

PWD=/oracle/TS1

TZ=NFT-1DFT,M3.5.0,M10.5.0

dbms_type=ORA

ENV=/oracle/TS1/.kshrc

SAPREORG=/oracle/TS1/sapreorg

AIXTHREAD_SCOPE=S

SAPSYSTEMNAME=TS1

LIBRARY_PATH=/oracle/TS1/1020_64

A__z=! LOGNAME

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

LIBPATH=/usr/lib:/lib:/usr/sap/TS1/SYS/exe/run:/oracle/TS1/1020_64/lib

TS1adm> env

_=/usr/bin/env

ESCDELAY=5000

LANG=en_US

THREAD=NOPS

ORACLE_PSRV=TS1

PATH=/oracle/TS1/1020_64/bin:.:/home/TS1adm:/usr/sap/TS1/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin

NLS_LANG=AMERICAN_AMERICA.WE8DEC

ORACLE_BASE=/oracle

LC__FASTMSG=true

TLS=/hnteu1/tls

EDITOR=vi

HISTFILE=/home/TS1adm/.sh_history_dev_pts_3

LOGNAME=TS1adm

RFCEXEC_SEC_FILE_PATH=/sapmnt/TS1/exe

MAIL=/usr/spool/mail/TS1adm

dbs_ora_tnsname=TS1

ORACLE_SID=TS1

LOCPATH=/usr/lib/nls/loc

TS1adm>

DB_SID=TS1

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

USER=TS1adm

DSM_LOG=/usr/tivoli/tsm/client/ba/log

SHR=/hntmnt/share

AUTHSTATE=files

TNS_ADMIN=/usr/sap/trans

dbs_ora_schema=SAPR3

SHELL=/usr/bin/ksh

ODMDIR=/etc/objrepos

SECUDIR=/usr/sap/TS1/DVEBMGS00/sec

HISTSIZE=200

SAPDATA_HOME=/oracle/TS1

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

HOME=/home/TS1adm

ADSM=/usr/tivoli/tsm/client/ba

FCEDIT=vi

TERM=xterm

MAILMSG=[YOU HAVE NEW MAIL]

DSM_DIR=/usr/tivoli/tsm/client/ba/bin

ORACLE_HOME=/oracle/TS1/1020_64

PWD=/home/TS1adm

TZ=NFT-1DFT,M3.5.0,M10.5.0

dbms_type=ora

ENV=/home/TS1adm/.kshrc

SAPSYSTEMNAME=TS1

MAILCHECK=60

A__z=! LOGNAME="*MAILCHECK

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

LIBPATH=/usr/lib:/lib:/usr/sap/TS1/SYS/exe/run

Edited by: dennis schneck on Sep 11, 2008 10:28 AM

Hi,

you changed NLS_LANG.

But what is the correct setting in your database. If in your database the characterset still is AMERICAN_AMERICA.US7ASCII, then the change of environment variable will achieve nothing.

In TS1adm you have defined ORA_NLS33, I assume that your kernel is 6.40 or 46D_EXT as both need the oracle 9i client.

For that reason SAP works and BRCONNECT fails as it needs the oracle 10g

Your LIBPATH is not correct.

You will continue having problems with BRCONNECT as it will not be able to find the 10g oracle client.

Please, review the note I mentioned.

Set the environment variables as it is mentioned on the note.

Install the instantclient if needed.

>you changed NLS_LANG.

>But what is the correct setting in your database. If in your database the characterset still is >AMERICAN_AMERICA.US7ASCII, then the change of environment variable will achieve nothing.

i have set this with:

SQL> startup mount

SQL> alter system enable restricted session;

SQL> alter system set JOB_QUEUE_PROCESSES=0;

SQL> alter database open;

SQL> alter database character set WE8DEC;

>In TS1adm you have defined ORA_NLS33, I assume that your kernel is 6.40 as both need the oracle 9i client.

Kernel 6.40 Patch 240

>Your LIBPATH is not correct.

>You will continue having problems with BRCONNECT as it will not be able to find the 10g oracle client.

LIBPATH=/usr/lib:/lib:/usr/sap/SB1/SYS/exe/run:/oracle/client/92x_64/lib

is this correct ?

SAP note[819829|https://websmp130.sap-ag.de/sap(bD1lcyZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=819829] says:


Library Search Path:
The library search path defines the order in which directories are search for shared libraries. The name of the environment variable that defines the library search path is platform dependent (see also SAP note 830578):
- LD_LIBRARY_PATH (LINUX, SOLARIS, HP-UX)
- SHLIB_PATH      (HP-UX)
- LIBPATH         (AIX5L)
...
6. In case some of the files are reported as not found then please check the value for library search path environment variable for the <sid>adm user. The env. variable be set as:
LD_LIBRARY_PATH=/usr/sap/SID/SYS/exe/run:/oracle/client/10x_64/instantclient.
7. In general, you have to make sure that LD_LIBRARY_PATH does not contain a directory of another ORACLE_HOME (server or client) or of another instant client of another release in a position before /oracle/client/10x_64/instantclient. This could lead to unforseeable behaviour.

Then your LIBPATH setting is not correct.

Ask a Question

Top Q&A Solution Author

User

Count