Is story action noun

No, there is no designation of 'action noun'. There are action verbs, as well as being verbs.

The noun 'story' is a singular, common noun.

The noun 'story' is an abstract noun as a Word for an account of something that happened that is imaginary, traditional, or true.

The noun 'story' is a concrete noun as a Word for a complete horizontal section of a building.