Denis - Blog | SAP, Windows, Unix, Oracle e mais alguns...

BRTOOLS - BR0253E errno 13: Permission denied

Em Oracle, SAP - 02 dezembro 2013 - As 15:54 - 1 Comentario

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

Note 113747 - Owners and authorizations for BR*Tools

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:

chmod 4775 brarchive brbackup brconnect

chown oratsa:sapsys brarchive brbackup brconnect

chmod 755 brrestore brrecover brspace brtools

chown tsaadm:sapsys brrestore brrecover brspace brtools

Mais informações

Alterando senha do usuário root

Em Ubuntu - 28 novembro 2013 - As 14:18 - Sem Comentarios

Solução
sudo passwd

Mais informações

Bundle Script Log Files - INCOMPLETE

Em Oracle, SAP - 27 novembro 2013 - As 14:51 - Sem Comentarios

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

1509324 - catsbp.sql reports INCOMPLETE status

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 #

######################################################################

Mais informações

GC 3 The active profile was modified

Em SAP - - As 08:23 - Sem Comentarios

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

http://scn.sap.com/thread/1113344

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.

Mais informações

Brspace-f tscreate - Options

Em Oracle, SAP - 26 novembro 2013 - As 17:00 - Sem Comentarios

http://help.sap.com/saphelp_nw04/helpdata/en/99/eaac06eec707428e2b0b9d9d9d647a/content.htm

Mais informações

Listando tablespaces, tamanho total, espaço livre

Em Oracle - - As 16:05 - Sem Comentarios

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;

Mais informações

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

Em Aix, Oracle - 25 novembro 2013 - As 17:05 - Sem Comentarios

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

Mais informações