This discussion is archived
1 2 Previous Next 21 Replies Latest reply: Jan 23, 2013 4:21 AM by Harsh_v RSS

Can not able to log in into sys as sysdba

piku Newbie
Currently Being Moderated
Hi all,

I have one instance name is skydb and once upon a time i used it when i created it.i did set one password for the sys user and created password file.but right now i have forgot the password of sys.again creating the password file using below command.
 orapwd file=orapwdskydb password=oracle entries=10
but can not able to log in into sys as sysdba using this 'oracle' password .

for your information now the database is down.we also need to up it.

please help.
thanks a lot in advance.

atanu
  • 1. Re: Can not able to log in into sys as sysdba
    sb92075 Guru
    Currently Being Moderated
    piku wrote:
    Hi all,

    I have one instance name is skydb and once upon a time i used it when i created it.i did set one password for the sys user and created password file.but right now i have forgot the password of sys.again creating the password file using below command.
     orapwd file=orapwdskydb password=oracle entries=10
    but can not able to log in into sys as sysdba using this 'oracle' password .

    for your information now the database is down.we also need to up it.

    please help.
    thanks a lot in advance.

    atanu
    do EXACTLY as below

    sqlplus
    / as sysdba
  • 2. Re: Can not able to log in into sys as sysdba
    Catfive Lander Explorer
    Currently Being Moderated
    An operating system would be nice to know.
    Also confirmation that your ORACLE_SID is set to "skydb"
    And that you created the password file in the correct location (which depends on the answer to the first point)

    Additionally, you should be able to do a password-less SYS connection directly on the server itself. (i.e, connect / as sysdba) if your OS user is a member of the DBA group.
  • 3. Re: Can not able to log in into sys as sysdba
    Niket Kumar Pro
    Currently Being Moderated
    AS sb suggested.....

    first check oracle service for database skydb is running in windows from services.msc

    cmd>set ORACLE_SID=skydb
    cmd>sqlplus / as sysdba
    sql>startup
    sql>alter user sys identified by password;



    you can change sys user password using alter user command as stated above....
  • 4. Re: Can not able to log in into sys as sysdba
    Catfive Lander Explorer
    Currently Being Moderated
    How do you know he's running on Windows?

    Both you and sb are wrong, too, in just saying '/ as sysdba' will fix it. If our user was a member of the ORA_DBA or DBA group, then sqlplus "sadjhdjkf/djfhskjfhksdj as sysdba" would work regardless of what password has been set in the password file. Conversely, if he's NOT a member of the ORA_DBA or DBA group, then trying to "connect / as sysdba" isn't going to work.

    So we can deduce he's using an OS account that isn't privileged. Perhaps because he's connecting remotely. But either way, that will require the use of a proper SYS password at connection time.
    Meaning we can't just fob him off with "try typing "sqlplus / as sysdba exactly", because that's not going to work.
  • 5. Re: Can not able to log in into sys as sysdba
    Niket Kumar Pro
    Currently Being Moderated
    hey catfive.....

    he don't know how to login into oracle database so I Assume he will not be on NIX system.....lets wait for op reply if he get any error we will give NIX way also...... :-)
  • 6. Re: Can not able to log in into sys as sysdba
    Catfive Lander Explorer
    Currently Being Moderated
    Bad assumption to make on flimsy grounds, I think.

    But that still doesn't make telling him "use / as sysdba" any better, because that obviously cannot work in his situation, whatever OS he turns out to be on. If he's getting an error using "oracle" as the password, then he's not a member of an OS privileged group. Therefore, he **can't** use "/ as sysdba".

    Which is why I was careful to say that he could try "/ as sysdba" if he was directly connected to the database server AND that he was a member of the OS privileged group. Without those caveats, your advice (and sb's) was simply wrong.
  • 7. Re: Can not able to log in into sys as sysdba
    Niket Kumar Pro
    Currently Being Moderated
    I'm sorry catfive....I will ask OS before giving advice.....thanks for reminding .....

    I am using / as sysdba always at home....as op said he has install it so he will automatically became member of ORA_DBA group....
  • 8. Re: Can not able to log in into sys as sysdba
    piku Newbie
    Currently Being Moderated
    Hi All,

    first of all thaks a lot for your promt reply.now for your information my os info is
    Linux oracleDB11g 2.6.32-71.el6.i686 #1 SMP Fri Nov 12 04:17:17 GMT 2010 i686 i686 i386 GNU/Linux
    my account user is in DBA group and its confirm.
    now am giving the output of the
    each command
    [oracle@oracleDB11g admin]$ sqlplus / as sysdba
    
    SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 23 11:04:25 2013
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    ERROR:
    ORA-01031: insufficient privileges
    and
    [oracle@oracleDB11g admin]$ sqlplus /nolog
    
    SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 23 11:05:59 2013
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    SQL> connect / as sysdba
    ERROR:
    ORA-01031: insufficient privileges
    also want to tell you I have created that password file on location is
    /oracle/app/oracle/product/11.2.0/dbhome_1/dbs
    thanks once again
    atanu
  • 9. Re: Can not able to log in into sys as sysdba
    ora_tech Expert
    Currently Being Moderated
    Hi,

    Please check proper ORACLE_SID is set and password file contains valid SID name.

    thanks,
    X A H E E R
  • 10. Re: Can not able to log in into sys as sysdba
    Niket Kumar Pro
    Currently Being Moderated
    paste output for

    ps -ef|grep pmon
  • 11. Re: Can not able to log in into sys as sysdba
    asahide Expert
    Currently Being Moderated
    Hi,

    Could you show us output of "env" command?
    Check ORACLE_SID parameter.

    And also check follows.
    cd $ORACLE_HOME/rdbms/lib
    cat config.c
    regards,
  • 12. Re: Can not able to log in into sys as sysdba
    piku Newbie
    Currently Being Moderated
    FYI
    [oracle@oracleDB11g dbs]$ export ORACLE_SID=skydb
    [oracle@oracleDB11g dbs]$ echo $ORACLE_SID
    skydb
    [oracle@oracleDB11g dbs]$ sqlplus / as sysdba
    
    SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 23 11:25:32 2013
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    ERROR:
    ORA-01031: insufficient privileges
    
    [oracle@oracleDB11g dbs]$ ps -ef|grep pmon
    oracle    3082  2915  0 11:25 pts/1    00:00:00 grep pmon
  • 13. Re: Can not able to log in into sys as sysdba
    633234 Newbie
    Currently Being Moderated
    Hi,

    Can you please post output of "id" command? and group permission given to Oracle user?

    Regards,
    Amit.
  • 14. Re: Can not able to log in into sys as sysdba
    Niket Kumar Pro
    Currently Being Moderated
    your database is not running.....
    as you can see from pmon command....
    check permissions for insufficient privileges....
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points