When i installed ORACLE for the first time on my PC i faced a problem of logging in. I thought to share the solution with you.
After installation when we open SQL plus, it prompts for Login Name, Password and Host String. Now the question is what are the proper inputs for those fields?
In Login Name field, we can use various inputs such as: SYSTEM, SYS, SYSMAN, DBSNMP etc used for database administer’s role. “SYSTEM” works for most cases. So first try it first.
ORACLE also gives you two normal user accounts named : SCOTT and TIGER.
Next in PASSWORD field enter the administer password you have given while installing ORACLE.
And normally Host String will be ‘ORCL’. You can customize it.
Now i hope you can login. If any problem, just drop the question in our FORUM page.