Para um bom funcionamento do banco de dados Oracle uma das tarefas primordiais é o ajuste do sistema operacional, em outras palavras, adaptar o sistema operacional para hospedar o banco de dados, essa adaptação envolve mudanças no comportamento padrão do sistema operacional, que é requerido para que o Oracle exercer suas atividades, sem quaisquer surpresas.

 

  • Verificação de memória MEMORIA RAM e SWAP

Memoria RAM

Requisitos: Valor mínimo 2.5GB

Como verificar:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”L3Vzci9zYmluL2xzYXR0ciAtRSAtbCBzeXMwIC1hIHJlYWxtZW0=” hover_enabled=”0″]L3Vzci9zYmluL2xzYXR0ciAtRSAtbCBzeXMwIC1hIHJlYWxtZW0=[/et_pb_dmb_code_snippet]

SWAP

Requisitos: Valor mínimo 1,5GG

Como verificar:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”L3Vzci9zYmluL2xzcHMgLWE=” hover_enabled=”0″]L3Vzci9zYmluL2xzcHMgLWE=[/et_pb_dmb_code_snippet]

Recomendação: Para uma hardware com capacidade de 2.5GB até 16GB de MEMORIA RAM devemos usar “Valor de SWAP” = “Valor de MEMORIA RAM”. Para uma hardware com capacidade acima de 16GB RAM devemos usar 16GB para SWAP

 

  • Verificação de espaço na partição /tmp do file system

Requisitos: Valor mínimo 2GB

Como verificar:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”L3Vzci9iaW4vZGYgLWcgL3RtcA==” hover_enabled=”0″]L3Vzci9iaW4vZGYgLWcgL3RtcA==[/et_pb_dmb_code_snippet]
  • Parametrizações do Kernel1. Parametrização do sistema operacional AIX via utilitário no.
[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”bm8gLXIgLW8gaXBxbWF4bGVuPTUxMgpubyAtciAtbyByZmMxMzIzPTEKbm8gLXIgLW8gc2JfbWF4PTEzMTA3MjAKbm8gLXIgLW8gdGNwX3JlY3ZzcGFjZT02NTUzNgpubyAtciAtbyB0Y3Bfc2VuZHNwYWNlPTY1NTM2Cm5vIC1yIC1vIHVkcF9zZW5kc3BhY2U9NjU1MzYKbm8gLXIgLW8gdWRwX3JlY3ZzcGFjZT02NTUzNjAKbm8gLXAgLW8gdGNwX2VwaGVtZXJhbF9sb3c9OTAwMCAtbyB0Y3BfZXBoZW1lcmFsX2hpZ2g9NjU1MDAKbm8gLXAgLW8gdWRwX2VwaGVtZXJhbF9sb3c9OTAwMCAtbyB1ZHBfZXBoZW1lcmFsX2hpZ2g9NjU1MDA=” hover_enabled=”0″]bm8gLXIgLW8gaXBxbWF4bGVuPTUxMgpubyAtciAtbyByZmMxMzIzPTEKbm8gLXIgLW8gc2JfbWF4PTEzMTA3MjAKbm8gLXIgLW8gdGNwX3JlY3ZzcGFjZT02NTUzNgpubyAtciAtbyB0Y3Bfc2VuZHNwYWNlPTY1NTM2Cm5vIC1yIC1vIHVkcF9zZW5kc3BhY2U9NjU1MzYKbm8gLXIgLW8gdWRwX3JlY3ZzcGFjZT02NTUzNjAKbm8gLXAgLW8gdGNwX2VwaGVtZXJhbF9sb3c9OTAwMCAtbyB0Y3BfZXBoZW1lcmFsX2hpZ2g9NjU1MDAKbm8gLXAgLW8gdWRwX2VwaGVtZXJhbF9sb3c9OTAwMCAtbyB1ZHBfZXBoZW1lcmFsX2hpZ2g9NjU1MDA=[/et_pb_dmb_code_snippet]

Recomendação: Após execução das parametrizações, efetuar um reboot do servidor.

Para verificar os valor dos parâmetros após reboot, utilizar os comandos:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”L3Vzci9zYmluL25vIC1hIHwgZ3JlcCBpcHFtYXhsZW4KL3Vzci9zYmluL25vIC1hIHwgZ3JlcCByZmMxMzIzCi91c3Ivc2Jpbi9ubyAtYSB8IGdyZXAgc2JfbWF4Ci91c3Ivc2Jpbi9ubyAtYSB8IGdyZXAgdGNwX3JlY3ZzcGFjZQovdXNyL3NiaW4vbm8gLWEgfCBncmVwIHRjcF9zZW5kc3BhY2UKL3Vzci9zYmluL25vIC1hIHwgZ3JlcCB1ZHBfc2VuZHNwYWNlCi91c3Ivc2Jpbi9ubyAtYSB8IGdyZXAgdWRwX3JlY3ZzcGFjZQ==” hover_enabled=”0″]L3Vzci9zYmluL25vIC1hIHwgZ3JlcCBpcHFtYXhsZW4KL3Vzci9zYmluL25vIC1hIHwgZ3JlcCByZmMxMzIzCi91c3Ivc2Jpbi9ubyAtYSB8IGdyZXAgc2JfbWF4Ci91c3Ivc2Jpbi9ubyAtYSB8IGdyZXAgdGNwX3JlY3ZzcGFjZQovdXNyL3NiaW4vbm8gLWEgfCBncmVwIHRjcF9zZW5kc3BhY2UKL3Vzci9zYmluL25vIC1hIHwgZ3JlcCB1ZHBfc2VuZHNwYWNlCi91c3Ivc2Jpbi9ubyAtYSB8IGdyZXAgdWRwX3JlY3ZzcGFjZQ==[/et_pb_dmb_code_snippet]

             2. Parametrização das interface de rede do sistema operacional AIX via utilitário chdev.

Requisitos: tcp_recvspace , tcp_sendspace , udp_recvspace e udp_sendspace, devem estar com valores 65536.

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”Y2hkZXYgLWwgJ2VuWFhYWCcgLWEgc3RhdGU9J3VwJyAtYSB0Y3BfcmVjdnNwYWNlPSc2NTUzNicgLWEgdGNwX3NlbmRzcGFjZT0nNjU1MzYnCgpjaGRldiAtbCAnZW5YWFhYJyAtYSBzdGF0ZT0ndXAnIC1hIHVkcF9yZWN2c3BhY2U9JzY1NTM2JyAtYSB1ZHBfc2VuZHNwYWNlPSc2NTUzNic=” hover_enabled=”0″]Y2hkZXYgLWwgJ2VuWFhYWCcgLWEgc3RhdGU9J3VwJyAtYSB0Y3BfcmVjdnNwYWNlPSc2NTUzNicgLWEgdGNwX3NlbmRzcGFjZT0nNjU1MzYnCgpjaGRldiAtbCAnZW5YWFhYJyAtYSBzdGF0ZT0ndXAnIC1hIHVkcF9yZWN2c3BhY2U9JzY1NTM2JyAtYSB1ZHBfc2VuZHNwYWNlPSc2NTUzNic=[/et_pb_dmb_code_snippet]

OBS.: Entende-se por ‘enXXXX’ uma interface de rede valida, por exemplo, en0 (‘enXXXX’ é um nome genérico que representa a sua interface válida.).

Exemplo:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”Y2hkZXYgLWwgJ2VuMScgLWEgc3RhdGU9J3VwJyAtYSB1ZHBfcmVjdnNwYWNlPSc2NTUzNicgLWEgdWRwX3NlbmRzcGFjZT0nNjU1MzYnCmNoZGV2IC1sICdlbjEnIC1hIHN0YXRlPSd1cCcgLWEgdGNwX3JlY3ZzcGFjZT0nNjU1MzYnIC1hIHRjcF9zZW5kc3BhY2U9JzY1NTM2Jw==” hover_enabled=”0″]Y2hkZXYgLWwgJ2VuMScgLWEgc3RhdGU9J3VwJyAtYSB1ZHBfcmVjdnNwYWNlPSc2NTUzNicgLWEgdWRwX3NlbmRzcGFjZT0nNjU1MzYnCmNoZGV2IC1sICdlbjEnIC1hIHN0YXRlPSd1cCcgLWEgdGNwX3JlY3ZzcGFjZT0nNjU1MzYnIC1hIHRjcF9zZW5kc3BhY2U9JzY1NTM2Jw==[/et_pb_dmb_code_snippet]

     3. Parametrização dos recursos de hardware interface de rede do sistema operacional AIX via utilitário chdev.

 

Requisitos: Parâmetro “maxuproc” deve ser maior ou igual a 16384.

Como verificar:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”bHNhdHRyIC1FIC1sIHN5czAgLWEgbWF4dXByb2MgLUYgdmFsdWU=” hover_enabled=”0″]bHNhdHRyIC1FIC1sIHN5czAgLWEgbWF4dXByb2MgLUYgdmFsdWU=[/et_pb_dmb_code_snippet]

Se, maxuproc não é maior ou igual a 16384, então é necessário ajusta-lo

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”Y2hkZXYgLWwgc3lzMCAtYSBtYXh1cHJvYz0xNjM4NA==” hover_enabled=”0″]Y2hkZXYgLWwgc3lzMCAtYSBtYXh1cHJvYz0xNjM4NA==[/et_pb_dmb_code_snippet]
  •  Verificar se existe todas as bibliotecas necessárias para instalação (compilação) do Oracle Database.
  1.  Checar os filesets necessários para a instalação.

Requisitos: Os seguintes filesets são requeridos:

  • adt.base
  • adt.lib
  • adt.libm
  • perf.libperfstat
  • perf.perfstat
  • perf.proctools
  • aix61.rte:10.1.0.0 ou superior
  • rte.10.1.0.0 ou superior
  • base 3.3.0.11 ou superior

 

Como verificar:

  • O campos “State” deve estar com status “COMMITTED”
[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”bHNscHAgLWwgYm9zLmFkdC5iYXNlIGJvcy5hZHQubGliIGJvcy5hZHQubGlibSBib3MucGVyZi5wZXJmc3RhdCBib3MucGVyZi5saWJwZXJmc3RhdCBib3MucGVyZi5wcm9jdG9vbHMgeGxDLmFpeDYxLnJ0ZSByc2N0LmJhc2ljLnJ0ZSByc2N0LmNvbXBhdC5jbGllbnRzLnJ0ZSB4bEMucnRl” hover_enabled=”0″]bHNscHAgLWwgYm9zLmFkdC5iYXNlIGJvcy5hZHQubGliIGJvcy5hZHQubGlibSBib3MucGVyZi5wZXJmc3RhdCBib3MucGVyZi5saWJwZXJmc3RhdCBib3MucGVyZi5wcm9jdG9vbHMgeGxDLmFpeDYxLnJ0ZSByc2N0LmJhc2ljLnJ0ZSByc2N0LmNvbXBhdC5jbGllbnRzLnJ0ZSB4bEMucnRl[/et_pb_dmb_code_snippet]

2. Verificar se HACMP está instalado.

Como verificar:

  • O retorno do comando deverá informar que as bibliotecas, referente ao HACMP está “not installed”
[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”bHNscHAgLWwgY2x1c3Rlci5lcy4qIHJzY3QuaGFjbXAucnRlIHJzY3QuY29tcGF0LmJhc2ljLmhhY21wLnJ0ZSByc2N0LmNvbXBhdC5jbGllbnRzLmhhY21wLnJ0ZQ==” hover_enabled=”0″]bHNscHAgLWwgY2x1c3Rlci5lcy4qIHJzY3QuaGFjbXAucnRlIHJzY3QuY29tcGF0LmJhc2ljLmhhY21wLnJ0ZSByc2N0LmNvbXBhdC5jbGllbnRzLmhhY21wLnJ0ZQ==[/et_pb_dmb_code_snippet]
  • Verificar se Patch APAR para o “AIX 7.1 TL 0 SP1”, requerido para o Oracle 11gR2 foi aplicado.

APAR é um pedido para a correção de um defeito em uma versão atual de um programa fornecido pela IBM.

Como verificar:

O retorno do comando deverá informar, que foram encontrados todos os filesets para o determinado APAR.

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”L3Vzci9zYmluL2luc3RmaXggLWkgLWsg4oCcSVo4NzIxNiBJWjg3NTY04oCd” hover_enabled=”0″]L3Vzci9zYmluL2luc3RmaXggLWkgLWsg4oCcSVo4NzIxNiBJWjg3NTY04oCd[/et_pb_dmb_code_snippet]

O Retorno do comando deve ser:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”QWxsIGZpbGVzZXRzIGZvciBJWjg3MjE2IHdlcmUgZm91bmQuCkFsbCBmaWxlc2V0cyBmb3IgSVo4NzU2NCB3ZXJlIGZvdW5kLg==” hover_enabled=”0″]QWxsIGZpbGVzZXRzIGZvciBJWjg3MjE2IHdlcmUgZm91bmQuCkFsbCBmaWxlc2V0cyBmb3IgSVo4NzU2NCB3ZXJlIGZvdW5kLg==[/et_pb_dmb_code_snippet]
  •  Workarounds dos bugs 13531373 e 13077654.

1.  bug 13531373 – AIX specific

No arquivo /etc/rc.net, insira o bloco IF abaixo, no fim do arquivo.

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”IyMjIyMjIyMgV29ya2Fyb3VuZCBidWcgMTM1MzEzNzMgKEFJWCkKIyMgREJBRlVSVVNISU1BIOKAkyBDQVJMT1MgRlVSVVNISU1BCiMKaWYgWyAtZiAvdXNyL3NiaW4vbm8gXSA7IHRoZW4KL3Vzci9zYmluL25vIC1wIC1vIHRjcF9lcGhlbWVyYWxfbG93PTkwMDAKL3Vzci9zYmluL25vIC1wIC1vIHVkcF9lcGhlbWVyYWxfbG93PTkwMDAKL3Vzci9zYmluL25vIC1wIC1vIHRjcF9lcGhlbWVyYWxfaGlnaD02NTUwMAovdXNyL3NiaW4vbm8gLXAgLW8gdWRwX2VwaGVtZXJhbF9oaWdoPTY1NTAwCi91c3Ivc2Jpbi9ubyAtcCAtbyB1ZHBfc2VuZHNwYWNlPTY1NTM2Ci91c3Ivc2Jpbi9ubyAtcCAtbyB1ZHBfcmVjdnNwYWNlPTY1NTM2MAovdXNyL3NiaW4vbm8gLXAgLW8gdGNwX3NlbmRzcGFjZT02NTUzNgovdXNyL3NiaW4vbm8gLXAgLW8gdGNwX3JlY3ZzcGFjZT02NTUzNgovdXNyL3NiaW4vbm8gLXAgLW8gcmZjMTMyMz0xCi91c3Ivc2Jpbi9ubyAtcCAtbyBzYl9tYXg9NDE5NDMwNAovdXNyL3NiaW4vbm8gLXIgLW8gaXBxbWF4bGVuPTUxMgpmaQojCiMjIyMjIyMj” hover_enabled=”0″]IyMjIyMjIyMgV29ya2Fyb3VuZCBidWcgMTM1MzEzNzMgKEFJWCkKIyMgREJBRlVSVVNISU1BIOKAkyBDQVJMT1MgRlVSVVNISU1BCiMKaWYgWyAtZiAvdXNyL3NiaW4vbm8gXSA7IHRoZW4KL3Vzci9zYmluL25vIC1wIC1vIHRjcF9lcGhlbWVyYWxfbG93PTkwMDAKL3Vzci9zYmluL25vIC1wIC1vIHVkcF9lcGhlbWVyYWxfbG93PTkwMDAKL3Vzci9zYmluL25vIC1wIC1vIHRjcF9lcGhlbWVyYWxfaGlnaD02NTUwMAovdXNyL3NiaW4vbm8gLXAgLW8gdWRwX2VwaGVtZXJhbF9oaWdoPTY1NTAwCi91c3Ivc2Jpbi9ubyAtcCAtbyB1ZHBfc2VuZHNwYWNlPTY1NTM2Ci91c3Ivc2Jpbi9ubyAtcCAtbyB1ZHBfcmVjdnNwYWNlPTY1NTM2MAovdXNyL3NiaW4vbm8gLXAgLW8gdGNwX3NlbmRzcGFjZT02NTUzNgovdXNyL3NiaW4vbm8gLXAgLW8gdGNwX3JlY3ZzcGFjZT02NTUzNgovdXNyL3NiaW4vbm8gLXAgLW8gcmZjMTMyMz0xCi91c3Ivc2Jpbi9ubyAtcCAtbyBzYl9tYXg9NDE5NDMwNAovdXNyL3NiaW4vbm8gLXIgLW8gaXBxbWF4bGVuPTUxMgpmaQojCiMjIyMjIyMj[/et_pb_dmb_code_snippet]

2. bug 13077654 – AIX specific

Criação de link simbólico para utilitários no e lsattr, em /etc.

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”bG4gLXMgL3Vzci9zYmluL25vIC9ldGMvbm8KbG4gLXMgL3Vzci9zYmluL2xzYXR0ciAvZXRjL2xzYXR0cg==” hover_enabled=”0″]bG4gLXMgL3Vzci9zYmluL25vIC9ldGMvbm8KbG4gLXMgL3Vzci9zYmluL2xzYXR0ciAvZXRjL2xzYXR0cg==[/et_pb_dmb_code_snippet]
  •  Criação de usuários e grupos UNIX.

Descreveremos a criação dos usuários grid (Usuário owner do grid infrastructure) e oracle (Usuário owner para o RDBMS).

 

Criação dos grupos

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”bWtncm91cCAt4oCYQeKAmSBpZD3igJk1MDHigLIgYWRtcz3igJlyb2904oCZIGRiYQpta2dyb3VwIC3igJhB4oCZIGlkPeKAmTUwMuKAsiBhZG1zPeKAmXJvb3TigJkgb2luc3RhbGwKbWtncm91cCAt4oCYQeKAmSBpZD3igJk1MDPigLIgYWRtcz3igJlyb2904oCZIG9wZXIKbWtncm91cCAt4oCYQeKAmSBpZD3igJk1MDTigLIgYWRtcz3igJlyb2904oCZIGFzbWFkbWluCm1rZ3JvdXAgLeKAmEHigJkgaWQ94oCZNTA14oCyIGFkbXM94oCZcm9vdOKAmSBhc21hZGJhCm1rZ3JvdXAgLeKAmEHigJkgaWQ94oCZNTA24oCyIGFkbXM94oCZcm9vdOKAmSBhc21vcGVy” hover_enabled=”0″]bWtncm91cCAt4oCYQeKAmSBpZD3igJk1MDHigLIgYWRtcz3igJlyb2904oCZIGRiYQpta2dyb3VwIC3igJhB4oCZIGlkPeKAmTUwMuKAsiBhZG1zPeKAmXJvb3TigJkgb2luc3RhbGwKbWtncm91cCAt4oCYQeKAmSBpZD3igJk1MDPigLIgYWRtcz3igJlyb2904oCZIG9wZXIKbWtncm91cCAt4oCYQeKAmSBpZD3igJk1MDTigLIgYWRtcz3igJlyb2904oCZIGFzbWFkbWluCm1rZ3JvdXAgLeKAmEHigJkgaWQ94oCZNTA14oCyIGFkbXM94oCZcm9vdOKAmSBhc21hZGJhCm1rZ3JvdXAgLeKAmEHigJkgaWQ94oCZNTA24oCyIGFkbXM94oCZcm9vdOKAmSBhc21vcGVy[/et_pb_dmb_code_snippet]

Criação dos usuários

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”bWt1c2VyIGlkPeKAmTQwMeKAsiBwZ3JwPeKAmW9pbnN0YWxs4oCZIGdyb3Vwcz3igJlvaW5zdGFsbCxkYmEsYXNtYWRtaW4sYXNtZGJhLGFzbW9wZXLigJkgaG9tZT3igJkvaG9tZS9ncmlk4oCZIGdyaWQKbWt1c2VyIGlkPeKAmTQwMuKAsiBwZ3JwPeKAmW9pbnN0YWxs4oCZIGdyb3Vwcz3igJlvaW5zdGFsbCxkYmEsYXNtYWRtaW4sYXNtZGJhLGFzbW9wZXLigJkgaG9tZT3igJkvaG9tZS9vcmFjbGXigJkgb3JhY2xl” hover_enabled=”0″]bWt1c2VyIGlkPeKAmTQwMeKAsiBwZ3JwPeKAmW9pbnN0YWxs4oCZIGdyb3Vwcz3igJlvaW5zdGFsbCxkYmEsYXNtYWRtaW4sYXNtZGJhLGFzbW9wZXLigJkgaG9tZT3igJkvaG9tZS9ncmlk4oCZIGdyaWQKbWt1c2VyIGlkPeKAmTQwMuKAsiBwZ3JwPeKAmW9pbnN0YWxs4oCZIGdyb3Vwcz3igJlvaW5zdGFsbCxkYmEsYXNtYWRtaW4sYXNtZGJhLGFzbW9wZXLigJkgaG9tZT3igJkvaG9tZS9vcmFjbGXigJkgb3JhY2xl[/et_pb_dmb_code_snippet]
  • Atribuir Capabilities para o usuário owner do grid infrastructure.

Atribuindo os Capabilities:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”L3Vzci9iaW4vY2h1c2VyIGNhcGFiaWxpdGllcz1DQVBfTlVNQV9BVFRBQ0gsQ0FQX0JZUEFTU19SQUNfVk1NLENBUF9QUk9QQUdBVEUgZ3JpZA==” hover_enabled=”0″]L3Vzci9iaW4vY2h1c2VyIGNhcGFiaWxpdGllcz1DQVBfTlVNQV9BVFRBQ0gsQ0FQX0JZUEFTU19SQUNfVk1NLENBUF9QUk9QQUdBVEUgZ3JpZA==[/et_pb_dmb_code_snippet]

Como verificar:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”L3Vzci9iaW4vbHN1c2VyIC1hIGNhcGFiaWxpdGllcyBncmlk” hover_enabled=”0″]L3Vzci9iaW4vbHN1c2VyIC1hIGNhcGFiaWxpdGllcyBncmlk[/et_pb_dmb_code_snippet]
  • Definição dos limits em /etc/security/limits para os usuario que estão envolvidos com os binário ORACLE instalados.

 

Os usuários devem conter as seguintes características de limits.

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”ZnNpemUgPSAtMQpjb3JlID0gMjA5NzE1MQpjcHUgPSAtMQpkYXRhID0gLTEKcnNzID0gLTEKc3RhY2sgPSAtMQpub2ZpbGVzID0gLTE=” hover_enabled=”0″]ZnNpemUgPSAtMQpjb3JlID0gMjA5NzE1MQpjcHUgPSAtMQpkYXRhID0gLTEKcnNzID0gLTEKc3RhY2sgPSAtMQpub2ZpbGVzID0gLTE=[/et_pb_dmb_code_snippet]

Exemplo:

grid :

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”ZnNpemUgPSAtMQpjb3JlID0gMjA5NzE1MQpjcHUgPSAtMQpkYXRhID0gLTEKcnNzID0gLTEKc3RhY2sgPSAtMQpub2ZpbGVzID0gLTE=” hover_enabled=”0″]ZnNpemUgPSAtMQpjb3JlID0gMjA5NzE1MQpjcHUgPSAtMQpkYXRhID0gLTEKcnNzID0gLTEKc3RhY2sgPSAtMQpub2ZpbGVzID0gLTE=[/et_pb_dmb_code_snippet]

oracle :

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”ZnNpemUgPSAtMQpjb3JlID0gMjA5NzE1MQpjcHUgPSAtMQpkYXRhID0gLTEKcnNzID0gLTEKc3RhY2sgPSAtMQpub2ZpbGVzID0gLTE=” hover_enabled=”0″]ZnNpemUgPSAtMQpjb3JlID0gMjA5NzE1MQpjcHUgPSAtMQpkYXRhID0gLTEKcnNzID0gLTEKc3RhY2sgPSAtMQpub2ZpbGVzID0gLTE=[/et_pb_dmb_code_snippet]
  • Configuração do NTP

Em caso de implementação do Oracle RAC, o serviço NTP é necessário para sincronização do horário entre os nodes existentes.

Inserir o bloco de configuração abaixo em /etc/ntp.conf, informando o IP de seu servidor NTP, no argumento da linha “server” (Primeira linha).

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”c2VydmVyIDxJUCBETyBTRVUgU0VSVklET1IgTlRQPgoKZHJpZnRmaWxlIC9ldGMvbnRwLmRyaWZ0Cgp0cmFjZWZpbGUgL2V0Yy9udHAudHJhY2U=” hover_enabled=”0″]c2VydmVyIDxJUCBETyBTRVUgU0VSVklET1IgTlRQPgoKZHJpZnRmaWxlIC9ldGMvbnRwLmRyaWZ0Cgp0cmFjZWZpbGUgL2V0Yy9udHAudHJhY2U=[/et_pb_dmb_code_snippet]

No arquivo /etc/rc.tcpip, retire o comentário da linha com o conteúdo “#start /usr/sbin/xntpd “$src_running”” (Comentário é representado pelo caractere #) e ao final do conteúdo adicione o argumento “-x”.

Linha com comentário

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”I3N0YXJ0IC91c3Ivc2Jpbi94bnRwZCDigJwkc3JjX3J1bm5pbmfigJ0=” hover_enabled=”0″]I3N0YXJ0IC91c3Ivc2Jpbi94bnRwZCDigJwkc3JjX3J1bm5pbmfigJ0=[/et_pb_dmb_code_snippet]

Linha sem comentário + argumento “-x”

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”c3RhcnQgL3Vzci9zYmluL3hudHBkIOKAnCRzcmNfcnVubmluZ+KAnSDigJwteOKAnQ==” hover_enabled=”0″]c3RhcnQgL3Vzci9zYmluL3hudHBkIOKAnCRzcmNfcnVubmluZ+KAnSDigJwteOKAnQ==[/et_pb_dmb_code_snippet]

Finalizado todos os ajustes de NTP, realizar um stop/start dos serviços, representado pelo deamon xntpd.

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”c3RvcHNyYyAtcyB4bnRwZAoKc3RhcnRzcmMgLXMgeG50cGQgLWEg4oCcLXjigJ0=” hover_enabled=”0″]c3RvcHNyYyAtcyB4bnRwZAoKc3RhcnRzcmMgLXMgeG50cGQgLWEg4oCcLXjigJ0=[/et_pb_dmb_code_snippet]

Como verificar status do NTP:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”bHNzcmMgLWxzIHhudHBk” hover_enabled=”0″]bHNzcmMgLWxzIHhudHBk[/et_pb_dmb_code_snippet]