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 

Alterando senha do usuário root

Ubuntu
Solução
sudo passwd

Bundle Script Log Files - INCOMPLETE

SAP

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


Oracle

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

SAP

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.

Brspace-f tscreate - Options

Listando tablespaces, tamanho total, espaço livre

Oracle
Referencia
http://psoug.org/snippet/TABLESPACE--List-tablespaces-files-allocated-and-free-space_852.htm

Script
SELECT df.tablespace_name TABLESPACE, df.total_space TOTAL_SPACE,
fs.free_space FREE_SPACE, df.total_space_mb TOTAL_SPACE_MB,
(df.total_space_mb - fs.free_space_mb) USED_SPACE_MB,
fs.free_space_mb FREE_SPACE_MB,
ROUND(100 * (fs.free_space / df.total_space),2) PCT_FREE
FROM (SELECT tablespace_name, SUM(bytes) TOTAL_SPACE,
      ROUND(SUM(bytes) / 1048576) TOTAL_SPACE_MB
      FROM dba_data_files
      GROUP BY tablespace_name) df,
     (SELECT tablespace_name, SUM(bytes) FREE_SPACE,
       ROUND(SUM(bytes) / 1048576) FREE_SPACE_MB
       FROM dba_free_space
       GROUP BY tablespace_name) fs
WHERE df.tablespace_name = fs.tablespace_name(+)
ORDER BY fs.tablespace_name;

Checking swap space: 0 MB available, 150 MB required. Failed

Oracle


Checking swap space: 0 MB available, 150 MB required. Failed <<<<

I checked the tmp file system space and the swap from Aix, there any
problem with it.

maqtst@root:/oracle/TST:>swap -l
device maj,min total free
/dev/paging03 10, 6 4096MB 4049MB
//paging02 10, 5 4096MB 4054MB
/dev/paging01 10, 4 4096MB 4054MB
/dev/paging00 10, 3 4096MB 4054MB
/dev/hd6 10, 2 4096MB 4055MB

maqtst@root:/oracle/TST:>df -g /tmp
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd3 9.00 1.47 84% 2068 1% /tmp


Solução
./runInstaller -ignoreSysPrereqs

Oracle 11.2.0: Database Parameter Settings

ANR2410E: Command: Unable to access volume volume name - access mode is set to "unavailable".

TSM

Problema
ANR2410E: Command: Unable to access volume volume name - access mode is set to "unavailable".

Solução

update vol * acce=readw whereacc=unav

ANR8356E - Incorrect volume was mounted instead of volume in library


Problema
11/21/13   17:24:02      ANR8356E Incorrect volume 392AHHL4 was mounted instead of
                          volume 275AHHL4 in library LIB3100. (SESSION: 66,       
                          PROCESS: 11)

Solução

>audit library LIB3100 checkl=barcode