Oracle Solution for Error ora-09946

Solution for Oracle Error ORA-09946

ORA-09946: File name too long for buffer

What triggered 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.

What should we do to fix it:

Use a shorter file name.