oracle is most likely an operating system user, while system and sys are database users. su oracle will log you into the oracle operating system user provided you know the password, so you can manage the database and related filesystems.