OS User role separation for Golden Gate administration...

We have many fingers in the pie where I work. Silos, silos everywhere. The DBA Group is responsible for operations and performance. ETL Admins are responsible for data movement. For a number of reasons we cannot allow the ETL Admins to log in directory as Oracle user. This is what I came up with to make everyone happy.

What is an ETL admin?

Our ETL Admins are users who do not need DBA or ROOT type access, they just need to run ggsci, start stop processes, edit config files, and check status of how things run.

The fuser unix/linux command...

I colleague turned me on to a helpful command the other night. Where I work we have an archived log based replication system. It was way behind on processing and the replication process doesn't give any indication of what log its currently chewing on. /sbin/fuser to the rescue!
  • 1) 'cd' to a directory where you want to check the files
  • 2) run '/sbin/fuser *' to discover what processes are touching files in the directory
[oracle@test /] cd /u01/app/oracle/oradata/TEST
[oracle@test TEST] ls redo*

RedHat: Using system-config-packages from a local disk instead of CD-Roms…

Helpful tip from the RedHat site if you installed the OS from Cd-Roms and want to add new packages from a disk mount...

– Dave


Automagically Graphing on Linux

So my last post was about administration on Linux. After running Oracle on Windows for way too many years we migrated our Oracle systems to 64-bit Linux over the past year.

Now that we're on Linux I needed a lightweight way to capture and graph some performance data. The performance data was a mix of OS utilities and 3rd party utilities, but all the utilities output text, so I knew I could screen scrape the output, massage it a little, and save the data to a file. After I had the data in a file I knew I could run it through GnuPlot to graph it.
Subscribe to linux