There are 3 commonly used norms in multi-variable calculus:
|ai+ bj+ ck|= \sqrt{a^2+ b^2+ c^2}
|ai+ bj+ ck|= |a|+ |b|+ |c|
|ai+ bj+ ck|= max(|a|,|b|,|c|).
If you look at the set of vectors that have norm equal to, say, 1, the first (standard) norm gives the surface of a sphere. The second norm gives the surface of "diamond" formed of two pyramids. The third norm gives the surface of cube. All "neighborhoods" of points using those norms are of those forms.
You then define a set to be "open" if around every point in the set you can find a neighborhood of the point that is completely in the set. But it is easy to show that given anyone of the different kinds of neighborhoods (different norms) you can find either of the other kinds of neighborhoods inside it. That means that if a set is open using one kind of norm, it is open using the other kinds also. Although "neighborhoods" are different, the open sets, and therefore all limit properties are exactly the same.
HOWEVER, it is possible to choose unusual norms where that is not true. For example, the "discrete" norm is defined by : "the norm of the zero vector is 0, the norm of any non-zero vector is 1". In that case, every set, including singleton sets, is open with the result that no sequence converges. Of course, that norm is useful only for making up strange examples!
Your use of "L2" made me think first of "square integrable functions": the norm there is ||f(x)||= \sqrt{\int f(x)^2dx} where the integration is over some given set.
We also often use "L1" where ||f(x)||= \int |f(x)|dx. However, in those situations, the two sets of functions are not the same. functions for which the square is integrable are not in general functions whose absolute value is integrable. Limits may be quite different in those two sets.
And, of course, there is the "uniform norm": If f(x) is a continuous function on a compact set, define the norm to be ||f(x)||= max |f(x)| where the max is taken over the entire set. That is called the "uniform" norm because convergence of a sequence of functions in that norm is uniform convergence.