Oracle Error ORA-09946: File name too long for buffer

Oracle Error Message

ORA-09946: File name too long for buffer

Reason for the Error

The buffer that was to be used to hold a file name was determined to be too short for the generated name. This will happen if the translated name for either a trace file or an audit file is longer than the maximum allowed, which on many ports is 256 characters.

Solution

Use a shorter file name.