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 →

SQL*Plus Tricks Vol 2

In my post "SQL*Plus Tricks Vol 1" I mentioned the feature to edit your last SQL command using your preferred editor. Here is another possibility. Trick 5 (see trick 1 to 4 in my previous post "SQL*Plus Tricks Vol 1") You can modify a specific line in your last sql command without using an editor. SQL> l... Continue Reading →

SQL*Plus Tricks Vol 1

SQL*Plus, some love it, some hate it. Let's focus on what SQL*Plus can do and leave the disadvantages aside for now. Here are some of my top tricks to get more out of SQL*Plus. Before getting into the subject, let's have a look at SQL*Plus' help command: SQL> help index Enter Help [topic] for help.... Continue Reading →

Restrict ssh sessions

It's quite simple to limit a ssh session to use specific commands only. This solution may not be bullet prove but it's suffizient in most cases. My first attempt was to use rssh but sadly this project is no longer maintained. I ran into a bug which forced me to look for a different solution. The... Continue Reading →


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 →

Generate Values in Oracle SQL

I just came across an awesome SQL which I wanted to share with you. This is a SQL query which generates a sequence of values. I often need this when generating "0" (zero) values for graphs. SQL> SELECT level FROM dual CONNECT BY level <= 7;      LEVEL ---------- 1 2 3 4 5 6... 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 →

Export Datapump: No locks available (NFS Share)

It's time for a new post, istn't it? I recently had the problem that an expdp command failed with the following message: ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31641: unable to create dump file "/backup/exp.dmp" ORA-27086: unable to lock file - already in use Linux-x86_64 Error: 37: No locks available Additional information:... Continue Reading →

Create a website or blog at

Up ↑