Menu
(Move to ...)
Administrator Desk
Postgresql Desk
SQL Server Desk
Data Engineering
mySQL
Learning Python
Links
▼
Oracle Pages
(Move to ...)
Home
Oracle 12C: Moving schema from Oracle 11G to 12C.
Oracle 12C: drop user and drop tablespace
Oracle 12C: Where is my Oracle 12C OEM ??
Oracle 12C: creating pluggable database
Oracle 12C: user creation behaviors
Oracle 12C: Pluggable database will not start in opened mode by default
Oracle 12C: Enabling and disabling ddl logging in ...
Oracle 12: Invisible Column
Oracle 12C: Opening up pluggable PDB from root all...
Oracle 12C: Invisible index
Oracle 12C: UNDO tablespace on PDB
Oracle 12C: Temporal Validity
ORacle 12C: Row Archival (full experiment)
Oracle Tool: setup OSWatcher
Oracle Tool: RDA Setup
Oracle Tool: adrci setup
Oracle Tool: ORAchk setup
Oracle Tool: runcluvfy
Oracle Tool: Trace File Analyzer (TFA) & ORAchk/EXAchk
Oracle Tool: Oracle Linux SosReport (need login)
Oracle 12C Posters
Oracle 11g Database Administrator's Guide
Database 2 Day + Performance Tuning Guide
Oracle Explain Plan explained
Oracle AWR White Paper
Oracle Performance and Tuning Guide
Golden Gate Performance Tuning White Paper
Oracle Database SQL Tuning Guide
Oracle 12C Database Data Warehouse Guide
Oracle RAC cssd timeout
Tools for Oracle Data Corruptions
Oracle 19C Architecture
Oracle Memory Structure
▼
Oracle Scripts
(Move to ...)
Oracle: db locks with session and serial
Oracle: Allocating waste space
Oracle: Analyzing UNDO Tablespace
Oracle: Analyzing Tempspace usage
Oracle: Scripts to track Oracle DB locks
Oracle: objects that locked up.
Oracle: Monitoring redolog switching
Python: using simply python script to test Oracle ...
Oracle: disk reads
Oracle: enable, disable and removing jobs
Oracle: ASMM for Oracle 10g, 11g and 12c
Oracle: Rebuilding unusable index
Oracle: Script to track RMAN recovery and other lo...
Oracle: Basic RAC check
Oracle: Searching a record within schema
Oracle script: Rebuild bloated indexes for vCenter...
▼
Oracle Tool: ORAchk setup
Download ORAchk Oracle Metalink. ORAchk - Health Checks for the Oracle Stack (Doc ID 1268927.2) Ideally, download the tool and set it asides as it will extract bunch of files and you do not want to mix up with other existing and unrelated files. The rest really straightforward. [oracle@Cloud3 oracle]$ mkdir orachk [oracle@Cloud3 oracle]$ mv orachk.zip orachk [oracle@Cloud3 orachk]$ unzip orachk.zip Archive: orachk.zip inflating: readme.txt inflating: UserGuide.txt inflating: rules.dat inflating: user_defined_checks.xsd [oracle@Cloud3 orachk]$ ./orachk List of running databases 1. orcl 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]. orcl That's it!
No comments:
Post a Comment