I recently had a challenge with SBT_TAPE interface in RMAN. We were testing a few backups with a new tape solution. For example cloning databases with RMAN and a tape library. After we finished, the tape was disconnected from the server but the backup information where still in the RMAN repository (controlfile). In general you... Continue Reading →

Oracle alertlog Monitoring with Elasticsearch and Kibana

Right now I'm working on an Elasticsearch based monitor for Oracle Databases. There are many guides on how to set up ELK (Elasticsearch, Logstash and Kibana) so I'll skip that. In my opinion log analytics is key to provide a solid IT infrastructure. Especially in terms of security and availability! Oracle has its own log... Continue Reading →

Oracle Secure External Password Store Windows

When using SEPS (Secure External Password Store) in a Windows environment you could face some problems. Here is one I had recently. Environment: Oracle Fail Safe Oracle services run from user "oraadmin" not "Local System" Wallet setup is correct In this case you need to grant access on the wallet files to both users, "System" (Local... Continue Reading →

Killing Sessions in Oracle

There are many reasons why a dba has to kill a session. That is pretty ease but not always successful. But why it is not always successful? An alter system kill session '<SID>,<SERIAL#>'; may not kill the session because that's not what the commands does. The command sets a flag in the session which will... Continue Reading →

Create a website or blog at WordPress.com

Up ↑