Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Join Date
    Jan 2004
    Posts
    21

    Unanswered: Lost Keys to Oracle

    Somehow, I managed to "lose" the password(s) for my OEM login and can not access the server. It's a local installation. Is there a way to hack in? When the 9i server was installed, it required changing the default system & sys passwords and Oracle doesn't like any that I have tried so far.

    Please don't tell me I have to reinstall Oracle.

  2. #2
    Join Date
    Oct 2003
    Location
    Republic of Srpska, Bosnia and Herzegovina
    Posts
    35

    Login

    Login as one administrator on windows and then add this user to ORA_DBA group. Start OEM and type sys for username, and any word for password, as sysdba.

    Hope this help.

  3. #3
    Join Date
    Jan 2004
    Posts
    21
    Bato, my Windows login ID is in the ORA_DBA and Administrators group. When I start the OEM Console, I am prompted to login standalone or into the management server.

    If I choose management server, I am prompted for administrator name, password, and the server is preselected. When I enter the Windows login ID and password, then click OK, Oracle complains about my credentials.

    If I choose standalone and click on the DB name in the navigator, I get prompted for username, password, service, and connect as. When I entered my Windows login ID, password, (service is grayed out), and selected SYSDBA for connect as and clicked OK, nothing happened.

    I checked to make sure that the management server service - OracleOraHome92ManagementServer - and DB service - OracleServiceFRSDEV are started.

    Is there a way to check the integrity of the server without logging in?

  4. #4
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    I hope u have lost the password for sys. If that is the case u can recreate the password by using an utility of oracle called ORAPWD.
    But the previous password file needs to be deleted before using it.
    On the command prompt orapwd /? will give the syntax. Use it.

    Cheers,
    Kaushik

  5. #5
    Join Date
    Oct 2003
    Location
    Republic of Srpska, Bosnia and Herzegovina
    Posts
    35
    Try via sql plus:

    If user is in ora_dba group you will be able to login:

    C:\>sqlplus

    SQL*Plus: Release 9.2.0.1.0 - Production on Thu Feb 5 08:07:42 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Enter user-name: / as sysdba

    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production

    SQL>

  6. #6
    Join Date
    Oct 2003
    Location
    Republic of Srpska, Bosnia and Herzegovina
    Posts
    35
    After login you can change user:

    alter user sys identified by new_user_name

  7. #7
    Join Date
    Jan 2004
    Posts
    21
    bato, this is what happened after I typed the command 'sqlplus' at the 'c:' prompt:

    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
    With the Partitioning option
    JServer Release 9.2.0.4.0 - Production

    C:\>sqlplus

    SQL*Plus: Release 9.2.0.1.0 - Production on Fri Feb 6 08:31:20 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Enter user-name: / as sysdba
    ERROR:
    ORA-01031: insufficient privileges

    ==================================

    Originally posted by bato
    Try via sql plus:

    If user is in ora_dba group you will be able to login:

    C:\>sqlplus

    SQL*Plus: Release 9.2.0.1.0 - Production on Thu Feb 5 08:07:42 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Enter user-name: / as sysdba

    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production

    SQL>

  8. #8
    Join Date
    Jan 2004
    Posts
    21
    Kaushik, what's the name of the password file?


    Originally posted by kausik_m123
    I hope u have lost the password for sys. If that is the case u can recreate the password by using an utility of oracle called ORAPWD.
    But the previous password file needs to be deleted before using it.
    On the command prompt orapwd /? will give the syntax. Use it.

    Cheers,
    Kaushik

  9. #9
    Join Date
    Jan 2004
    Posts
    21
    Ok, Kaushik. I created the file 'acct.pwd' in 'c:\' with the username 'sys' and the password metioned in the OTN documentation. After creating the file, I tried to login but it failed. My server is installed on my 'd:\' drive. Where should the password file be? Also, the documentation mentions something about an environment variable.


    Originally posted by kausik_m123
    I hope u have lost the password for sys. If that is the case u can recreate the password by using an utility of oracle called ORAPWD.
    But the previous password file needs to be deleted before using it.
    On the command prompt orapwd /? will give the syntax. Use it.

    Cheers,
    Kaushik

  10. #10
    Join Date
    Jan 2004
    Posts
    21
    I triple-checked and my Windows logon is in the ORA_DBA group. So why would I not have sufficient priveledges for Oracle?

    Originally posted by jagged30net
    bato, this is what happened after I typed the command 'sqlplus' at the 'c:' prompt:

    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
    With the Partitioning option
    JServer Release 9.2.0.4.0 - Production

    C:\>sqlplus

    SQL*Plus: Release 9.2.0.1.0 - Production on Fri Feb 6 08:31:20 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Enter user-name: / as sysdba
    ERROR:
    ORA-01031: insufficient privileges

    ==================================

  11. #11
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    Hi,
    Sorry was busy , back on air...
    Ok here's what u need to do..
    Orapwd is an utility which creates password file for sys(if its Orcale 9i)/internal(prior to 9i).
    Ofcourse it could have been created using Oradim utility which is used for instance or Oracle Service (which you see in services) creation.
    The name of the password file follows the following convention it is
    PWD<ORACLE SID>.ORA and normally it resides under database directory under Oracle home.
    So if your ORACLE SID is default ORCL then you have the password file as PWDORCL.ORA. Before using Orapwd utility u should delete the existing one.
    I hope u will be able to create the file now..
    After creating it shutdown the Oracle Service .
    Startup the service.
    Log into sqlplus Sys as sysdba with the new password u have created.

    Check if it can connect.One more thing u should check whether the environment variable for ORACLE_SID is properly set .
    Hope it works fine...
    Let me know...
    Good Luck

  12. #12
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    One more thing I forgot to add...
    After doing the above job on the cmd prompt u should write
    set ORACLE_SID=<oracle service name>
    then give sqlplus with the username and password.
    This is for environment variable. U can also set it once and for all ..
    Right click on Mycomputers go to properties>click on Advanced tab,
    on the lower left hand corner u will find a button Environment Variables.
    Click on that . Click on new to add up an environment variable if its not there the Varibale should be ORACLE_SID and its value should be the SID or system identifier of the instance for eg ORCL.

    Best of luck,
    Kaushik

  13. #13
    Join Date
    Oct 2003
    Location
    Republic of Srpska, Bosnia and Herzegovina
    Posts
    35
    Please check is your oracle_sid ok. go to command prompt and type "set oracle_sid":

    C:\>set oracle_sid
    ORACLE_SID=MB

    C:\>

  14. #14
    Join Date
    Jan 2004
    Posts
    21
    Ok, guys. I am able to log into sqlplus with 'sys /as sysdba' and the password I orginally wrote down and used to work in OEM. How can I use this to get into OEM?

    If the answer is I can't, then I'll create a new password file.

  15. #15
    Join Date
    Oct 2003
    Location
    Republic of Srpska, Bosnia and Herzegovina
    Posts
    35
    You can change sys password from sqlplus and login into oem with new password:

    SQL> alter user sys identified by new_pass;

    User altered.

    or you can login into oem as sys without password:
    Lunch standalone,
    User: sys
    Password: anyword
    Connect as : sysdba

    Hope this help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •