Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Cannot login to isqlplus

 
Peter Fischer
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 166
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic