Creating OPS$ users on Unix

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





PSAPTEMP is empty

Oracle



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

Particionando HD sem formatação - Windows 7

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';

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

- Verificando o national character set.

SQL> select property_value from database_properties
     where upper(property_name  2  ) = 'NLS_NCHAR_CHARACTERSET';

PROPERTY_VALUE
--------------------------------------------------------------------------------

UTF8

Oracle Database 11.2.0.3 - Patches by SAP

Erro na porta 21200 durante instalação do SAP Ecc 6

Aix

-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

Listing Swap Space - Aix

#lsps –a 

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.

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