on 09-16-2008 9:22 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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"
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.