RAC and DataGuard tips and tools (dead link)
- Home
- Exadata
-
Scripts
- awk Tutorial An awk Tutorial - bash tips Tips to get better at Shell Scripting - asmdu.sh ASM diskgroups sizes and usage download - cell-status.sh An overview of your Exadata disks download - exa-racklayout.sh Exadata components in a Rack Layout style download - exa-versions.sh Exadata components versions in a glimpse download - list-ohpatches.sh A better Oracle patch reporting tool download - lspatches.sh [Deprecated]An Oracle patch reporting tool download - nfs-status.sh quickly check and fix NFS download - oraenv++ A powerful tool to set up your Oracle environment download - rac-mon.sh A GI monitoring tool based on rac-status.sh download - rac-on_all_db.sh Execute a SQL on all databases across a GI download - rac-status.sh A GI resources status output in a glimpse download - rac-status_rh6.sh rac-status.sh for RH6/OEL6 download - svc-failback-yes.sh failback for Oracle services download - svc-show-config.sh Show Oracle services config download - swid.sh Schedule WIth Dependencies and // download - yal.sh A dcli for non-Exadata and the Cloud download - print_table.sh A generic pretty table output function download - .ai_functions OCI Gen AI from Linux command line download You can also clone my git repo to get all the scripts at once
- Ansible
-
Clouds
- - Python venv
- - OCI: Datapump between 23ai ADB and 19c ADB using database link
- - OCI: ADB 23ai to ADB 19c Database link
- - OCI: Manual creation of a 23ai Autonomous Database
- - OCI: Database Link between 2 Autonomous Databases
- - OCI: Setting up API Keys
- - OCI: Automatic Backups Troubleshooting
- - GCP: How I beat the most modern Cloud . . .
- - AWS: Troubleshoot Oracle datapump import to AWS RDS
-
Oracle
- - Move billion of rows between partitioned tables with exchange partition
- - Load 2 billion rows with SQL Loader
- - crsctl stat res: syntax and optimization
- - Shared memory segments cleanup
- - I finally found my top Orace 12c-19c database feature !
- - Grid Infrastructure Out of Place Patching
- - A systemd service to stop/start Oracle databases
- - So you have removed a trace file and your FS is still filling (very fast)
- - Out of place rolling patching aka mitigate the DB downtime when patching like a pro
- - dbca: ORA-20001: Statistics Advisor: Invalid task name for the current user
- - srvctl add oraclehome
- - Upgrade Grid Infrastructure to 18c
- - dbca: Error in Process: /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/orapwd
- - ASM: Why you must use HIGH redundancy in production
- - Lost entries in oratab after GI 12.2 upgrade or patch
- - Efficiently purge / rotate all the Oracle logfiles
- - Upgrade Grid Infrastructure to 12.2
- - Deprecation of OPatch Command Option "-all_nodes"
- - gridSetup.sh : ERROR: The home is not clean. This home cannot be used.
- - RMAN 11g : How To Restore / Duplicate To A More Recent Patchset
- AI
- Social
-
Consolidation has been a fancy word and concept for years in IT resulting for us DBAs with more and more databases and instances running ... -
Patching is an important task in every DBA life (and we patch quite often in the Oracle world :)) and the task is fairly easy (if well prep...
No comments:
Post a Comment