cancel
Showing results for 
Search instead for 
Did you mean: 

DBIF_SETG_SQL_ERROR - after Upgrade to 10.2.0.2

Former Member
0 Kudos

After Upgrade from Oracle 9.2.0.7 to Oracle 10.2.0.2

i have the Problem that the User: <SID>adm cannot use brtools for example brsapce to extend a tablespace

exec(): 0509-036 Cannot load program /usr/sap/NT1/SYS/exe/run/brspace 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.

System: AIX 5.3 TL6 SP7 (5300-06-07-0818)

Database: Oracle 10.2.0.2

SAP: Enterprise Kernel 6.40 Patch 240

DB Client Lib: OCI_920

DB Releases: ORACLE 9.2.0.., ORACLE 10.1.0.., ORACLE 10.2.0..

DBSL Version: 640.00

DBSL Patch Level: 220

SAP_BASIS 620 0064 SAPKB62064

Brtools 7.00 (33) from: DBATL700O10_33-20000979.SAR

On the SAP-System i can see in Transaction: st22: DBIF_SETG_SQL_ERROR, DBIF_RSQL_ERROR, DBIF_NTAB_SQL_ERROR

but if i use the user ora<SID> brtools work for extend tablespace

here are the ENV of the both users:

st1adm

st1adm> env

_=/usr/bin/env

ESCDELAY=5000

LANG=en_US

THREAD=NOPS

LOGIN=st1adm

ORACLE_PSRV=st1

PATH=/oracle/st1/1020_64/bin:.:/home/st1adm:/usr/sap/st1/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=/hntsp1/tls

EDITOR=vi

HISTFILE=/home/st1adm/.sh_history

LOGNAME=st1adm

RFCEXEC_SEC_FILE_PATH=/sapmnt/st1/exe

MAIL=/usr/spool/mail/st1adm

dbs_ora_tnsname=st1

ORACLE_SID=st1

LOCPATH=/usr/lib/nls/loc

st1adm>

DB_SID=st1

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

USER=st1adm

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

SHR=/hntmnt/share

AUTHSTATE=files

DBS_LIBPATH_EXT=/oracle/client/instantclient_10202_V2

TNS_ADMIN=/usr/sap/trans

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

DISPLAY=10.1.1.244:0.0

dbs_ora_schema=SAPR3

SHELL=/bin/ksh

ODMDIR=/etc/objrepos

SECUDIR=/usr/sap/st1/DVEBMGS00/sec

HISTSIZE=200

SAPDATA_HOME=/oracle/st1

HOME=/home/st1adm

NSORDER=local,bind

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/st1/1020_64

PWD=/sapmnt/st1/exe

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

dbms_type=ora

ENV=/home/st1adm/.kshrc

SAPSYSTEMNAME=st1

LIBRARY_PATH=/oracle/st1/1020_64

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/st1/SYS/exe/run:/oracle/st1/1020_64/lib32:/oracle/client/instantclient_10202_V2

orast1

oraST1> env

_=/bin/env

ESCDELAY=5000

LANG=en_US

THREAD=NOPS

LOGIN=oraST1

STAGING_AREA=/oracle/stage/1020_64

ORACLE_PSRV=ST1

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

SAPBACKUP=/oracle/ST1/sapbackup

NLS_LANG=AMERICAN_AMERICA.US7ASCII

ORACLE_BASE=/oracle

LC__FASTMSG=true

TLS=/hntsp1/tls

EDITOR=vi

HISTFILE=/oracle/ST1/.sh_history

LOGNAME=oraST1

SAPTRACE=/oracle/ST1/saptrace

MAIL=/usr/spool/mail/oraST1

ORACLE_SID=ST1

LOCPATH=/usr/lib/nls/loc

oraST1>

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

USER=oraST1

DSM_LOG=/usr/lpp/adsm/log

SHR=/hntmnt/share

AUTHSTATE=files

LANGUAGE=American_America.US7ASCII

TNS_ADMIN=/usr/sap/trans

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

DISPLAY=10.1.1.244:0.0

SHELL=/bin/ksh

ODMDIR=/etc/objrepos

HISTSIZE=200

SAPDATA_HOME=/oracle/ST1

HOME=/oracle/ST1

SAPARCH=/oracle/ST1/saparch

NSORDER=local,bind

cc=/oracle/ST1/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/ST1/1020_64

PWD=/oracle/ST1

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

dbms_type=ORA

ENV=/oracle/ST1/.kshrc

SAPREORG=/oracle/ST1/sapreorg

AIXTHREAD_SCOPE=S

SAPSYSTEMNAME=ST1

LIBRARY_PATH=/oracle/ST1/1020_64

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/ST1/SYS/exe/run:/oracle/ST1/1020_64/lib

the following oracle patches are installed:

Interim patches (18) :

Patch 5496862 : applied on Mon Sep 15 11:03:24 CEST 2008

Created on 25 Oct 2006, 12:12:14 hrs PST8PDT

Bugs fixed:

5496862

Patch 7021805 : applied on Mon Sep 15 10:54:55 CEST 2008

Created on 13 May 2008, 09:48:14 hrs PST8PDT

Bugs fixed:

6151963, 5245494, 6321245, 6488148, 6077514, 6007259, 6159522, 4904838

4708389, 5763245, 5984705, 5380055, 5882954, 6350462, 4878299, 6239971

4698023, 6370247, 6167221, 4722645, 5705257, 5838613, 6147372, 6618120

5762598, 5043097, 5397482, 6082745, 5949981, 5033476, 5690241, 5547058

5126551, 5089444, 6011182, 5966822, 5997892, 6134565, 5884780, 6051211

5944076, 4724074, 4712638, 6070954, 4483240, 5449488, 6251917, 5483301

6120483, 5718007, 5381446, 7021805, 5057695, 6740811, 5548510, 5680702

5741121, 4273361, 5766310, 4372359, 5705630, 3901785, 6626018, 5131645

4567767, 6660162, 5399282, 5724540, 5113934, 6087237, 5990716, 5649765

6062266, 4648181, 6316993, 5129407, 6819865, 5172444, 5084239, 5976822, 5694984

Patch 6826661 : applied on Mon Sep 15 10:54:24 CEST 2008

Created on 22 Feb 2008, 11:02:29 hrs PST8PDT

Bugs fixed:

6826661

Patch 5895190 : applied on Mon Sep 15 10:53:49 CEST 2008

Created on 24 Apr 2008, 05:19:12 hrs PST8PDT

Bugs fixed:

5895190

Patch 6455161 : applied on Mon Sep 15 10:53:24 CEST 2008

Created on 10 Apr 2008, 06:04:09 hrs PST8PDT

Bugs fixed:

6455161

Patch 6819785 : applied on Mon Sep 15 10:53:00 CEST 2008

Created on 29 Feb 2008, 08:05:22 hrs PST8PDT

Bugs fixed:

4430244, 5752105, 6140309, 5558627, 5747462, 5376783, 5212539, 6455795

5913430, 5386204, 5093837, 5667736, 6033289, 5245129, 5959612, 6819785

4771672, 6086497, 5728380, 5657620

Patch 4704890 : applied on Mon Sep 15 10:52:31 CEST 2008

Created on 9 May 2006, 02:00:28 hrs US/Pacific

Bugs fixed:

4704890

Patch 6663258 : applied on Mon Sep 15 10:52:06 CEST 2008

Created on 3 Dec 2007, 06:54:28 hrs PST8PDT

Bugs fixed:

6151380, 6663258, 5571916

Patch 6729801 : applied on Mon Sep 15 10:51:40 CEST 2008

Created on 7 Jan 2008, 01:27:13 hrs PST8PDT

Bugs fixed:

4883174, 6398635, 4522561, 5391568, 6406234, 5573544, 4670363, 6729801

5181800, 4877360, 5399901

Patch 6005996 : applied on Mon Sep 15 10:51:15 CEST 2008

Created on 18 Sep 2007, 22:48:13 hrs PST8PDT

Bugs fixed:

6005996

Patch 5188321 : applied on Mon Sep 15 10:50:57 CEST 2008

Created on 6 Dec 2007, 21:47:38 hrs PST8PDT

Bugs fixed:

5188321

Patch 6447320 : applied on Mon Sep 15 10:50:32 CEST 2008

Created on 30 Nov 2007, 13:51:21 hrs PST8PDT

Bugs fixed:

6447320

Patch 6435823 : applied on Mon Sep 15 10:50:07 CEST 2008

Created on 18 Oct 2007, 02:54:54 hrs PST8PDT

Bugs fixed:

6084512, 5258887, 5029334, 6435823

Patch 5737613 : applied on Mon Sep 15 10:49:54 CEST 2008

Created on 11 Nov 2007, 21:37:01 hrs PST8PDT

Bugs fixed:

5458753, 5377099, 5737613

Patch 6340979 : applied on Mon Sep 15 10:49:29 CEST 2008

Created on 3 Sep 2007, 06:22:47 hrs PST8PDT

Bugs fixed:

4599763, 6053541, 5842686, 4772145, 5915774, 6340979, 5284303, 5709414

Patch 5308692 : applied on Mon Sep 15 10:49:04 CEST 2008

Created on 4 Sep 2007, 03:30:37 hrs PST8PDT

Bugs fixed:

5308692

Patch 5941030 : applied on Mon Sep 15 10:48:40 CEST 2008

Created on 20 Aug 2007, 11:09:46 hrs PST8PDT

Bugs fixed:

5941030

Patch 6153847 : applied on Mon Sep 15 10:48:16 CEST 2008

Created on 28 Jun 2007, 03:25:28 hrs PST8PDT

Bugs fixed:

6153847

/sapmnt/ST1/exe

-rwsrwxr-x 1 orast1 sapsys 5012623 Sep 15 11:10 brarchive

-rwsrwxr-x 1 orast1 sapsys 5139856 Sep 15 11:10 brbackup

-rwsrwxr-x 1 orast1 sapsys 6670666 Sep 15 11:10 brconnect

-rwxrwxr-x 1 st1adm sapsys 5604458 Sep 15 11:14 brrecover

-rwxrwxr-x 1 st1adm sapsys 2106255 Sep 15 11:14 brrestore

-rwxrwxr-x 1 st1adm sapsys 6897192 Sep 15 11:14 brspace

-rwsrwxr-x 1 orast1 sapsys 2735316 Sep 15 11:11 brtools

/oracle/ST1/1020_64/lib/libclntsh.a

-rw-rr 1 orast1 dba 24063166 Sep 15 11:03 /oracle/ST1/1020_64/lib/libclntsh.a

/oracle/ST1/1020_64/lib32/libclntsh.a

-rw-rr 1 orast1 dba 21870834 Sep 15 11:03 /oracle/ST1/1020_64/lib32/libclntsh.a

/oracle/client/instantclient_10202_V2/libclntsh.a

-rw-rr 1 orast1 dba 24062990 Mar 18 2008 /oracle/client/instantclient_10202_V2/libclntsh.a

Where is my mistake in the ENV of the User: <sid>adm / st1adm ?

thanks

dennis

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Dennis,

You also need to upgrade the Oracle client to 10g.. Please download the Oracle 10g client https://service.sap.com/swdc>Database Patches>Oracle

Also refer notes 819829 and 180430..

Regards

Thilip Kumar

Edited by: Thilip Kumar on Sep 16, 2008 4:48 PM

Former Member
0 Kudos

the solution was:

install the 6.40 EX2 kernel

dw_250-10004674.sar

lib_dbsl_220-10004670.sar

SAPEXE_247-10004674.SAR

SAPEXEDB_247-10004670.SAR

former_member204746
Active Contributor
0 Kudos

solution was to apply lib_dbsl_220-10004670.sar

this is the file you needed.

Former Member
0 Kudos

hi eric,

i dont thnik so, the lib_dbsl_220 i had installied before.

the proble is that the kernel 6.40 EX2 works with oracle 10.2 and my used 6.40 not - i think

0 Kudos

Hi,

It is already solved, so it does not matter much.

But, looking at the first post:

  • environment variables does not seem correct for a kernel 6.40 using client 9i. Same can be said about brtools 700 with client 10g:

> DBS_LIBPATH_EXT=/oracle/client/instantclient_10202_V2

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

> LIBRARY_PATH=/oracle/st1/1020_64

> LIBPATH=/usr/lib:/lib:/usr/sap/st1/SYS/exe/run:/oracle/st1/1020_64/lib32:/oracle/client/instantclient_10202_V2

I think this is a bit "messy"