A system trigger is a special database procedure performed implicitly during a restart. It is executed at a point when, though the database instance has been fully started, connections are still not possible.
See also:
SQL Reference Manual, CREATE SYSTEM TRIGGER Statement (create_system_trigger_statement)