Cannot login to isqlplus

[Peter Fischer]

hi all,
when I try to login on the isqplus login screen
providing sys as user and the respective password
I get:
ORA-28009: connection to sys should be as sysdba or sysoper

I tried "sys as sysdba" + password and stuff like that...
nothing worked..can somebody tell the oracle-newbie that I am
how to pass this barrier called login screen ?
I thank you so much !

[Jeremy Wilson]

Yes, I ran into this as well. It is a security issue with oracle. They do not allow you to log into the database as user sys from over the web. The solution is very easy though. Create a different user for yourself and give yourself the dba role permission.

Create user you identified by youpassword
Grant dba to you

then logon thought isqlplus with this user.

I am using oracle 10g when I ran into this issue.