Setting the national character set to UTF8

Referência

669902 - Setting the national character set to UTF8

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

Mais informações

Oracle Database 11.2.0.3 - Patches by SAP

Note 1631931 - Oracle 11.2.0: Patches / Patch collections for 11.2.0.3

Mais informações

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

Mais informações

Listing Swap Space - Aix

#lsps –a 

Mais informações

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

Mais informações

Shutdown Aix

#shutdown -F

Mais informações

Restart Aix

#shutdown -Fr

Mais informações

Updating brtools - Guide

Referência

12741 - Current versions of BR*Tools

Download

http://service.sap.com/swdc

Depending on the system configuration, the following table describes the path to the BR*Tools program package:

  Operating system  Oracle Version      SAP Kernel    Access Path
  --------------------------------------------------------------------
   LINUX  32-bit    10g  32-bit        32-bit        1
   WINDOWS 32-bit    10g  32-bit        32-bit        1
   WINDOWS 64-bit    10g  64-bit        64-bit        2
  UNIX    64-bit    10g  64-bit        64-bit        2
  --------------------------------------------------------------------

Important: The 32-bit versions of BR*Tools are available only with SAP Kernel 7.20.


Access Path 1:
  Main path as starting point (see point [2]):

  --> SAP KERNEL 32-BIT [UNICODE]
    --> SAP KERNEL 7.20 32-BIT [UNICODE]
      --> Linux on IA32 32bit | Windows Server on IA32 32bit
        --> ORACLE
          --> DBATL720O10_nn

Access Path 2:
  Main path as starting point (see point [2]):

  --> SAP KERNEL 64-BIT [UNICODE]
    --> SAP KERNEL 7.20/7.20_EXT/7.40 64-BIT [UNICODE]
      --> Support Package Patches <-- for 7.40 only
        --> AIX 64bit | HP-UX on IA64 64bit | Linux on x86_64 64bit ...
        --> ORACLE
            --> DBATL720O10_nn / DBATL740O11_nn

Instalação

- Verifique a versão da brtools

maq01:oramaq 27> brtools -V

BR0651I BRTOOLS 7.20 (1)

Patch   Date     Info

  1  2010-01-26  BR*Tools support for Oracle 11g (note 1430669)

release note               1428529

kernel release             720

patch date                 2010-01-26

patch level                1

make platform              rs6000_64

make mode                  OCI_102

make date                  Mar  6 2010

- Após o download do arquivo, envie-o via FTP.

- Ajuste as permissões e dono como abaixo.

maq01@root:/tmp:>chmod 777 brtools

maq01@root:/tmp:>chmod -R 777 brtools

maq01@root:/tmp:>chown -R maqadm:sapsys brtools

maq01@root:/tmp:>su - maqadm

maqadm> cd /tmp/brtools

maqadm> ls -l

total 51720

-rwxrwxrwx    1 maqadm   sapsys     26480541 Nov 14 09:11 DBATL720O10_34-20005193.SAR

- Descompacte o arquivo com o SAPCAR.

maqadm> SAPCAR -xvf DBATL720O10_34-20005193.SAR

SAPCAR: processing archive DBATL720O10_34-20005193.SAR (version 2.01)

x brarchive

x brbackup

x brconnect

x brrecover

x brrestore

x brspace

x brtools

x dbatoolsora.lst

x dbatoolsora.mf

x initSID.sap

x libsbt.o

x sapconn_role.sql

x sapdba_role.sql

x sapuprof_profile.sql

x SIGNATURE.SMF

SAPCAR: 15 file(s) extracted

maqadm> ls -l

total 199232

-rwxrwxrwx    1 maqadm   sapsys     26480541 Nov 14 09:11 DBATL720O10_34-20005193.SAR

-rw-------    1 maqadm   sapsys         5919 Sep 09 05:16 SIGNATURE.SMF

-rwxr-xr-x    1 maqadm   sapsys     11259483 Sep 07 02:37 brarchive

-rwxr-xr-x    1 maqadm   sapsys     11443336 Sep 07 02:38 brbackup

-rwxr-xr-x    1 maqadm   sapsys     13680646 Sep 07 02:42 brconnect

-rwxr-xr-x    1 maqadm   sapsys     12081206 Sep 07 02:43 brrecover

-rwxr-xr-x    1 maqadm   sapsys      4768980 Sep 07 02:44 brrestore

-rwxr-xr-x    1 maqadm   sapsys     14285817 Sep 07 02:46 brspace

-rwxr-xr-x    1 maqadm   sapsys      5572286 Sep 07 02:46 brtools

-rw-r--r--    1 maqadm   sapsys          171 Sep 07 02:46 dbatoolsora.lst

-rw-r--r--    1 maqadm   sapsys          376 Sep 07 02:46 dbatoolsora.mf

-rw-r--r--    1 maqadm   sapsys        27635 Sep 07 02:46 initSID.sap

-rwxr-xr-x    1 maqadm   sapsys      2333753 Sep 06 20:27 libsbt.o

-rw-r--r--    1 maqadm   sapsys         1909 Sep 07 02:46 sapconn_role.sql

-rw-r--r--    1 maqadm   sapsys         5129 Sep 07 02:46 sapdba_role.sql

-rw-r--r--    1 maqadm   sapsys         9218 Sep 07 02:46 sapuprof_profile.sql

maqadm> rm DBATL720O10_34-20005193.SAR

maqadm> ls -l

total 147512

-rw-------    1 maqadm   sapsys         5919 Sep 09 05:16 SIGNATURE.SMF

-rwxr-xr-x    1 maqadm   sapsys     11259483 Sep 07 02:37 brarchive

-rwxr-xr-x    1 maqadm   sapsys     11443336 Sep 07 02:38 brbackup

-rwxr-xr-x    1 maqadm   sapsys     13680646 Sep 07 02:42 brconnect

-rwxr-xr-x    1 maqadm   sapsys     12081206 Sep 07 02:43 brrecover

-rwxr-xr-x    1 maqadm   sapsys      4768980 Sep 07 02:44 brrestore

-rwxr-xr-x    1 maqadm   sapsys     14285817 Sep 07 02:46 brspace

-rwxr-xr-x    1 maqadm   sapsys      5572286 Sep 07 02:46 brtools

-rw-r--r--    1 maqadm   sapsys          171 Sep 07 02:46 dbatoolsora.lst

-rw-r--r--    1 maqadm   sapsys          376 Sep 07 02:46 dbatoolsora.mf

-rw-r--r--    1 maqadm   sapsys        27635 Sep 07 02:46 initSID.sap

-rwxr-xr-x    1 maqadm   sapsys      2333753 Sep 06 20:27 libsbt.o

-rw-r--r--    1 maqadm   sapsys         1909 Sep 07 02:46 sapconn_role.sql

-rw-r--r--    1 maqadm   sapsys         5129 Sep 07 02:46 sapdba_role.sql

-rw-r--r--    1 maqadm   sapsys         9218 Sep 07 02:46 sapuprof_profile.sql

- Execute o comando cp –p * para enviar os arquivos para o diretório do kernel.

cp –p * /sapmnt/<SID>/exe

- Após, execute o comando brtools –V para conferir a atualização.

maqadm> brtools -V

BR0651I BRTOOLS 7.20 (34)

Patch   Date     Info

  1  2010-01-26  BR*Tools support for Oracle 11g (note 1430669)

  9  2010-10-27  BR*Tools support for eSourcing databases (note 1523205)

 18  2011-09-07  BR*Tools support for Oracle ASM and Exadata (note 1627541)

 25  2012-06-28  Corrections in BR*Tools 7.20 patch 25 (note 1735811)

 26  2012-09-12  Corrections in BR*Tools 7.20 patch 26 (note 1763972)

 27  2012-09-12  Support for secure storage in BR*Tools (note 1764043)

 28  2012-10-25  Corrections in BR*Tools 7.20 patch 28 (note 1780057)

 29  2012-12-03  Corrections in BR*Tools 7.20 patch 29 (note 1795814)

 30  2013-01-31  Corrections in BR*Tools 7.20 patch 30 (note 1816874)

 31  2013-03-26  Corrections in BR*Tools 7.20 patch 31 (note 1838852)

 32  2013-05-28  Corrections in BR*Tools 7.20 patch 32 (note 1865897)

 33  2013-07-03  Corrections in BR*Tools 7.20 patch 33 (note 1882181)

 34  2013-09-05  Corrections in BR*Tools 7.20 patch 34 (note 1909451)

release note               1428529

kernel release             720

patch date                 2013-09-05

patch level                34

make platform              rs6000_64

make codeline              720_REL

make mode                  OCI_102

make date                  Sep  7 2013

Abraços

Mais informações

Exception CX_DBA_ADBC, CX_SQL_EXCEPTION - ORA-00942

Referencia

Note 1546456 - DBACockpit: Remote File Access for some Oracle files

Transações Afetadas

- DB02

- ST04

Problema

ORA-00942: table or view does not exist

Exception CX_DBA_ADBC in function unit READ_TEXT_FILE line 12 ( function group S_ORA_COCKPIT_5 include  )

        Kernel Error ID:     

        WP ID:       2 

        WP PID:      13303910

        SYSID:       DEV

        SY-SUBRC:    0 

        SQL statement: SELECT line FROM sys.ext_tab_dbac_alert

        Database: DEFAULT

 caused by

 Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET 

        Kernel Error ID:     

        DB Error:           Yes

        SQL Code:           942 

        SQL Message:        ORA-00942: table or view does not exist

        DB Object Exists:  No

        Duplicated Key:     No

        Internal Error:     5 

        Invalid Cursor:     No

        Unknown Connection:        No

        Connection Closed:         No

  

Solução

- Crie o script sappost3.sql, copie e cole o script abaixo.

- Troque o SID TMP para o SID do seu sistema.

- Execute no sqlplus e verifique se o problema foi resolvido.

spool sappost3.log

connect / as sysdba

drop directory ext_dir_dbac_client;

create directory ext_dir_dbac_client as '/usr/sap/TMP/SYS/profile/oracle';

drop table ext_tab_dbac_tnsnames;

create table ext_tab_dbac_tnsnames

  (line varchar2(2000))

  ORGANIZATION EXTERNAL

  (type oracle_loader

  default directory ext_dir_dbac_client

    access parameters

      (RECORDS DELIMITED BY NEWLINE

      NOLOGFILE)

    location ('tnsnames.ora'));

drop table ext_tab_dbac_sqlnet;

create table ext_tab_dbac_sqlnet

  (line varchar2(2000))

  ORGANIZATION EXTERNAL

  (type oracle_loader

  default directory ext_dir_dbac_client

    access parameters

      (RECORDS DELIMITED BY NEWLINE

      NOLOGFILE)

    location ('sqlnet.ora'));

GRANT READ ON DIRECTORY ext_dir_dbac_client TO SAPR3 WITH GRANT OPTION;

GRANT WRITE ON DIRECTORY ext_dir_dbac_client TO SAPR3 WITH GRANT OPTION;

GRANT SELECT ON ext_tab_dbac_tnsnames TO SAPR3;

GRANT SELECT ON ext_tab_dbac_sqlnet TO SAPR3;

drop directory ext_dir_dbac_server;

create directory ext_dir_dbac_server as '/oracle/TMP/102_64/network/admin';

drop table ext_tab_dbac_listener;

create table ext_tab_dbac_listener

  (line varchar2(2000))

  ORGANIZATION EXTERNAL

  (type oracle_loader

  default directory ext_dir_dbac_server

    access parameters

      (RECORDS DELIMITED BY NEWLINE

      NOLOGFILE)

    location ('listener.ora'));

GRANT READ ON DIRECTORY ext_dir_dbac_server TO SAPR3 WITH GRANT OPTION;

GRANT WRITE ON DIRECTORY ext_dir_dbac_server TO SAPR3 WITH GRANT OPTION;

GRANT SELECT ON ext_tab_dbac_listener TO SAPR3;

drop directory ext_dir_dbac_alert;

create directory ext_dir_dbac_alert as '/oracle/TMP/saptrace/background';

drop table ext_tab_dbac_alert;

create table ext_tab_dbac_alert

  (line varchar2(2000))

  ORGANIZATION EXTERNAL

  (type oracle_loader

  default directory ext_dir_dbac_alert

    access parameters

      (RECORDS DELIMITED BY NEWLINE

      NOLOGFILE)

    location ('alert_TMP.log'));

GRANT READ ON DIRECTORY ext_dir_dbac_alert TO SAPR3 WITH GRANT OPTION;

GRANT WRITE ON DIRECTORY ext_dir_dbac_alert TO SAPR3 WITH GRANT OPTION;

GRANT SELECT ON ext_tab_dbac_alert TO SAPR3;

spool off

exit

Abraços

Mais informações

Verificando a versão da brtools

http://basishowto.blogspot.com.br/2008/10/how-to-check-brtools-version.html

Mais informações

Upgrade Brtools

12741 - Current versions of BR*Tools

Mais informações