The synergy effect in nature could enable fantastic improvement of functional properties and associated effects. The detection performance of surface-enhanced Raman scattering (SERS) can be highly strengthened under the cooperation with other factors. Here, greatly-enhanced SERS detection is realized based on rolled-up tubular nano-resonators decorated with silver nanoparticles. The synergy effect between whispering-gallery-mode (WGM) and surface plasmon leads to an extra enhancement at the order of 105 compared to non-resonant flat SERS substrates, which can be well tuned by altering the diameter of micron- and nanotubes and the excitation laser wavelengths. Such synchronous and coherent coupling between plasmonics and photonics could lead to new principle and design for various sub-wavelength optical devices, e.g. plasmonic waveguides and hyperbolic metamaterials.