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

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