Capacitively coupled nitrogen plasma discharges driven by two different exciting radio frequencies of 13.56 MHz, and 40 MHz are investigated. Langmuir probe diagnostics along with optical emission spectroscopy are used for interpreting the discharges. The results of these diagnostics are not shown sufficiently in the literature for 40 MHz even though there are some for 13.56 MHz. The electron density ne and the effective electron temperature T-eff are calculated from the measurements of the current - voltage characteristics of the discharges. These calculated parameters are correlated with the vibrational temperatures of the N-2 second positive system (c(3)Pi(u) - B-3 Pi(g)) and the N-2(+) first negative system (B-2 Sigma(+)(u) - X-2 Sigma(+)(g)) measured via optical emission spectroscopy. The population of the vibrational excitation particles plays a crucial role in the determination of the vibrational temperature which strongly depends on n(e) and T-eff. The transition from collisionless stochastic heating mode to collisional Ohmic heating mode into the bulk plasma appears at lower pressure value for 40 MHz as compared to 13.56 MHz. This effect is observed effectively with increasing the RF input power due to the high energy electrons. It is noted that the vibrational temperatures of N-2 and N2+ decreases at high-pressure region (>0.3 Torr for 13.56 MHz and >0.2 Torr for 40 MHz) due to a reduction in the relative population of the vibrationally excited particle. The measurements of the Langmuir probe are very consistent with the results of the optical emission spectroscopy. (C) 2019 Author(s). All article content, except where otherwise noted, is licensed under a Creative Commons Attribution (CC BY) license (http://creativecommons.org/licenses/by/4.0/).