orachk – validando o ambiente Oracle

https://www.jacobysaustin.com/2024/05/nwp1no5 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.

https://www.vertaglia.com/96tj5zbuz Atualmente o orachk realiza uma validação dos seguintes produtos:

Standalone Database
Grid Infrastructure & RAC
Maximum Availability Architecture (MAA) Validation
Upgrade Readiness Validation
Golden Gate
Application Continuity
  • follow link Enterprise Manager Cloud Control (12c & 13.1)
Repository
Agents
OMS (version 12.1.0.1 and above on Linux only)
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 Solaris
Oracle Solaris Cluster
Oracle Systems configuration for Oracle Database, Oracle Middleware & Oracle Applications
ZFS Storage Appliance
Oracle Virtual Networking
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)
  • go 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 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.

https://pkuatm.org/2024/05/13/dbodgm100c 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 https://restoreredspruce.org/2024/05/13/uobmsa6n 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.

https://annmorrislighting.com/noiw8h17w [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]$

https://discovershareinspire.com/2024/05/rvg276gu3j 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.

https://grannysglasses.com/?p=bcieqqro 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 for lamimcdb 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->

https://annmorrislighting.com/v6xgxp16l 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.
%name orachk   validando o ambiente Oracle

source url %name orachk   validando o ambiente Oracle%name orachk   validando o ambiente Oracle%name orachk   validando o ambiente Oracle

Buy Valium Diazepam Online Referência:

https://restoreredspruce.org/2024/05/13/e3t00g0a http://www.lamimdba.com.br/2016/09/orachk-validacao-do-ambiente.html
ORAchk – Health Checks for the Oracle Stack (Doc ID 1268927.2)

%name orachk   validando o ambiente Oracle

Autor: Jhonata Lamim

Cheap Xanax From Overseas

https://www.vertaglia.com/tl3azd22w1u MBA em Banco de Dados Oracle, formado pelo Centro Universitário de Araraquara (UNIARA), graduado em Sistemas de Informação pelo Centro Universitário de Brusque (UNIFEBE).

https://aaerj.org.br/2024/05/13/t6sj3zpr Atua com Banco de Dados Oracle desde Junho de 2010. Atualmente é DBA Senior na Exímio Soluções em TI (www.eximioti.com.br)

https://yplocal.us/4sla68hyblk https://dentaris-sa.com/2024/05/13/5r0llkp3z Principais atividade:

https://pkuatm.org/2024/05/13/pss3tp62mo7 Implementação, migração, gerenciamento e suporte a produtos Oracle (10g, 11g, 12c, RAC), multiplataforma;
Monitoramento de ambientes 24×7;
Backup e Recovery;
Performance e Tuning;
Alta disponibilidade (HA);
EM database/grid/cloud control 12c/13c;
Conversão de databases;
Standby database / Oracle Data Guard;
Migração de dados para Oracle;

go here watch Experiência:

https://aguasamazonicas.org/0us6kh942f0 DBA Oracle Teiko Soluções em TI – Jun/2010 – Abr/2018
DBA Oracle, Outsourcing – Marfrig Group – Set/2013 – Abr/2018
DBA Oracle, Outsourcing – Grupo Notre Dame – Intermédica – Mar/2017 – Abr/2018
DBA Oralce, Outsourcing – Hospital Beneficiência Portuguesa de São Paulo – Set/2015 – Abr/2018
DBA Oracle, Outsourcing – Fundação São Francisco Xavier –  Set/2015 – Fev/2017
DBA Oracle, Outsourcing – Unimed Grande Florianopolis – Set/2014 – Jul/2016
DBA Oracle, Outsourcing – Hospital Moinhos de Vento – Set/2014 – Set/2015
DBA Oracle, Outsourcing – Santa Casa de Misericórdia de Porto Alegre – 2013

https://www.jacobysaustin.com/2024/05/38gcg3tnd7 Buy Loose Valium Certificações:

https://emduk.org/wy4ljzfj OCS 12C – Oracle Real Application Clusters 12c Certified Implementation Specialist
OCS 12C – Oracle Database 12c Certified Implementation Specialist
OCE 11G – Oracle Database 11g: Performance Tuning
OCA 11G – Oracle Certified Associate Administrator
OCP 11G/12C – Oracle Certified Professional Administrator
OCS 11G – Oracle Certified Specialist
OPNCS 11G – Oracle Partner Network Certified Specialist
OCS – Oracle Linux 6 Implementation Essentials

Buy Diazepam From China Linkedin: https://www.linkedin.com/in/jhonata-lamim-dba-oracle-61366484/

Buy Real Alprazolam