- Home
-
Exadata
- - How to Patch / Upgrade Exadata
- - My Exadata patches download cheat sheet
- - Resize ASM diskgroups
- - Add extra disk space and increase FS on a VM
- - Increase the size of /EXAVMIMAGES
- - Shutdown or reboot a cell without impacting ASM
- - IB switches ILOM: status stop, start, restart
- - Switch: may the --force be with you !
- - dbnodeupdate.sh backup failed on one or more nodes
- - Make a cell or DB node blink !
- - Hack patchmgr
- - Reinstall a broken system RPM
- - X8M: dbs_group, cell_group and roce_group
- - How to install a brand new Exadata (X2 to X7)
- - How to manage OS dependencies when upgrading to 19c
- - How to re-image an Exadata database server
- - How to re-image an Exadata cell storage server
- - ExaWatcher: Manage the archives destination
- - Setting up FlashCache Mode to WriteThrough or WriteBack is an online operation
- - Increase or decrease the number of activated CPUs
- - How to extend /u01
- - Read this before creating or moving datafiles in RECO !
- - Restart SSH on a storage cell with no SSH access
- - Patching the Cisco Switch (aka Ethernet Switch)
- - patchmgr -modify_at_prereq (dbnodeupdate.sh -M)
- - How to Quickly Upgrade opatch with dcli
- - How to take an ILOM snapshot with the command line
- - How to reboot a database server using its ILOM
- - How to manually reboot an Infiniband Switch
-
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 You can also clone my git repo to get all the scripts at once
- Ansible
- Clouds
-
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
Subscribe to:
Post Comments (Atom)
Some bash tips -- 18 -- paste
This blog is part of a shell tips list which are good to know -- the whole list can be found here. I really like finding a real usage for...
-
Consolidation has been a fancy word and concept for years in IT resulting for us DBAs with more and more databases and instances running ...
-
Almost every time I connect on a new client server, I find that the Oracle logfiles are not properly and/or not totally purged which, one d...
No comments:
Post a Comment