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

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

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

Mais informações

Listando tablespaces, tamanho total, espaço livre

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

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

Oracle 11.2.0: Database Parameter Settings

1431798 - Oracle 11.2.0: Database Parameter Settings

Mais informações

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

Problema

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

Solução

update vol * acce=readw whereacc=unav

Mais informações

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

Mais informações

Error IcmJ2EEScheduleFunc - Please check host configuration

Problema

- Na transação ST11, no arquivo dev_icm.

*** ERROR => Connection request from (-1/65535/0) to host: unbru03.unifi.br, service: 9902 failed (NIEHOST_UNKNOWN) {00000098} [icxxconn_mt.c 2712]

*** ERROR => IcmJ2EEScheduleFunc: Connection to unbru03.unifi.br:9902 failed - please check host configuration (-8) [icxxman_mt.c 2477]

Referencia

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

Solução

- Adicione o FQDN no parâmetro icm/host_name_full da profile.

Formato:

icm/host_name_full       hostname.domain

Exemplo:

icm/host_name_full       maqtst.workgroup.com.br

- Ajuste o arquivo /etc/hosts inserindo o FQDN.

Formato:

ip            FQDN

Exemplo:

10.0.0.5   maqtst.workgroup.com.br

Mais informações

DB13 não exibe logs do arquivo alert log

Problema
- Após migação do Oracle 10g para o Oracle 11g, a transação DB13 não exibie os logs do arquivo alert.log.

Solução
- Na postagem EXCEPTION CX_DBA_ADBC, CX_SQL_EXCEPTION - ORA-00942 indiquei um script para correção de um erro ao tentar ler o arquivo alert.log.
- Para resolver o problema acima, basta obter o mesmo script, alterando apenas a linha abaixo,
create directory ext_dir_dbac_alert as '/oracle/TMP/saptrace/background';
para,
create directory ext_dir_dbac_alert as '/oracle/TMP/saptrace/diag/rdbms/tmp/TMP/trace/alert_TMP.log';

Lembrando:
- Altere o valor TMP para o SID do seu sistema.

Mais informações

Alterando um datafile para autoextend on

Modelo
alter database tempfile '/path/datafile_name' autoextend on next valueM maxsize sizeM'

onde,
 path: Caminho do datafile
 datafile_name: Nome do datafile
 value: Valor que será acrecido quando um datafile precisa de espaço
 size: Tamanho máximo de crescimento


Exemplo
alter database tempfile '/oracle/TST/sapdata1/temp_1/temp.data1' autoextend on next 10M maxsize 10000M'

Mais informações