Referencia
http://wiki.scn.sap.com/wiki/display/ABAP/Single+Transaction+Analysis
Solução
- Execute a transação SE30 e analise as estatísticas geradas.
Analisando performance de uma transação
Referencia
http://wiki.scn.sap.com/wiki/display/ABAP/Single+Transaction+Analysis
Solução
- Execute a transação SE30 e analise as estatísticas geradas.
Export a tablespace
Applied
Oracle 11.2.0.3, 10.2.0.4
Format
exp user/pass FILE=/path/file_name.dmp tablespaces=tablespace_name
Example
exp system/manger FILE=/oracle/TST/sapdata3/clud.dmp tablespaces=PSAPCLUD
EXP-00026: conflicting modes specified
Referencia
http://docs.oracle.com/cd/B10501_01/server.920/a96525/expus.htm
Problema
maqtst:oratst 16> exp system/manager FILE=clud.dmp tablespaces=PSAPCLUD owner=SAPR3 full=y rows=y
Export: Release 11.2.0.3.0 - Production on Wed Dec 4 10:10:20 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
EXP-00026: conflicting modes specified
EXP-00000: Export terminated unsuccessfully
Solução
- Execute o comando sem os parâmetros desnecessários.
exp system/manager FILE=clud.dmp tablespaces=PSAPCLUD
IMP-00058: ORACLE error 1017 encountered
Problema
IMP-00058: ORACLE error 1017 encountered
Solução
- Verifique a senha do usuário utilizado no comando imp.
BRTOOLS - BR0253E errno 13: Permission denied
Referência
583861-Unix-Errors due to Oracle Executable
97953 - UNIX-Relinking of the Oracle executables
113747 - Permissions dba tools and sapdba
134592 - Importing the SAPDBA role
Problema 1
- Na db13.
Job started
Step 001 started (program RSDBAJOB, variant &0000000000183, user ID DENISGOMES)
Execute logical command BRCONNECT On host unbru10
Parameters: -u / -jid CLNUP20111027162839 -c -f cleanup
BR0801I BRCONNECT 7.00 (32)
BR0252E Function fopen() failed for '/oracle/TSA/102_64/dbs/initTSA.sap' at location BrInitSapRead-1
BR0253E errno 2: No such file or directory
BR0159E Error reading BR*Tools profile /oracle/TSA/102_64/dbs/initTSA.sap
BR0806I End of BRCONNECT processing: cehbzqhk.log2011-10-27 16.28.40
BR0280I BRCONNECT time stamp: 2011-10-27 16.28.40
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3
BRCONNECT returned error status E
Job finished
Solução 1
- Entre no diretório $ORACLE_HOME/dbs. Verifique se o arquivo init<SID>.sap existe, senão existir, verifique se existe com outro SID e altere o SID para o corrente.
Problema 2
- Na db13
Job started
Step 001 started (program RSDBAJOB, variant &0000000000184, user ID DENISGOMES)
Execute logical command BRCONNECT On host unbru10
Parameters: -u / -jid CLNUP20111027163102 -c -f cleanup
BR0801I BRCONNECT 7.00 (32)
BR0805I Start of BRCONNECT processing: cehbzqmw.cln 2011-10-27 16.31.02
BR0252E Function fopen() failed for '/oracle/TSA/sapcheck/cehbzqmw.cln' at location main-11
BR0253E errno 13: Permission denied
BR0121E Processing of log file /oracle/TSA/sapcheck/cehbzqmw.cln failed
BR0806I End of BRCONNECT processing: cehbzqmw.cln2011-10-27 16.31.03
BR0280I BRCONNECT time stamp: 2011-10-27 16.31.03
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3
BRCONNECT returned error status E
Job finished
Problema 3
01.05.2013 21:00:16 BR0806I End of BRCONNECT processing: celckhfc.log2013-05-01 21.00.16
01.05.2013 21:00:16 BR0280I BRCONNECT time stamp: 2013-05-01 21.00.16
01.05.2013 21:00:16 BR0804I BRCONNECT terminated with errors
01.05.2013 21:00:16 External program terminated with exit code 3
01.05.2013 21:00:16 Internal session terminated with a runtime error (see ST22)
01.05.2013 21:00:16 Job cancelled
Solução 2
- No diretorio /sapmnt/<SID>/exe.
Formato:
chmod 4775 brarchive brbackup brconnect
chown ora<sid>:sapsys brarchive brbackup brconnect
chmod 755 brrestore brrecover brspace brtools
chown <sid>adm:sapsys brrestore brrecover brspace brtools
Exemplo:
chown oratsa:sapsys brarchive brbackup brconnect
chmod 755 brrestore brrecover brspace brtools
chown tsaadm:sapsys brrestore brrecover brspace brtools
Bundle Script Log Files - INCOMPLETE
Problema
* Found the following unexpected
errors:
catbundle_SBP_TST_APPLY_2013Nov27_13_12_29.log:2732:
PLS-00201
catbundle_SBP_TST_APPLY_2013Nov27_13_12_29.log:2738:
PLS-00302
catbundle_SBP_TST_APPLY_2013Nov27_13_12_29.log:2744:
PLS-00302
catbundle_SBP_TST_APPLY_2013Nov27_13_12_29.log:63955:
PLS-00302
***** Patch 17303664 (CBO Merge Patch), added in SBP 11.2.0.3.7 201309
* Post-processing complete.
***** Overall Status
Bundle Script Log Files INCOMPLETE
Patch 14524234 COMPLETE
Patch 17303664 (CBO Merge Patch) COMPLETE
Referencia
Solução
- Execute o script utlrp.sql.
- Entre no
diretorio /oracle/<SID>/112_64/rdbms/admin.
SQL> @?/rdbms/admin/utlrp.sql
- Resultado
######################################################################
#
The following PL/SQL blocks checks completeness of the SAP #
#
Bundle Patch installation. In
particular, it checks the log #
#
files generated by the bundle scripts for errors. #
# #
#
If this block fails, you must check the following log files #
#
under directory $ORACLE_BASE/cfgtoollogs/catbundle manually #
#
for errors:
#
# #
#
catbundle_PSU_TST_GENERATE_2013Nov27_13_46_58.log #
#
catbundle_PSU_TST_APPLY_2013Nov27_13_46_59.log #
#
catbundle_SBP_TST_GENERATE_2013Nov27_13_47_00.log #
#
catbundle_SBP_TST_APPLY_2013Nov27_13_47_01.log #
######################################################################
*****
Verifying bundle log files
* No unexpected errors found.
***** Patch 14524234, added in SBP
11.2.0.3.3 201209
*** NO INVALID OBJECTS FOUND ***
*** END RECOMPILING OBJECTS ***
***** Patch 17303664 (CBO Merge Patch),
added in SBP 11.2.0.3.7 201309
* Post-processing complete.
***** Overall Status
Bundle Log Files COMPLETE
Patch 14524234 COMPLETE
Patch 17303664 (CBO Merge Patch) COMPLETE
######################################################################
#
The above report is available in the following log file under #
#
directory $ORACLE_BASE/cfgtoollogs/catbundle: #
#
#
# SBP_112037_201309_TST_2013Nov27_13_46_57.log #
######################################################################
GC 3 The active profile was modified
Problema
- Na SM21.
GC 3 The active profile was modified
Documentation
for system log message GC 3 :
Das aktive
Profile wurde modifiziert.
The profile
in the database does not match the active profile in the
operating
system. After the profile was activated with the profile
maintenance
transaction, the profile was changed outside of the profile
maintenance
transaction (for example with an operating system editor).
This means
that it is not possible to find out who changed the profile
and when.
Changes to profiles should only be made using the profile
maintenance
transaction. The difference between a profile in the
database
and an active profile in the operating system can be determine
using the
profile maintenance transaction. The active profile of the
operating
system can then also be imported to the database.
Problema 2
GC 4 >>> Profile name = /usr/sap/TST/SYS/profile/TST_DVEBMGS02_maqtst
Problema 3
SAPSYS GC 3
The active profile was modified
SAPSYS GC 4
>>> Profile name = /usr/sap/TST/SYS/profile/TST_DVEBMGS02_maqtst
Referência
Solução
- Acesse a transação RZ10.
- Entre no
menu Utilities->Import Profiles ->
Of active servers.
- A RZ11 realizará uma verificação no arquivo <SID>_<InstanceID>_<hostname>
armazenado no sistema operacional e efetuará o import.
Postagens
