R3trans - Error 2EETW169 - Listener
Problema
maqtst:tstadm 1> R3trans -x
This is R3trans version 6.24 (release 720 - 14.03.13 - 20:13:02 ).
sizeof(Selection_t) = 336
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TST'"
R3trans finished (0012).
Analise
maqtst:oratst 2> lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 14-NOV-2013 08:29:27
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=TST.WORLD))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
Start Date 08-NOV-2013 13:25:47
Uptime 5 days 19 hr. 3 min. 40 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/TST/102_64/network/admin/listener.ora
Listener Log File /oracle/TST/102_64/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=TST.WORLD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=TST)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=maqtst)(PORT=1527)))
Services Summary...
Service "TST" has 1 instance(s).
Instance "TST", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Solução
- Ajuste as variaveis de ambiente para o diretorio da nova versão.
- Execute a opção stop do listener.
- Execute a opção start do listener e observe a alteração
maqtst:oratst 4> lsnrctl start
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 14-NOV-2013 08:30:15
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /oracle/TST/112_64/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
System parameter file is /oracle/TST/112_64/network/admin/listener.ora
Log messages written to /oracle/diag/tnslsnr/maqtst/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=TST.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=TST)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=maqtst)(PORT=1527)))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=TST.WORLD))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Start Date 14-NOV-2013 08:30:19
Uptime 0 days 0 hr. 0 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/TST/112_64/network/admin/listener.ora
Listener Log File /oracle/diag/tnslsnr/maqtst/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=TST.WORLD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=TST)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=maqtst)(PORT=1527)))
Services Summary...
Service "TST" has 1 instance(s).
Instance "TST", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
BRCONNECT - A file or directory in the path name does not exist
Problema
maqtst:oratst 3> brconnect -u system/zebra*01 -c -f stats -t oradict_stats
system/: A file or directory in the path name does not exist.
Solução
- Execute o comando com o usuário e a senha entre aspas duplas.
maqtst:oratst 3> brconnect -u "system/zebra*01" -c -f stats -t oradict_stats
Abraços
maqtst:oratst 3> brconnect -u system/zebra*01 -c -f stats -t oradict_stats
system/: A file or directory in the path name does not exist.
Solução
- Execute o comando com o usuário e a senha entre aspas duplas.
maqtst:oratst 3> brconnect -u "system/zebra*01" -c -f stats -t oradict_stats
Abraços
PSAPTEMP is empty
Problema 1:
ORA-12012: error on auto
execute of job 8936
ORA-25153: Temporary Tablespace
is Empty
Problema 2:
- No alert.log.
WARNING: The
following temporary tablespaces contain no files.
This condition can
occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:
Solução
- Rode o comando find / -name file para localizar os datafiles referentes a esta
tablespace.
Ex:
maqtst@root:/:#find / -name temp.*
/oracle/TST/sapdata1/temp_1/temp.data1
maqtst@root:/:#
- No sqlplus rodar o comando abaixo para cada
datafile localizado.
Comando: alter tablespace PSAPTEMP add
tempfile '<filename>' reuse;
Ex:
SYS@TST>alter tablespace PSAPTEMP add
tempfile '/oracle/TST/sapdata1/temp_1/temp.data1' reuse;
Tablespace altered.
SYS@TST>
- Executar novamente o job na db13 e
verificar na db02.
Abraços
Setting the national character set to UTF8
Referência
Aplicável
- Oracle 9, Oracle 10 e Oracle 11
Solução
###################################################
Antes de
realizar esta alteração, faça um backup do banco de dados
###################################################
- Verifique a versão atual.
maq01:oramaq
3> sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production
on Thu Nov 14 15:08:03 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition
Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data
Mining and Real Application Testing options
SQL> select property_value from database_properties
where upper(property_name) =
'NLS_NCHAR_CHARACTERSET';
PROPERTY_VALUE
--------------------------------------------------------------------------------
AL16UTF16
- Verifique se seu banco de dados não está usando nenhum
campo do tipo NCHAR, NVARCHAR2 or NCLOB. Caso encontre, entre em contato
com o suporte da SAP.
SQL> select owner, table_name, column_name
from dba_tab_columns
where (data_type = 'NCHAR' or
data_type = 'NVARCHAR2' or
data_type = 'NCLOB') and
owner != 'SYS' and
owner != 'SYSTEM';
from dba_tab_columns
where (data_type = 'NCHAR' or
data_type = 'NVARCHAR2' or
data_type = 'NCLOB') and
owner != 'SYS' and
owner != 'SYSTEM';
no
rows selected
Changing the national
character set
- Para realizar esta alteração, é necessário possuir
permissão SYSDBA.
- Execute os comandos nesta ordem.
sqlplus “/as sysdba”
CONNECT / AS SYSDBA
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0 SCOPE = MEMORY;
ALTER SYSTEM SET AQ_TM_PROCESSES=0 SCOPE = MEMORY;
ALTER DATABASE OPEN;
ALTER DATABASE NATIONAL CHARACTER SET UTF8;
SHUTDOWN IMMEDIATE
STARTUP
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0 SCOPE = MEMORY;
ALTER SYSTEM SET AQ_TM_PROCESSES=0 SCOPE = MEMORY;
ALTER DATABASE OPEN;
ALTER DATABASE NATIONAL CHARACTER SET UTF8;
SHUTDOWN IMMEDIATE
STARTUP
- Verificando o national character set.
SQL> select property_value from database_properties
where upper(property_name 2 ) = 'NLS_NCHAR_CHARACTERSET';
PROPERTY_VALUE
--------------------------------------------------------------------------------
UTF8
Erro na porta 21200 durante instalação do SAP Ecc 6
-Verificar o arquivo /etc/hosts. Check o ip da maquina e o seu hostname.
- Adicionar no $PATH o
caminho do “java1.4.2”.
export PATH=/usr/java14_64/jre/bin:/usr/java14_64/bin:$PATH
set –o vi
Extending MAXPPs of a Logical Volume
Problema
maqtst@root:/oracle/TST:#chfs -a size=+5G /oracle/TST/sapdata2
0516-787 extendlv: Maximum allocation for logical volume tstsapdata2lv
is 900.
maqtst@root:/oracle/TST:#chfs -a size=+5G /oracle/TST/sapdata2
0516-787 extendlv: Maximum allocation for logical volume tstsapdata2lv
is 900.
Solução
- Formato do camando:
#chlv -x maxpps
logicalvolume
- MaxPPs: Número total de pps, incluindo os adicionais
- logicalvolume: Nome do logical volume
- Example:
#chlv -x 1024 tstsapdata2lv
Postagens
