#shutdown -F
Updating brtools - Guide
Referência
Download
Depending on the system
configuration, the following table describes the path to the BR*Tools program
package:
Operating system Oracle Version SAP Kernel Access Path
--------------------------------------------------------------------
LINUX 32-bit 10g 32-bit 32-bit 1
WINDOWS 32-bit 10g 32-bit 32-bit 1
WINDOWS 64-bit 10g 64-bit 64-bit 2
UNIX 64-bit 10g 64-bit 64-bit 2
--------------------------------------------------------------------
Important: The 32-bit versions of BR*Tools are available only with SAP Kernel 7.20.
Access Path 1:
Main path as starting point (see point [2]):
--> SAP KERNEL 32-BIT [UNICODE]
--> SAP KERNEL 7.20 32-BIT [UNICODE]
--> Linux on IA32 32bit | Windows Server on IA32 32bit
--> ORACLE
--> DBATL720O10_nn
Access Path 2:
Main path as starting point (see point [2]):
--> SAP KERNEL 64-BIT [UNICODE]
--> SAP KERNEL 7.20/7.20_EXT/7.40 64-BIT [UNICODE]
--> Support Package Patches <-- for 7.40 only
--> AIX 64bit | HP-UX on IA64 64bit | Linux on x86_64 64bit ...
--> ORACLE
--> DBATL720O10_nn / DBATL740O11_nn
Operating system Oracle Version SAP Kernel Access Path
--------------------------------------------------------------------
LINUX 32-bit 10g 32-bit 32-bit 1
WINDOWS 32-bit 10g 32-bit 32-bit 1
WINDOWS 64-bit 10g 64-bit 64-bit 2
UNIX 64-bit 10g 64-bit 64-bit 2
--------------------------------------------------------------------
Important: The 32-bit versions of BR*Tools are available only with SAP Kernel 7.20.
Access Path 1:
Main path as starting point (see point [2]):
--> SAP KERNEL 32-BIT [UNICODE]
--> SAP KERNEL 7.20 32-BIT [UNICODE]
--> Linux on IA32 32bit | Windows Server on IA32 32bit
--> ORACLE
--> DBATL720O10_nn
Access Path 2:
Main path as starting point (see point [2]):
--> SAP KERNEL 64-BIT [UNICODE]
--> SAP KERNEL 7.20/7.20_EXT/7.40 64-BIT [UNICODE]
--> Support Package Patches <-- for 7.40 only
--> AIX 64bit | HP-UX on IA64 64bit | Linux on x86_64 64bit ...
--> ORACLE
--> DBATL720O10_nn / DBATL740O11_nn
Instalação
- Verifique a versão da brtools
maq01:oramaq 27> brtools -V
BR0651I BRTOOLS 7.20 (1)
Patch
Date Info
1 2010-01-26 BR*Tools support for Oracle 11g (note
1430669)
release note 1428529
kernel release 720
patch date 2010-01-26
patch level 1
make platform rs6000_64
make mode OCI_102
make date Mar 6 2010
- Após o download do arquivo, envie-o via FTP.
- Ajuste as permissões e dono como abaixo.
maq01@root:/tmp:>chmod
777 brtools
maq01@root:/tmp:>chmod
-R 777 brtools
maq01@root:/tmp:>chown
-R maqadm:sapsys brtools
maq01@root:/tmp:>su - maqadm
maqadm> cd /tmp/brtools
maqadm> ls -l
total 51720
-rwxrwxrwx 1 maqadm
sapsys 26480541 Nov 14 09:11
DBATL720O10_34-20005193.SAR
-
Descompacte o arquivo com o SAPCAR.
maqadm>
SAPCAR -xvf DBATL720O10_34-20005193.SAR
SAPCAR:
processing archive DBATL720O10_34-20005193.SAR (version 2.01)
x brarchive
x brbackup
x brconnect
x brrecover
x brrestore
x brspace
x brtools
x dbatoolsora.lst
x dbatoolsora.mf
x initSID.sap
x libsbt.o
x sapconn_role.sql
x sapdba_role.sql
x sapuprof_profile.sql
x SIGNATURE.SMF
SAPCAR: 15 file(s) extracted
maqadm> ls -l
total 199232
-rwxrwxrwx 1 maqadm
sapsys 26480541 Nov 14 09:11
DBATL720O10_34-20005193.SAR
-rw------- 1 maqadm
sapsys 5919 Sep 09 05:16
SIGNATURE.SMF
-rwxr-xr-x 1 maqadm
sapsys 11259483 Sep 07 02:37
brarchive
-rwxr-xr-x 1 maqadm
sapsys 11443336 Sep 07 02:38
brbackup
-rwxr-xr-x 1 maqadm
sapsys 13680646 Sep 07 02:42
brconnect
-rwxr-xr-x 1 maqadm
sapsys 12081206 Sep 07 02:43
brrecover
-rwxr-xr-x 1 maqadm
sapsys 4768980 Sep 07 02:44
brrestore
-rwxr-xr-x 1 maqadm
sapsys 14285817 Sep 07 02:46
brspace
-rwxr-xr-x 1 maqadm
sapsys 5572286 Sep 07 02:46
brtools
-rw-r--r-- 1 maqadm
sapsys 171 Sep 07 02:46
dbatoolsora.lst
-rw-r--r-- 1 maqadm
sapsys 376 Sep 07 02:46
dbatoolsora.mf
-rw-r--r-- 1 maqadm
sapsys 27635 Sep 07 02:46
initSID.sap
-rwxr-xr-x 1 maqadm
sapsys 2333753 Sep 06 20:27
libsbt.o
-rw-r--r-- 1 maqadm
sapsys 1909 Sep 07 02:46
sapconn_role.sql
-rw-r--r-- 1 maqadm sapsys
5129 Sep 07 02:46 sapdba_role.sql
-rw-r--r-- 1 maqadm
sapsys 9218 Sep 07 02:46
sapuprof_profile.sql
maqadm>
rm DBATL720O10_34-20005193.SAR
maqadm>
ls -l
total 147512
-rw------- 1 maqadm
sapsys 5919 Sep 09 05:16
SIGNATURE.SMF
-rwxr-xr-x 1 maqadm
sapsys 11259483 Sep 07 02:37
brarchive
-rwxr-xr-x 1 maqadm
sapsys 11443336 Sep 07 02:38
brbackup
-rwxr-xr-x 1 maqadm
sapsys 13680646 Sep 07 02:42
brconnect
-rwxr-xr-x 1 maqadm
sapsys 12081206 Sep 07 02:43
brrecover
-rwxr-xr-x 1 maqadm
sapsys 4768980 Sep 07 02:44
brrestore
-rwxr-xr-x 1 maqadm
sapsys 14285817 Sep 07 02:46
brspace
-rwxr-xr-x 1 maqadm
sapsys 5572286 Sep 07 02:46 brtools
-rw-r--r-- 1 maqadm
sapsys 171 Sep 07 02:46
dbatoolsora.lst
-rw-r--r-- 1 maqadm
sapsys 376 Sep 07 02:46
dbatoolsora.mf
-rw-r--r-- 1 maqadm
sapsys 27635 Sep 07 02:46
initSID.sap
-rwxr-xr-x 1 maqadm
sapsys 2333753 Sep 06 20:27
libsbt.o
-rw-r--r-- 1 maqadm
sapsys 1909 Sep 07 02:46
sapconn_role.sql
-rw-r--r-- 1 maqadm
sapsys 5129 Sep 07 02:46
sapdba_role.sql
-rw-r--r-- 1 maqadm
sapsys 9218 Sep 07 02:46
sapuprof_profile.sql
- Execute o comando cp –p * para enviar os arquivos para o diretório
do kernel.
cp –p * /sapmnt/<SID>/exe
- Após, execute o comando brtools –V para conferir a atualização.
maqadm> brtools -V
BR0651I BRTOOLS 7.20 (34)
Patch
Date Info
1 2010-01-26 BR*Tools support for Oracle 11g (note
1430669)
9 2010-10-27 BR*Tools support for eSourcing databases
(note 1523205)
18
2011-09-07 BR*Tools support for
Oracle ASM and Exadata (note 1627541)
25
2012-06-28 Corrections in
BR*Tools 7.20 patch 25 (note 1735811)
26
2012-09-12 Corrections in
BR*Tools 7.20 patch 26 (note 1763972)
27
2012-09-12 Support for secure
storage in BR*Tools (note 1764043)
28
2012-10-25 Corrections in
BR*Tools 7.20 patch 28 (note 1780057)
29
2012-12-03 Corrections in
BR*Tools 7.20 patch 29 (note 1795814)
30
2013-01-31 Corrections in
BR*Tools 7.20 patch 30 (note 1816874)
31
2013-03-26 Corrections in
BR*Tools 7.20 patch 31 (note 1838852)
32
2013-05-28 Corrections in
BR*Tools 7.20 patch 32 (note 1865897)
33
2013-07-03 Corrections in
BR*Tools 7.20 patch 33 (note 1882181)
34
2013-09-05 Corrections in
BR*Tools 7.20 patch 34 (note 1909451)
release note 1428529
kernel release 720
patch date 2013-09-05
patch level 34
make platform rs6000_64
make codeline 720_REL
make mode OCI_102
make
date Sep 7 2013
Abraços
Exception CX_DBA_ADBC, CX_SQL_EXCEPTION - ORA-00942
Referencia
Transações Afetadas
- DB02
- ST04
Problema
ORA-00942: table or view does not exist
Exception CX_DBA_ADBC in function unit READ_TEXT_FILE
line 12 ( function group S_ORA_COCKPIT_5 include )
Kernel Error ID:
WP
ID: 2
WP
PID: 13303910
SYSID: DEV
SY-SUBRC: 0
SQL
statement: SELECT line FROM sys.ext_tab_dbac_alert
Database: DEFAULT
caused by
Exception
CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET
Kernel Error ID:
DB
Error: Yes
SQL
Code: 942
SQL
Message: ORA-00942: table or view does not exist
DB
Object Exists: No
Duplicated Key: No
Internal Error: 5
Invalid Cursor: No
Unknown Connection: No
Connection
Closed: No
Solução
- Crie o script sappost3.sql, copie e cole o script abaixo.
- Troque o SID TMP para o SID do seu sistema.
- Execute no sqlplus e verifique se o problema foi
resolvido.
spool sappost3.log
connect / as sysdba
drop directory ext_dir_dbac_client;
create directory ext_dir_dbac_client as
'/usr/sap/TMP/SYS/profile/oracle';
drop table ext_tab_dbac_tnsnames;
create table ext_tab_dbac_tnsnames
(line varchar2(2000))
ORGANIZATION EXTERNAL
(type oracle_loader
default directory ext_dir_dbac_client
access parameters
(RECORDS DELIMITED BY NEWLINE
NOLOGFILE)
location ('tnsnames.ora'));
drop table ext_tab_dbac_sqlnet;
create table ext_tab_dbac_sqlnet
(line varchar2(2000))
ORGANIZATION EXTERNAL
(type oracle_loader
default directory ext_dir_dbac_client
access parameters
(RECORDS DELIMITED BY NEWLINE
NOLOGFILE)
location ('sqlnet.ora'));
GRANT READ ON DIRECTORY
ext_dir_dbac_client TO SAPR3 WITH GRANT OPTION;
GRANT WRITE ON DIRECTORY ext_dir_dbac_client
TO SAPR3 WITH GRANT OPTION;
GRANT SELECT ON ext_tab_dbac_tnsnames
TO SAPR3;
GRANT SELECT ON ext_tab_dbac_sqlnet TO
SAPR3;
drop directory ext_dir_dbac_server;
create directory ext_dir_dbac_server as
'/oracle/TMP/102_64/network/admin';
drop table ext_tab_dbac_listener;
create table ext_tab_dbac_listener
(line varchar2(2000))
ORGANIZATION EXTERNAL
(type oracle_loader
default directory ext_dir_dbac_server
access parameters
(RECORDS DELIMITED BY NEWLINE
NOLOGFILE)
location ('listener.ora'));
GRANT READ ON DIRECTORY
ext_dir_dbac_server TO SAPR3 WITH GRANT OPTION;
GRANT WRITE ON DIRECTORY
ext_dir_dbac_server TO SAPR3 WITH GRANT OPTION;
GRANT SELECT ON ext_tab_dbac_listener
TO SAPR3;
drop directory ext_dir_dbac_alert;
create directory ext_dir_dbac_alert as
'/oracle/TMP/saptrace/background';
drop table ext_tab_dbac_alert;
create table ext_tab_dbac_alert
(line varchar2(2000))
ORGANIZATION EXTERNAL
(type oracle_loader
default directory ext_dir_dbac_alert
access parameters
(RECORDS DELIMITED BY NEWLINE
NOLOGFILE)
location ('alert_TMP.log'));
GRANT READ ON DIRECTORY
ext_dir_dbac_alert TO SAPR3 WITH GRANT OPTION;
GRANT WRITE ON DIRECTORY
ext_dir_dbac_alert TO SAPR3 WITH GRANT OPTION;
GRANT SELECT ON ext_tab_dbac_alert TO
SAPR3;
spool
off
exit
Abraços
2EETW169 no connect possible: maybe someone set invalid values for DIR_LIBRARY
Problema 1
maqtst:tstadm 23> R3trans -x
This is R3trans version 6.24 (release 720 - 14.03.13 - 20:13:02 ).
sizeof(Selection_t) = 336
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/TST/SYS/exe/run') or dbms_type ('ORA')"
R3trans finished (0012).
BR0253E errno 2: No such file or directory
Problema
BR0280I BRCONNECT time stamp: 2013-10-25 15.21.58
BR0941I 0 BRRECOVER log files deleted from directory /oracle/TST/sapbackup
BR0252E Function opendir() failed for '/oracle/TST/sapreorg' at location BrLogCleanup-2
BR0253E errno 2: No such file or directory
BR0252E Function opendir() failed for '/oracle/TST/sapreorg' at location BrLogCleanup-2
BR0253E errno 2: No such file or directory
BR0280I BRCONNECT time stamp: 2013-10-25 15.21.58
BR0941I 0 BRRECOVER log files deleted from directory /oracle/TST/sapbackup
BR0252E Function opendir() failed for '/oracle/TST/sapreorg' at location BrLogCleanup-2
BR0253E errno 2: No such file or directory
BR0252E Function opendir() failed for '/oracle/TST/sapreorg' at location BrLogCleanup-2
BR0253E errno 2: No such file or directory
Postagens
