Archives For Uncategorized

head over to the blog of dbi services to read the full article:

Installing and patching Oracle GoldenGate 12c to the latest release

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.

back to the middle ages

December 20, 2013 — Leave a comment

in german:

Snowden-sollte-gehaengt-werden

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

privacy

July 12, 2013 — Leave a comment

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:

about not being tracked when searching the web