Is it common practice to connect power supply to a DB9?
It is common, but only in systems which will never be connected to a serial port. If you do that, you get what you deserve.

Probably there is an exception in CANBus systems which are connected to a PC. Fortunately, most PCs these days don't have a serial port.