This is how it apparently started:
I ran CATPROC.SQL while logged to sqlplus as SYSTEM instead of SYS (I don't know whether this matters).
The script started to execute showing messages, then it stopped showing messages but didn't terminate (no prompt).
After, say, 10' of seeing no messages and no prompt, I broke it with Ctrl+C. Since then, I cannot log on to sqlplus anymore.
At this point, you will want to drop the objects now owned by SYSTEM that were created when you ran CATALOG. This is most likely the cause of your problem. Once that is done, rerun CATALOG. Connecting as INTERNAL is the same as connecting as SYS, so you can run the CATALOG.SQL script. This should fix your problem.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.