When Oracle Database cannot create session, user sometime can execute SQL*Plus with normal credential. But it didn’t return the usual SQL*Plus prompt after it. When the user check the sessions, the oracle background processes are still running.
There prefered solution for this problem is login with parameter -prelim as:
sqlplus -prelim "/ as sysdba"
and then execute shutdown command and restart the Oracle database.