SCU0 - Table Comparison


Solução

DTecno Consultoria SAP - Suporte SAP Remoto sob Demanda
Keywords: Consultoria SAP, Consultor SAP, SAP Remoto, SAP Basis, Suporte SAP Remoto, SAP FI, Consultor FI, Consultor MM, SAP MM

ORA-00059: maximum number of DB_FILES exceeded



Problema
BR0280I BRSPACE time stamp: 2015-06-01 11:15:55
BR1088I Extending tablespace PSAPBTABI ...
BR0280I BRSPACE time stamp: 2015-06-01 11:16:34
BR0301E SQL error -59 at location BrSqlExecute-1, SQL statement:
'/* BRSPACE */ alter tablespace PSAPBTABI add datafile '/oracle/TST/sapdata4/btabi_28/btabi.data28' size 5000M autoextend on next 20M maxsize 6000M'
ORA-00059: maximum number of DB_FILES exceeded
BR1017E Execution of SQL statement '/* BRSPACE */ alter tablespace PSAPBTABI add datafile '/oracle/TST/sapdata4/btabi_28/btabi.data28' size 5000M autoextend on next 20M maxsize 6000M' failed

BR0280I BRSPACE time stamp: 2015-06-01 11:16:34
BR0669I Cannot continue due to previous warnings or errors - you can go back and repeat the last action
BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:


Referencia

Solução
You do not need to recreate control file. See below:

SQL> sho user
SYS
SQL> select * from v$version;


BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production


SQL> sho parameter db_files

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files integer 200
SQL> alter system set db_files = 512 scope = spfile;

SQL> shutdown immediate
SQL> startup
SQL> sho parameter db_files

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files integer 512




Terminal XXXXX in status DISC




Problema
- Na SM21.
Terminal 00075 in status DISC


Solução
- Verifique a conexão de rede do SAP Logon com o servidor.

DTecno Consultoria SAP - Suporte SAP Remoto sob Demanda
Keywords: Consultoria SAP, Consultor SAP, SAP Remoto, SAP Basis, Suporte SAP Remoto, SAP FI, Consultor FI, Consultor MM, SAP MM

Solaris - Sendmail - Start/Stop



As root, issue the following command
/etc/init.d/sendmail stop

To restart it:

/etc/init.d/sendmail start


DTecno Consultoria SAP - Suporte SAP Remoto sob Demanda
Keywords: Consultoria SAP, Consultor SAP, SAP Remoto, SAP Basis, Suporte SAP Remoto, SAP FI, Consultor FI, Consultor MM, SAP MM

ERROR: The executable R3trans in /usr/sap/SID/SUM/abap/exe is too old


Problema
ERROR: The executable R3trans in /usr/sap/<SID>/SUM/abap/exe is too old.
It needs a release date of 06.06.14 or later.

Download the new tools according to SAP Note 19466 and put the archives into the download directory.


Solução
- Faça download da última versão do tp e do R3trans.
- Deixe os arquivos *.SAR no diretório de download.

DTecno Consultoria SAP - Suporte SAP Remoto sob Demanda
Keywords: Consultoria SAP, Consultor SAP, SAP Remoto, SAP Basis, Suporte SAP Remoto, SAP FI, Consultor FI, Consultor MM, SAP MM
  

Changing SMTP default port



1- Check which there is an unsigned port 

2- Edit /etc/services file

3- Comment lines with smtp
#smtp                   25/tcp          # Simple Mail Transfer
#smtp                   25/udp          # Simple Mail Transfer

4- Add lines with new port and save the /etc/service file
smtp                   1025/tcp          # Simple Mail Transfer
smtp                   1025/udp          # Simple Mail Transfer

5- Restart sendmail service
#refresh -s sendmail

Reference: http://www.aixmind.com/?p=1413


DTecno Consultoria SAP - Suporte SAP Remoto sob Demanda
Keywords: Consultoria SAP, Consultor SAP, SAP Remoto, SAP Basis, Suporte SAP Remoto, SAP FI, Consultor FI, Consultor MM, SAP MM

List all users from a specific profile


1- Access the SUIM tcode.

2- Open tree User

3- If your SAP system uses CUA, open Cross-System Information (Central User Administration), If doesn't, open Users by complex Selection Criteria

4- In both options, click on By Profiles

5- In the field Profile Name, insert the profile name

6- Execute (F8)

DTecno Consultoria SAP - Suporte SAP Remoto sob Demanda
Keywords: Consultoria SAP, Consultor SAP, SAP Remoto, SAP Basis, Suporte SAP Remoto, SAP FI, Consultor FI, Consultor MM, SAP MM

OCS Package XXXXXX, tp step "I" return code 0016


Problema 1

SQL error 24374 occured: ORA-24374: define not done before fetch or execute and fetch

Problema 2
The installation was stopped, since an error occurred during the phase
IMPORT_PROPER, which the Add-On Installation Tool is unable to resolve
without your input.

After you have corrected the cause of the error, continue with the
import by choosing Continue in the queue display.

The following details help you to analyze the problem:


    -   Error in phase: IMPORT_PROPER

    -   Reason for error: TP_STEP_FAILURE

    -   Return code: 0016

    -   Error message: OCS Package SAPK-10004INUIINFRA, tp step "I",
        return code 0016

Solução
- Aplique os últimos patches no kernel, incluindo o executável tp.

DTecno Consultoria SAP - Suporte SAP Remoto sob Demanda
Keywords: Consultoria SAP, Consultor SAP, SAP Remoto, SAP Basis, Suporte SAP Remoto

Fonte
- SAP Support


Outstanding DB conversions found



Issue

-No SUM, na fase Extraction

Conversion Check

WARNING: Outstanding DB conversions found:
Entry
ENQU/UI5/E_REP 0CNVI 20140728DDIC


Remove all converter entries as described in the guide and repeat this phase. 

Solution

Solution indicated for SUM version SP11. For older versions consult the correct update guide, in section Cleaning Up Terminated Conversions in the DB Conversion Phases

1. Determine the objects that are affected.

1. Start the database utility transaction (transaction SE14) and choose DB Requests Mass Processing .

2. Choose All requests.
The worklist of the conversion program appears. This worklist was generated by developments or modifications in your SAP system, but has not yet been processed.


3. Choose DB requests Created with import .
The worklist that was not processed correctly during the last update appears.

2. Check the meaning and status of the requests.
In contrast to the procedure for the message Restart logs of DB conversions found, this procedure can also include requests for indexes, views and matchcode objects. The requests that are found are not always terminated. They might not even have been started.

1. Ask the last person who changed the object if the request should still be processed.

2. If the user does not want it to be processed, select the request and choose Delete selected.
This removes the objects from the worklist of the conversion program.
Do not remove requests from the last update.

3. Process the outstanding requests.
You can select the requests from the list of mass processing requests and schedule a job for execution with the
function Schedule selections.

1. Go to the detailed display of the object by double-clicking it in the list of requests created by the import.

2. Schedule the request, or continue it. Since you do not know how long this takes, choose processing type Background.


DTecno Consultoria SAP - Suporte SAP Remoto sob Demanda
Keywords: Consultoria SAP, Consultor SAP, SAP Remoto, SAP Basis, Suporte SAP Remoto

Referencia


Could not open the ICU common library



Problema 1 
SAPup> Starting subprocess with PID 9633946 in phase 'TOOLVERSION_UNI' at 20140730101422
    ENV: DIR_LIBRARY=/usr/sap/TST/DVEBMGS00/exe
    ENV: JAVA_HOME=/usr/java14_64
    ENV: LIBPATH=/usr/sap/TST/DVEBMGS00/exe:/usr/sap/TST/SUM/jvm/jre/lib/ppc64/server:/usr/sap/TST/SUM/jvm/jre/lib/ppc64:/usr/sap/TST/SU
M/jvm/jre/../lib/ppc64:/usr/sap/TST/SUM/jvm/jre/lib/ppc64/jli:/usr/sap/TST/SUM/jvm/jre/../lib/ppc64/jli:/usr/lib:/lib:/usr/sap/TST/SYS/e
xe/run:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/TST/112_64
    ENV: ORACLE_SID=TST
    ENV: PATH=/usr/sap/TST/DVEBMGS00/exe:/oracle/TST/112_64/bin:/usr/java14_64/bin:.:/home/tstadm:/usr/sap/TST/SYS/exe/run:/usr/bin:/etc
:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java5/jre/bin:/usr/java5/bin
    ENV: SAPDATA_HOME=/oracle/TST
    ENV: SAPSYSTEMNAME=TST
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=TST

EXECUTING /usr/sap/TST/DVEBMGS00/exe/tp  -V
Could not open the ICU common library.
   The following files must be in the path described by
   the environment variable "LIBPATH":
   libicuuc40.a, libicudata40.a, libicui18n40.a [nlsui0.c 1548] pid = 9633946
LIBPATH is currently set to /usr/sap/TST/DVEBMGS00/exe:/usr/sap/TST/SUM/jvm/jre/lib/ppc64/server:/usr/sap/TST/SUM/jvm/jre/lib/ppc64:/usr
/sap/TST/SUM/jvm/jre/../lib/ppc64:/usr/sap/TST/SUM/jvm/jre/lib/ppc64/jli:/usr/sap/TST/SUM/jvm/jre/../lib/ppc64/jli:/usr/lib:/lib:/usr/sa
p/TST/SYS/exe/run:/oracle/client/11x_64/instantclient  [nlsui0.c 1551] pid = 9633946
SAPup> Process with PID 9633946 terminated with status 255 at 20140730101422!

Problema 2
SAPup> Starting subprocess with PID 12320986 in phase 'TOOLVERSION_UNI' at 20140730110321
    ENV: DIR_LIBRARY=/usr/sap/TST/DVEBMGS00/exe
    ENV: JAVA_HOME=/usr/java14_64
    ENV: LIBPATH=/usr/sap/TST/DVEBMGS00/exe:/usr/sap/TST/SUM/jvm/jre/lib/ppc64/server:/usr/sap/TST/SUM/jvm/jre/lib/ppc64:/usr/sap/TST/SU
M/jvm/jre/../lib/ppc64:/usr/sap/TST/SUM/jvm/jre/lib/ppc64/jli:/usr/sap/TST/SUM/jvm/jre/../lib/ppc64/jli:/usr/lib:/lib:/usr/sap/TST/SYS/e
xe/run:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/TST/112_64
    ENV: ORACLE_SID=TST
    ENV: PATH=/usr/sap/TST/DVEBMGS00/exe:/oracle/TST/112_64/bin:/usr/java14_64/bin:.:/home/tstadm:/usr/sap/TST/SYS/exe/run:/usr/bin:/etc
:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java5/jre/bin:/usr/java5/bin
    ENV: SAPDATA_HOME=/oracle/TST
    ENV: SAPSYSTEMNAME=TST
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=TST

EXECUTING /usr/sap/TST/DVEBMGS00/exe/tp  -V
ERROR in child process: Cannot execute '/usr/sap/TST/DVEBMGS00/exe/tp': Exec format error

SAPup> Process with PID 12320986 terminated with status 27 at 20140730110321!

Solução
- Stopsap
- Com o usuário root logado, execute o comando.
> ps -ef | grep sapstartsrv

- Finalize o processo com o comando
kill -9 <sapstartsrv pid>

- Com o usuário <sid>adm, execute os comandos
sapcpe pf=/usr/sap/<sid>/SYS/profile/<SID>_DVEBMGS0_<hostname>
> sapcpe pf=/usr/sap/<sid>/SYS/profile/START_SCS<NR>_<hostname>

- Inicie o SAP

>startsap

DTecno Consultoria SAP - Suporte SAP Remoto sob Demanda
Keywords: Consultor SAP, SAP Remoto, SAP Basis, Suporte SAP Remoto

Referencia
http://vinbasis.wordpress.com/2012/10/10/sap-kernel-upgrade-700-to-720-on-unix-anix/