I have been thinking about how different an eigenvalue problem such as that of the Sturm-Liouville Equation (SL) with that of a second-order linear differential equation. It doesn't seem to be the case to be the difference between a boundary value problem vs. an initial value problem, as we may also have BVPs that do not involve eigenvalues, in which case solutions might not exist in abundance as opposed to the case with IVPs. Perhaps, the eigenvalue parameter is there to allow us to speak of to which values of the parameter there exist a solution.
However, that brought me to the question as to what happens when no boundary values are imposed, such as in the case of the famous Simple Harmonic Oscillator (SHO) SL problem in Quantum Mechanics (QM), where the wavefunction, i.e. the solution of the "eigenvalue" problem, is defined throughout the entire real line without any restriction - except for the fact that they approach the $x$-axis asymptotically, which actually follows from square-integrability. I put the word "eigenvalue" in quotation marks because I am now questioning it. Let me explain.
The SHO problem is the seeking of the solution $\psi$ to the "eigenvalue" problem $\displaystyle-\frac{\hbar^2}{2m}\frac{d^2\psi}{dx^2}+\frac{1}{2}m\omega^2x^2\psi=E\psi$. We can clean up the equation by absorbing constants, but we will keep them. It is well-known in QM that solutions to this eigenvalue problem are products of Hermite polynomials with a Gaussian and the eigenvalues $E$ form a discrete set and are given by $E_n=\left(n+\frac{1}{2}\right)\hbar\omega$. Note that no boundary conditions are imposed although, of course, we are seeking for square-integrable functions. Herein lies the question:
If we rewrite the SHO equation as $\displaystyle-\frac{\hbar^2}{2m}\frac{d^2\psi}{dx^2}+\left(\frac{1}{2}m\omega^2x^2-E\right)\psi=0$, it does look to me like a legit 2nd order variable-coefficient linear ODE that has a solution for any $E$. Specifically, $E$ does not have to assume specific values that form a discrete set.
What am I missing here? That not all $E$s give square-integrable solutions? How is the SHO an eigenvalue problem and not a mundane differential equation problem?
Appreciate your insights.
Your problem has always the zero function as solution. So the real question to ask is how to get solutions apart from that. So in effect you are asking for a singular situation that only isolated values of $E$ will satisfy.
You can transform this into an ordinary boundary value problem by
(zeroth reducing the infinite interval to some finite interval $[x_0,x_2]$)
first adding $E$ as component with equation $\frac{dE}{dx}=0$, and
then add the square integral as fourth component with equation $\frac{dI(x)}{dx}=|ψ(x)|^2$.
Now you have 4 state components and thus 4 slots for boundary conditions, which are $$ψ(x_0)=ψ(x_1)=0~\text{ and }~I(x_0)=0, ~~I(x_1)=1.$$
As with many BVP there will not be a unique solution, if you employ a numerical solver, the initial guess has to be close to some eigenfunction to get predictable results.