You had asked for theories that do not have a categorical second-order completion, but here is an answer to the dual question:
Theorem. Every consistent first order theory $T$ with an infinite model has a second-order completion that is not categorical.
Proof. Consider all the models of $T$. By the Lowenheim-Skolem theorem, there are such models of every infinite cardinality above the size of the language. For any such model $M\models T$, consider the second order theory $\text{Th}_2(M)$ of this model. Since there are a proper class of models $M$, but only a set of possible second-order theories, it follows by the infinitary pigeon-hole principle that there must be two models $M$ and $N$ of $T$ with the same second-order theory $\bar T=\text{Th}_2(M)$. Indeed, there must be such a theory $\bar T$ with a proper class of distinct models. Thus, $\bar T$ is a second-order completion of $T$, but not categorical because it has non-isomorphic models. QED
The move from PA to the second-order Peano theory is not really one of deduction so much as family resemblence---we choose the second-order Peano theory, which is categorical, because it is true in the intended model we had in mind for the first theory. But my argument above shows that we might have chosen differently, and arrived at a non-categorical second-order completion of PA or even of TA = True Arithmetic (first-order).
Meanwhile, if you are willing to expand the language to include an order relation, then indeed one can always find a categorical second-order completion.
Theorem Every consistent theory $T$ with a countable model has a second-order completion $\bar T$, in an expansion of the language by an order relation, such that $\bar T$ is categorical.
Proof. Suppose $M$ is a countable model of $T$. Let $\lt$ be an order relation on $M$ with order type $\omega$, or finite if $M$ is finite, and let $\bar T$ be the second-order theory of $\langle M,\lt\rangle$. Note that every element of $M$ is definable in $\langle M,\lt\rangle$, and further by the categoricity of second-order Peano, all models of $\bar T$ come equipped with an order $\lt$ of order type $\omega$ (or finite if $M$ is finite), and this provides an isomorphism of that model to $\langle M,\lt\rangle$. So $\bar T$ is categorical as a second-order theory. QED
Update. Here is an example perhaps along the lines you want. The ZFC axioms of set theory are first order, but have a second-order analogue ZFC2 which is obtained in much the same way as your move from PA to second-order PA, namely, we replace the first-order schemes of ZFC, such as the replacement axiom scheme, with the natural second-order counterpart. Now, Zermelo famously proved that the models of ZFC2 are precisely the models of the form $\langle V_\kappa,{\in}\rangle$, where $\kappa$ is an inaccessible cardinal. If there are at least two inaccessible cardinals, then ZFC2 is not categorical, since these models disagree with each other on the number of inaccessible cardinals. But if there is only one inaccessible cardinal, then ZFC2 IS categorical. So in the case of ZFC, the answer to your question is that it depends on the large cardinal background.