This discussion is archived
1 2 Previous Next 23 Replies Latest reply: Nov 29, 2012 3:40 AM by Niket Kumar RSS

SQLPLUS login as SYSDBA

274340 Newbie
Currently Being Moderated
Hi Guys,
When I try to login as SYS, oracle complains that I should connect as SYSDBA or SYSOPER. Fine. Now I enter the login user as SYSDBA and enter the password..it fails. However, if I login as user scott and password tiger, I can login. Then from the SQL prompt I do:
connect SYS/<password> as SYSDBA;

and it works. So my question is, when I use the same <password> as login prompt and user as SYSDBA or SYSOPER, why does that fail and how can I change to make that work directly without loggin in as some other user and then manually change to SYS.

Thanks
  • 1. Re: SQLPLUS login as SYSDBA
    MichelSALAIS Newbie
    Currently Being Moderated
    Well, in Oracle 9i you have to use :
    sqlplus "sys as sysdba"
    if you want to specify the user at the command line.
  • 2. Re: SQLPLUS login as SYSDBA
    274340 Newbie
    Currently Being Moderated
    excellent, that is what I was looking for. Thanks.
  • 3. Re: SQLPLUS login as SYSDBA
    475667 Newbie
    Currently Being Moderated
    You already solved your problem, I give you another syntax to login as sysdba

    # sqlplus "/ as sysdba"

    Bye, Aron
  • 4. Re: SQLPLUS login as SYSDBA
    Laurent Schneider Oracle ACE
    Currently Being Moderated
    in 10g, you can remove the quotes

    sqlplus / as sysdba
  • 5. Re: SQLPLUS login as SYSDBA
    274340 Newbie
    Currently Being Moderated
    On a related note, how do i connect as SYSDBA using iSQLPLUS. When I use connect SYS/<password> as SYSDBA; inside iSQLPLUS, I get this error:

    SP2-0927: CONNECT AS SYSDBA or AS SYSOPER not allowed through iSQL*Plus URL

    The same works inside SQLPLUS

    Thanks
  • 6. Re: SQLPLUS login as SYSDBA
    Laurent Schneider Oracle ACE
    Currently Being Moderated
    you must use a special screen

    http://machine_name.domain:port/isqlplus/dba

    check your sqlplus manual
  • 7. Re: SQLPLUS login as SYSDBA
    MichelSALAIS Newbie
    Currently Being Moderated
    you must use a special screen

    http://machine_name.domain:port/isqlplus/dba

    check your sqlplus manual
    Are you sure?
    I always do:
    http://machine_name.domain:port/isqlplusdba
    Note that in that case you must use htpasswd before ...
  • 8. Re: SQLPLUS login as SYSDBA
    MarGur Newbie
    Currently Being Moderated
    hi, guys!

    I've got the same problem with iSQLPlus, that sunjit had. but i can't connect through http://host:5560/isqlplus/dba, because it requests password "Realm iSQL*plus DBA". Nither sys/sysdba/sysoper/pass (database credentials) nor Administrator/pass (host crdentials) are working.

    My question is: what kind of password should I type there, and if i didn't create it, where could I assign it?

    thank you.
  • 9. Re: SQLPLUS login as SYSDBA
    220321 Newbie
    Currently Being Moderated
    For 10g, To access the isqlplus DBA url, you must set up login credentials using the Oracle JAAS provider, known as JAZN. See SQL*Plus User's guide for more details of how to setup iSQL*Plus DBA access.
  • 10. Re: SQLPLUS login as SYSDBA
    557390 Newbie
    Currently Being Moderated
    I am not finding the instructions to set up login credentials using the Oracle JAAS. Can you please post more information or a link to the online User Guide?
  • 11. Re: SQLPLUS login as SYSDBA
    Paul M. Oracle ACE
    Currently Being Moderated
  • 12. Re: SQLPLUS login as SYSDBA
    583897 Newbie
    Currently Being Moderated
    was searching through the forum and found this thread. Im kinda having the same problem. I'm using Oracle 10.2.0 on Windows XP SP2. I can connect to iSQL*Plus using just a regular login, but I cannot connect as sysdba or sysoper. It asks for a computer username/password and I tried the admin user on the local computer and the admin user on the network, neither let me proceed. I logged in as system/password and then gave the instruction sys/password as sysdba and got the following error.
    SP2-0927: CONNECT AS SYSDBA or AS SYSOPER not allowed through iSQL*Plus URL

    Why is this? I have a 9.2 client running where I connect to the DB Across town BTW.

    Oh and I don't have a Webdba role in my list of roles in my Enterprise Manager so I cannot add it to the sys user.

    Edited by: jamesH2 on Aug 29, 2008 3:50 PM
  • 13. Re: SQLPLUS login as SYSDBA
    Paul M. Oracle ACE
    Currently Being Moderated
    Did you try my link above ? I just did it on a virtual machine with XP and 10g, and it worked without problems.

    BTW, instructions are for Unix/Linux, but I hope you know what to change....
  • 14. Re: SQLPLUS login as SYSDBA
    666729 Newbie
    Currently Being Moderated
    iSQL*Plus DBA login

    When u wants to connect sys as sysdba in isqlplus then u have to type
    http://localhost:port/isqlplusdba <- Only for sysdba
    http://localhost:port/isqlplus <- Other user like scott,hr etc.

    When connect with "isqlplusdba", a promt will be show to ask u to type
    username and password. This information is generally kept in
    "$ORACLE_HOME/sqlplus/admin" location named "iplusdba.pw".

    This file is maintained by "htpasswd.exe" located in
    "$ORACLE_HOME/Apache/Apache/bin" location. So at first u have to create
    "iplusdba.pw" file same as u create oracle password by "orapwd". So do
    this step :

    1. Go to the location "$ORACLE_HOME/Apache/Apache/bin" from ur
    command promt.
    2. Type "htpasswd -c iplusdba.pw oracle". In this example iplusdba.pw
    is the name of the password file and oracle is the name of the user
    allowed to use the DBA utility. htpasswd prompts you to enter the
    password and confirm. You can see help by typing "htpasswd /?".
    3. Now "iplusdba.pw" file will be created. Copy the file and overwrite
    the file in the location ""$ORACLE_HOME/sqlplus/admin".
    4. Now just type "http://localhost:port/isqlplusdba" and when u asked
    for username and password then those username and password that u used
    to create the iplusdba.pw file.
1 2 Previous Next