head over to the blog of dbi services to read the full article:
Installing and patching Oracle GoldenGate 12c to the latest release
Archives For Uncategorized
there is a nice link on planet.postgres.org to a picture showing the oracle architecture in a funny way
Thanks to Dinesh Kumar for spending work on this…
similar to tree there is a command to show all the mounts in a nice tree like output: findmnt
findmnt
TARGET SOURCE
/ /dev/disk/by-uuid/cb51d0c9-6cde-49c9-ae17-2ca37ecc2f7f
├─/sys sysfs
│ ├─/sys/fs/cgroup
│ │ └─/sys/fs/cgroup/systemd systemd
│ ├─/sys/fs/fuse/connections
│ ├─/sys/kernel/debug
│ ├─/sys/kernel/security
│ └─/sys/fs/pstore
├─/proc proc
│ └─/proc/sys/fs/binfmt_misc binfmt_misc
├─/dev udev
│ └─/dev/pts devpts
└─/run tmpfs
├─/run/lock
├─/run/shm
└─/run/user
└─/run/user/1000/gvfs gvfsd-fuse
Note: I omitted the last to columns to allow the output to fit on screen.
a question which pops up regulary is how one can find out which psu is installed on an oracle database. there are at least two possibilities.
if you have access to the server use opatch:
$ORACLE_HOME/OPatch/opatch lsinventory | grep "Database Patch Set Update" Patch description: "Database Patch Set Update : 11.2.0.2.8 (14275621)" Sub-patch 13923804; "Database Patch Set Update : 11.2.0.2.7 (13923804)" Sub-patch 13696224; "Database Patch Set Update : 11.2.0.2.6 (13696224)"
if you don’t have access to the server but can connect as sys:
col comments for a60 col version for a30 set lines 264 select version,comments from registry$history where comments like '%PSU%'; VERSION COMMENTS ------------------------------ ------------------ 11.2.0.2 PSU 11.2.0.2.3 11.2.0.2 PSU 11.2.0.2.4 11.2.0.2 PSU 11.2.0.2.8
you may even check if the database was upgraded from a previous release:
select version,comments from registry$history where comments like '%Upgraded%'; VERSION COMMENTS ------------------------------ ------------------------ 11.2.0.3.0 Upgraded from 11.2.0.2.0
because of all the news currently around ( although this is not really new and surprising ) I thought it might be worth to bring this up again:
Daniel Westermann's Blog 