File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes Cannot login to isqlplus Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Cannot login to isqlplus" Watch "Cannot login to isqlplus" New topic

Cannot login to isqlplus

Peter Fischer

Joined: Oct 03, 2004
Posts: 1
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

Joined: Feb 18, 2003
Posts: 166
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.

Jeremy Wilson
I agree. Here's the link:
subject: Cannot login to isqlplus
It's not a secret anymore!