It is definitely situation dependent for what weapons work well in raids but not having raid weapons won't stop you at all. Going with your example of taking down oracles I have seen Murmur rip them to shreds. You have 2 people carrying murmur in oracles on hard and it seems a breeze. Things like tracking rockets work well with bosses and larger enemies like pretorians but I wouldn't be using a G-horn in the bubble shield against Atheon. Something like bad juju that regens ammo or a weapon with high rate of fire has been handy in the abyss while ice breaker is handy in a large number of cheeses, umm I mean situations. It ends up being a cross between what you feel comfortable with and the damage output of the weapon to go along with the situation really. I definitely wouldn't worry about the oracle killing or perk if I was ever building a raid team though. Plus if you're playing with a group of DoD'ers then most won't be too fussed anyway.