I am now trying to log in to the database as both SYS and SYSTEM and I am getting a 1031 error, "invalid username...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
or password." Is there another way for me to log in to the database? What happened to my SYS and SYSTEM usernames?
sqlplus /nolog connect / as sysdba
You will now be able to change your SYS and SYSTEM passwords using the ALTER USER command:
ALTER USER sys IDENTIFIED BY foobar;
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.