Let's first get our definitions straight:
The following is a partial or finite sum:
$$s_n=\sum_{k=1}^na_k.$$
We call the infinite series (or infinite sum) $\sum_{k=1}^∞a_k$ convergent with limit $s_∞$, if its sequence of partial sums converges:
$$s_n=\sum_{k=1}^na_k → s_∞\qquad (n→∞).$$
The Cauchy-criterion for sequences states, that an infinite sum is convergent if for all $ε>0$ there exists a $n_ε∈ℕ$, such that for all $n>m≥n_ε$ it holds:
$$|s_n-s_m|=\left|\sum_{k=m+1}^na_k\right|<ε.$$
The first infinite series you stated is
$$\sum_{k=1}^∞\frac{1}{k},$$
the so called harmonic series.
For this series it holds
$$s_{2m}-s_m = \sum_{k=m+1}^{2m} \frac{1}{k} = \frac{1}{m+1} + …+\frac{1}{2m} > \underbrace{\frac{1}{2m}+…+\frac{1}{2m}}_{m \text{ times}} = \frac{1}{2}.$$
Hence the Cauchy criterion is not fulfilled and the series is not convergent.
The second infinite sum is $$\sum_{k=1}^∞\frac{1}{k^2}.$$
That sum is convergent, but we need the following lemma to help us proof that.
Lemma: Given two series $s_∞=\sum a_k$ and $s_∞'=\sum a_k'$, if for almost all $k∈ℕ$ it holds $$|a_k|≤κa_k',$$
with some constant $κ$, then the absolute convergence of $s_∞'$ ensures the convergence of $s_∞$.
Now we can use that. It is
$$\frac{1}{k^2} = \frac{1}{k(k+1)} + \frac{1}{k^2(k+1)} ≤ \frac{2}{k(k+1)}.$$
And it holds:
$$\sum_{k=1}^n \frac{1}{k(k+1)} = \sum_{k=1}^n[\frac{1}{k}-\frac{1}{k+1}] = 1 - \frac{1}{n+1}$$
Hence $$\sum_{k=1}^n\frac{1}{k(k+1)} → 1\qquad (n→∞),$$
und thus $\sum_{k=1}^∞\frac{1}{k^2}$ is convergent.
Can a convergent sequence have no real limit ?
The answer is no. One of the ways real numbers can be described is by construction from Cauchy sequences. (see here)
The motivation for that construction is, that convergent sequences with elements in $ℚ$ not necessarily have their limit in $ℚ$.
By the construction $ℝ$ is the completion of $ℚ$. That means every Cauchy sequence (with elements in $ℝ$) converges in $ℝ$.