- 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
- - 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
Showing posts with label ACE. Show all posts
Showing posts with label ACE. Show all posts
UKOUG 2018 Speaker Awards
UKOUG 2018 Speaker awards, you may recognize someone on the 2nd top left :)
Thanks for this award UKOUG for my last year Exadata patching talk !
OOW 18 agenda revealed !
Oracle Open World 2018 agenda has been revealed !
I will be talking on Thursday, Oct 25, 12:00 p.m. - 12:45 p.m. | Moscone West - Room 3004 !
I will be talking on Thursday, Oct 25, 12:00 p.m. - 12:45 p.m. | Moscone West - Room 3004 !
Subscribe to:
Posts (Atom)
OCI: Datapump between 23ai ADB and 19c ADB using database link
Now that we know how to manually create a 23ai ADB in OCI , that we also know how to create a database link between a 23ai ADB and a 19C AD...







