Validação do ambiente Oracle com a ferramenta ORACHK

Por Jhonata Lamim
Postado em Novembro 2016

Revisado por Marcelo Pivovar - Solution Architect

O Oracle orachk é uma ferramenta desenvolvida pela própria Oracle para validação de produtos Oracle (database e middleware). Anteriormente conhecido como raccheck, o orachk foi aprimorado e projetado para atender tando as versões Single instance quanto RAC, gerando um relatório detalhado sobre os pontos de riscos encontrados. Além de emitir uma pontuação do ambiente, que vai de 0 a 100.

Atualmente o orachk realiza uma validação dos seguintes produtos:

  • Oracle Database

Standalone Database
Grid Infrastructure & RAC
Maximum Availability Architecture (MAA) Validation
Upgrade Readiness Validation
Golden Gate
Application Continuity

  • Enterprise Manager Cloud Control (12c & 13.1)

Repository
Agents
OMS (version 12.1.0.1 and above on Linux only)

  • E-Business Suite

Oracle Payables (R12 only)
Oracle Workflow
Oracle Purchasing (R12 only)
Oracle Order Management (R12 only)
Oracle Process Manufacturing (R12 only)
Oracle Fixed Assets (R12 only)
Oracle Human Resources (R12 only)
Oracle Receivables (R12 only)
Oracle Customer Relationship Management
Oracle Project Billing

  • Oracle Hardware Systems

Oracle Solaris
Oracle Solaris Cluster
Oracle Systems configuration for Oracle Database, Oracle Middleware & Oracle Applications
ZFS Storage Appliance
Oracle Virtual Networking

  • Oracle Identity and Access Management

Oracle Identity Manager (11.1.2.2.x and 11.1.2.3.x)
Oracle Access Manager (11.1.2.2.x and 11.1.2.3.x)
Oracle Unified Directory (11.1.2.2.x and 11.1.2.3.x)

  • Oracle Siebel

Oracle Siebel verification of the database configuration for stability, best practices and performance optimization (Siebel 8.1.1.11 connecting to Oracle Database 11.2.0.4.)

  • Oracle PeopleSoft

Oracle PeopleSoft verification of the database best practices

As principais características que podemos destacar do ORAchk são:

  • Verificação proativa de problemas conhecidos e de maior impacto para o sistema.
  • Simplifica e agiliza a investigação e análise de problemas conhecidos que representam um risco ao ambiente.
  • É uma ferramenta leve, não precisa de instalação e a execução ocorre isolada (os dados não trafegam pela rede nem são enviados para a Oracle)
  • Possuí relatório de alto nível possibilitando identificação clara dos riscos existentes no ambiente.
  • Permite o possibilidade de configuração de envio de email quando um problema é detectado.

Agora que já conhecemos um pouco do ORAchk e seus benefícios, vamos a um exemplo prático de instalação", execução e verificação do relatório gerado em um ambiente de testes single instance.
O donwload da versão mais atual pode ser realizado no My Oracle Support através do Doc ID 1268927.2.

Apos efetuar o download do ORAchk e envia-lo ao servidor que estaremos avaliando, basta descompacta-lo dentro de um diretório específico.
No teste efetuado, criei o diretório orachk, e descompactei o arquivo dentro do mesmo

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
[oracle@ora12c discos]$ mkdir  orachk 
[oracle@ora12c discos]$ mv  orachk.zip orachk 
[oracle@ora12c discos]$ cd orachk 
[oracle@ora12c orachk]$ ls 
orachk.zip 
[oracle@ora12c orachk]$ unzip  orachk.zip 
Archive:  orachk.zip 
inflating:  sample_user_defined_checks.xml 
inflating:  collections.dat 
inflating:  CollectionManager_App.sql 
inflating:  UserGuide.txt 
inflating:  rules.dat 
inflating:  orachk 
creating:  .cgrep/ 
inflating:  .cgrep/exalogic_zfs_checks_el_extensive.aksh 
inflating:  .cgrep/OVMMCheckChannels.py 
inflating:  .cgrep/scnhealthcheck.sql 
inflating:  .cgrep/checkDiskFGMapping.sh 
inflating:  .cgrep/pxhcdr.sql 
inflating:  .cgrep/lcgrep4 
inflating:  .cgrep/lcgreps9 
inflating:  .cgrep/zonecores.sh 
inflating:  .cgrep/cgrepwin61 
inflating:  .cgrep/profile_collections.pl 
inflating:  .cgrep/checkHiddenParams.sh 
inflating:  .cgrep/registry_validation.sql 
inflating:  .cgrep/ggdiscovery.sh 
inflating:  .cgrep/zfssa_checks.aksh 
inflating:  .cgrep/psqlplus 
inflating:  .cgrep/ogghc_12101.sql 
inflating:  .cgrep/load_checks_attributes.pl 
inflating:  .cgrep/parse_index.pl 
inflating:  .cgrep/oracle-upstarttmpl.conf 
inflating:  .cgrep/acchk.jar 
inflating:  .cgrep/rack_comparison.py 
inflating:  .cgrep/discoverdbasm.pl 
inflating:  .cgrep/create_small_file.pl 
inflating:  .cgrep/preupgrd.sql 
inflating:  .cgrep/diff_checks.pl 
inflating:  .cgrep/scgrep 
inflating:  .cgrep/diff_collections.pl 
inflating:  .cgrep/lcgreps11 
inflating:  .cgrep/hiacgrep 
inflating:  .cgrep/ogghc_11203.sql 
inflating:  .cgrep/ogghc_11204.sql 
inflating:  .cgrep/isc_summary.pl 
inflating:  .cgrep/ofm_client.sh 
inflating:  .cgrep/rac_lib.pm 
inflating:  .cgrep/mineocr.pm 
inflating:  .cgrep/validatePassword.sh 
inflating:  .cgrep/check_sysctl.awk 
inflating:  .cgrep/zlcgrep6 
inflating:  .cgrep/auto_upgrade.pl 
inflating:  .cgrep/vmpscan.sh 
inflating:  .cgrep/scgrepx86 
inflating:  .cgrep/checkFlashCache.sh 
inflating:  .cgrep/checkDiskScheduler.sh 
inflating:  .cgrep/profile_only.dat 
inflating:  .cgrep/discover_java_home.sh 
inflating:  .cgrep/create_version.pl 
inflating:  .cgrep/raw_data_browser.pl 
inflating:  .cgrep/show_file_in_html.pl 
extracting:  .cgrep/zfs_basic_check.akwf 
creating:  .cgrep/profiles/ 
inflating:  .cgrep/profiles/D49B218473787400E0431EC0E50A0BB9.prf 
extracting:  .cgrep/profiles/2A2FC945D720BAB8E0530C98EB0AC02F.prf 
inflating:  .cgrep/profiles/12B66730A5161437E05312C0E50AABAB.prf 
inflating:  .cgrep/profiles/0A82EA8BF9646097E05313C0E50A26D6.prf 
inflating:  .cgrep/profiles/F9ED0179CCD8256BE04312C0E50A5399.prf 
inflating: .cgrep/profiles/1B0907A7BA8DA932E0530C98EB0A0947.prf 
inflating:  .cgrep/profiles/F6AFECA37F177C3FE04313C0E50A56BF.prf 
inflating:  .cgrep/profiles/09DC8AC7C7974BDDE05313C0E50A2339.prf 
inflating:  .cgrep/profiles/177BBFEE0215240AE0530E98EB0AEBF7.prf 
inflating: .cgrep/profiles/D49BDC2EC9E624AEE0431EC0E50A3E12.prf 
extracting:  .cgrep/profiles/21A3C08B67727E6AE0530E98EB0AE59C.prf 
inflating:  .cgrep/profiles/165CCF84D4FE0342E0530A98EB0AAE6E.prf 
extracting:  .cgrep/profiles/1A5008BEC8B612BCE0530E98EB0AA998.prf 
inflating:  .cgrep/profiles/D49C0AB26A6D45A8E0431EC0E50ADE06.prf 
inflating:  .cgrep/profiles/D49C4F9F48735396E0431EC0E50A9A0B.prf 
inflating:  .cgrep/profiles/DFE9C207A8F2428CE04313C0E50A6B0A.prf 
inflating:  .cgrep/profiles/271BD73C756AE5EDE0530B98EB0A6A13.prf 
inflating:  .cgrep/profiles/DF65D0F7FB6F1014E04312C0E50A7808.prf 
inflating:  .cgrep/profiles/1B0907A7BA8CA932E0530C98EB0A0947.prf 
inflating:  .cgrep/profiles/270F37922A89B520E0530B98EB0ADDE9.prf 
inflating:  .cgrep/profiles/178E758EB8CA06D8E0530D98EB0A7AC9.prf 
extracting:  .cgrep/profiles/F13E11974A282AB3E04312C0E50ABCBF.prf 
inflating:  .cgrep/profiles/EF6C016813C51366E04313C0E50AE11F.prf 
inflating: .cgrep/profiles/DA94919CD0DE0913E04312C0E50A7996.prf 
inflating:  .cgrep/profiles/D49C0FBF8FBF4B1AE0431EC0E50A0F24.prf 
inflating:  .cgrep/profiles/06889D8BB65E575CE05313C0E50ADFD3.prf 
inflating:  .cgrep/profiles/D8367AD6754763FEE04312C0E50A6FCB.prf 
inflating: .cgrep/profiles/DF65D6117CB41054E04312C0E50A69D1.prf 
inflating:  .cgrep/profiles/06702DE980726771E05313C0E50ACF83.prf 
extracting:  .cgrep/profiles/2A302D96CCE5F8B2E0530A98EB0A71EE.prf 
inflating:  .cgrep/profiles/1B0907A7BA8EA932E0530C98EB0A0947.prf 
inflating:  .cgrep/profiles/20E3DAB976AD7377E0530A98EB0A9BCA.prf 
inflating:  .cgrep/profiles/E1BF012E8F210839E04313C0E50A7B68.prf 
inflating:  .cgrep/profiles/D462A6F7E9C340FDE0431EC0E50ABE12.prf 
inflating:  .cgrep/profiles/069273EAA9873FD1E05312C0E50A8953.prf 
inflating:  .cgrep/profiles/EA5EE324E7E05128E04313C0E50A4B2A.prf 
inflating: .cgrep/profiles/3194E615F4BBEDD0E0530A98EB0A046E.prf 
inflating:  .cgrep/profiles/1C6E4AC8EF3674D0E0530D98EB0ACEC1.prf 
inflating:  .cgrep/profiles/E8DF76E07DD82E0DE04313C0E50AA55D.prf 
inflating:  .cgrep/profiles/206B850D83B1CE54E0530C98EB0A5C89.prf 
inflating:  .cgrep/profiles/F32F44CE0BCD662FE04312C0E50AB058.prf 
inflating: .cgrep/profiles/E2E972DDE1E14493E04312C0E50A1AB1.prf 
inflating:  .cgrep/profiles/D49AD88F8EE75CD8E0431EC0E50A0BC3.prf 
inflating: .cgrep/lcgrep5 
inflating:  .cgrep/idmhc_get_check_status.pl 
inflating:  .cgrep/switch_multirack.sh 
inflating:  .cgrep/utlu112i.sql 
inflating:  .cgrep/parse_user_defined_checks.pl 
inflating:  .cgrep/rac_file_checker.pl 
inflating:  .cgrep/detect_custom_rpms.sh 
inflating:  .cgrep/checkLocalDisks.sh 
inflating:  .cgrep/lcgreps10 
inflating:  .cgrep/get_zfs_checks.pl 
inflating:  .cgrep/filechecker.sh 
inflating:  .cgrep/check_reblance_free_space.sql 
inflating:  .cgrep/merge_collections.pl 
inflating:  .cgrep/append_merge_collections.pl 
inflating:  .cgrep/lcgrep6s 
inflating:  .cgrep/utluppkg.sql 
inflating:  .cgrep/host_specific_collections.pl 
inflating:  .cgrep/reset_crshome.pl 
inflating:  .cgrep/wallet2.pl 
inflating:  .cgrep/cgrepwin63 
inflating:  .cgrep/asrexacheck 
inflating:  .cgrep/init.tmpl 
inflating:  .cgrep/readreg.pl 
inflating:  .cgrep/utlusts.sql 
inflating:  .cgrep/rac_main.pl 
inflating:  .cgrep/acgrep 
inflating:  .cgrep/exalogic_zfs_checks.aksh 
inflating:  .cgrep/profiles.dat 
inflating:  .cgrep/lcgrep6 
inflating:  .cgrep/checkvg.sh 
inflating:  .cgrep/run_individual_checks.pl 
inflating:  .cgrep/combine_collections.pl 
inflating:  .cgrep/versions.dat 
inflating:  readme.txt 
inflating:  user_defined_checks.xsd 
creating:  .cgrep/zfschecks/ 
inflating:  .cgrep/zfschecks/Cluster 
inflating:  .cgrep/zfschecks/ZSCPU 
inflating:  .cgrep/zfschecks/ExtMirrorProfile 
inflating:  .cgrep/zfschecks/ExtShareDedup 
inflating:  .cgrep/zfschecks/Shadows 
inflating:  .cgrep/zfschecks/ExtShadows 
inflating:  .cgrep/zfschecks/ZSServices 
inflating:  .cgrep/zfschecks/NFSDomain 
inflating:  .cgrep/zfschecks/NFS4LockObjectLeak 
inflating:  .cgrep/zfschecks/ShareQuota 
inflating:  .cgrep/zfschecks/ZSILOM 
inflating:  .cgrep/zfschecks/ShareDedup 
inflating:  .cgrep/zfschecks/ExtShareQuota 
inflating:  .cgrep/zfschecks/SnapshotVisibility 
inflating:  .cgrep/zfschecks/ZSFan 
inflating:  .cgrep/zfschecks/Lock 
inflating:  .cgrep/zfschecks/BlockSize 
inflating:  .cgrep/zfschecks/SoftringWorkflow 
inflating:  .cgrep/zfschecks/DiskTimeoutWarning 
inflating:  .cgrep/zfschecks/HeadStatus 
inflating:  .cgrep/zfschecks/ZSRouting 
inflating:  .cgrep/zfschecks/Maintenance 
inflating:  .cgrep/zfschecks/AnalyticsRetentionPolicy 
inflating:  .cgrep/zfschecks/ZSVersion 
inflating:  .cgrep/zfschecks/ZSIPMP 
inflating:  .cgrep/zfschecks/L2ARCHeader 
inflating:  .cgrep/zfschecks/ZSSlot 
inflating:  .cgrep/zfschecks/Datasets 
inflating:  .cgrep/zfschecks/DNSConfiguration 
inflating:  .cgrep/zfschecks/ZSDIMM 
inflating:  .cgrep/zfschecks/ZSPrivateNetworkInterface 
inflating:  .cgrep/zfschecks/MirrorProfile 
inflating:  .cgrep/zfschecks/Backend 
inflating:  .cgrep/zfschecks/ZSNTP 
inflating:  .cgrep/zfschecks/NFSDelegation 
inflating:  .cgrep/zfschecks/CommonCode 
inflating:  .cgrep/zfschecks/StorageMemSize 
inflating:  .cgrep/zfschecks/ZSPowerSupply 
inflating:  .cgrep/zfschecks/ExtBlockSize 
inflating:  .cgrep/zfschecks/ZSPool 
inflating:  .cgrep/zfschecks/ZSZillas 
creating:  exadiscover/ 
inflating:  exadiscover/list_master_node.sql 
inflating:  exadiscover/list_ovmm.sql 
inflating:  exadiscover/list_all_ips_vars.sql 
inflating:  exadiscover/exadiscover.py 
inflating:  exadiscover/exadiscover.sh 
inflating:  exadiscover/CHANGELOG 
inflating:  exadiscover/README 
inflating:  exadiscover/list_all_ips.sql 
inflating:  exadiscover/list_assets.sql 
creating:  templates/ 
inflating:  templates/exachk_exalogic.conf.tmpl_quarter 
inflating:  templates/exachk_exalogic.conf.tmpl_full 
inflating:  templates/exachk_exalogic.conf.tmpl_eighth 
inflating:  templates/exachk_exalogic.conf.tmpl_half 
inflating:  generate_guests_list.sh 
inflating:  ORAchk_Health_Check_Catalog.html 
inflating:  doc/ORAchk_and_EXAchk_User_Guide.pdf 
inflating:  doc/ORAchk_EXAchk_Feature_Fix_History.pdf 
[oracle@ora12c orachk]$

Após descompactar, basta executar o orachk e informar as "interações" solicitadas para execução do relatório. Para que toda a validação seja possível, será preciso que o usuário que estará executando (preferencialmente seja o oracle) tenha permissão para realizar um sudo ou você pode fornecer a senha do root durante a execução.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
Banco=lamimcdb-> echo  $ORACLE_HOME 
/orabin/app/oracle//product/12.1.0.2/db_1 
Banco=lamimcdb-> echo  $ORACLE_SID 
lamimcdb 
Banco=lamimcdb-> echo  $ORACLE_BASE 
/orabin/app/oracle/ 
Banco=lamimcdb-> 
Banco=lamimcdb-> 
Banco=lamimcdb->  ./orachk 
Enter  ORACLE_HOME for lamimcdb :  /orabin/app/oracle//product/12.1.0.2/db_1
List of running  databases
1.  lamimcdb 
2. None  of above
Select databases  from list  for checking  best practices. For multiple databases, 
select 1 for All or comma separated number like  1,2 etc  [1-2][1].1
. . 
 
Checking  Status of Oracle Software Stack - Clusterware, ASM, RDBMS
. . . . . . . . . . . . . . . 
------------------------------------------------------------------------------------------------------- 
                                         Oracle  Stack Status 
------------------------------------------------------------------------------------------------------- 
Host Name  CRS  Installed  ASM HOME   RDBMS  Installed  CRS UP    ASM UP    RDBMS  UP  DB Instance Name
------------------------------------------------------------------------------------------------------- 
ora12c     No              No         Yes              No        No        Yes        lamimcdb
------------------------------------------------------------------------------------------------------- 
 
Copying  plug-ins 
. . . . .  . . . . 
 
***  Checking Best Practice Recommendations (PASS/WARNING/FAIL) *** 
 
Collections  and audit checks log file is
/u01/discos/orachk/orachk_ora12c_lamimcdb_090616_140408/log/orachk.log 
 
Checking  for prompts in /home/oracle/.bash_profile on ora12c for oracle user...
 
. . 
============================================================= 
                     Node  name - ora12c
============================================================= 
. . . . . 
Collecting  - Database Parameters for lamimcdb database
Collecting  - Database Undocumented Parameters for lamimcdb database
Collecting  - RDBMS Feature Usage for lamimcdb database
Collecting  - CPU Information 
Collecting  - DiskMount Information 
Collecting  - Kernel parameters 
Collecting  - Maximum number of semaphore sets on system
Collecting  - Maximum number of semaphores on system
Collecting  - Maximum number of semaphores per semaphore set
Collecting  - Memory Information 
Collecting  - OS Packages 
Collecting  - Operating system release information and kernel version
Collecting  - Patches for RDBMS Home
Collecting  - Table of file system defaults
Collecting  - number of semaphore operations per semop system call
 
 
Data  collections completed. Checking best practices on ora12c.
-------------------------------------------------------------------------------------- 
 
WARNING => DBRM is not  configured.  for lamimcdb
WARNING  => Linux Swap Configuration does NOT meet Recommendation
WARNING  => physical memory is not sufficient
WARNING  => free physical memory is not at sufficient level on system
INFO  =>    Important Storage Minimum Requirements for Grid  & Database Homes
INFO  =>    Most recent ADR incidents for /orabin/app/oracle//product/12.1.0.2/db_1
WARNING  => PGA allocation for all databases is more than total memory available  on this system
INFO  =>    Oracle GoldenGate failure prevention best practices 
INFO  =>    At some times checkpoints are not  being  completed for lamimcdb
WARNING  => OSWatcher is not running as is recommended.
FAIL  =>    Database parameter DB_BLOCK_CHECKSUM is NOT set to recommended value on lamimcdb instance
FAIL  =>    Database parameter DB_LOST_WRITE_PROTECT is NOT set to recommended value on lamimcdb instance
INFO  =>    umask for RDBMS owner is not set to 0022
WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value for lamimcdb
INFO  =>    Operational Best Practices 
INFO  =>    Database Consolidation Best Practices
INFO  =>    Computer failure prevention best practices 
INFO  =>    Data corruption prevention best practices 
INFO  =>    Logical corruption prevention best practices 
INFO  =>    Database/Cluster/Site failure prevention best  practices 
INFO  =>    Client failover operational best practices 
WARNING  => Duplicate objects were found in the SYS and SYSTEM schemas for lamimcdb
WARNING  => Oracle clusterware is not being used
WARNING  => RAC Application Cluster is not being used for database high availability on lamimcdb instance
WARNING  => DISK_ASYNCH_IO is NOT set to recommended value for  lamimcdb
FAIL  =>    Flashback on PRIMARY is not configured for lamimcdb
INFO  =>    Database failure prevention best practices
WARNING  => fast_start_mttr_target has NOT been changed from default on lamimcdb instance
FAIL  =>    Primary database is NOT protected with Data Guard (standby database) 
for  real-time  data  protection and availability for lamimcdb
FAIL  =>    Active Data Guard is not configured for lamimcdb
INFO  =>    Oracle recovery manager(rman) best practices 
INFO  =>    Consider increasing the COREDUMPSIZE size 
WARNING  => Consider increasing the value of the session_cached_cursors  database parameter for lamimcdb
WARNING  => Consider investigating the frequency of SGA resize operations 
and take corrective action forlamimcdb
 
Best  Practice checking completed.Checking recommended patches on ora12c.
--------------------------------------------------------------------------------- 
 
Collecting  patch inventory on ORACLE_HOME  /orabin/app/oracle//product/12.1.0.2/db_1
--------------------------------------------------------------------------------- 
 
--------------------------------------------------------------------------------- 
1  Recommended RDBMS patches for 121020 from /orabin/app/oracle//product/12.1.0.2/db_1  on ora12c
--------------------------------------------------------------------------------- 
Patch#    RDBMS    ASM      type                 Patch-Description 
--------------------------------------------------------------------------------- 
22291127  no                merge                DATABASE PATCH SET UPDATE 12.1.0.2.160419
--------------------------------------------------------------------------------- 
--------------------------------------------------------------------------------- 
 
--------------------------------------------------------------------------------- 
               RDBMS  homes patches summary report 
--------------------------------------------------------------------------------- 
Total  patches  Applied on RDBMS Applied on ASM ORACLE_HOME
--------------------------------------------------------------------------------- 
1               0                0              /orabin/app/oracle//product/12.1.0.2/db_1 
--------------------------------------------------------------------------------- 
 
--------------------------------------------------------------------------------- 
 
Detailed report (html) -  /u01/discos/orachk/orachk_ora12c_lamimcdb_090616_140408/
orachk_ora12c_lamimcdb_090616_140408.html 
UPLOAD(if  required) - /u01/discos/orachk/orachk_ora12c_lamimcdb_090616_140408.zip 
Banco=lamimcdb->

Ao término da execução, será criado no diretório raiz do ORAchk um novo diretório (orachk_ora12c_lamimcdb_090616_140408) com o relatório html do ambiente, que acabou de ser gerado. Também será realizada uma copia compactada (orachk_ora12c_lamimcdb_090616_140408.zip) deste diretório que pode ser utilizada em alguma SR da Oracle.

Abaixo estarei compartilhando algumas imagens do report gerado pelo orachk em meu ambiente de testes.

ORACHK



Jhonata Euclides Lamim, MBA em Gestão de Banco de Dados Oracle pelo Centro Universitário de Araraquara (UNIARA), Bacharel em Sistemas de Informação pelo Centro Universitário de Brusque (UNIFEBE). Atua como DBA Oracle desde 2010, pela Teiko Soluções em Tecnologia da Informação. É um entusiasta da tecnologia Oracle e autor do blog lamimdba.com.br.

Este artigo foi revisto pela equipe de produtos Oracle e está em conformidade com as normas e práticas para o uso de produtos Oracle.