Results 1 to 10 of 10
  1. #1
    Join Date
    Feb 2009
    Posts
    48

    Post Unanswered: forget password of sysdba

    hey dudes i forgot my sysdba password how can i recover it? and i must provide connect string without it wont let me in how can i enter into database?:

  2. #2
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    log in as the OS oracle - user on the DB-server and recreate the pwd<SID>.ora file in $ORACLE_HOME/dbs (or &#37;ORACLE_HOME%\database on Windows) with the orapwd command
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

  3. #3
    Join Date
    Apr 2010
    Posts
    1
    Hey!!!

    If you know the password of the "SYSTEM" user, you can login as the system user and change the password of the sys user.

    SQL> connect system/<password> --connect as system user
    SQL> alter user sys identified by <new_password> --connected as system user change the password of sys user.


    OR

    If you are using Oracle 10g, Super users of the operating system can login to the database as follows:

    SQL> connect / as sysdba

    But if you are to login using this option you have to ensure the <ORACLE_HOME>/NETWORK/admin/sqlnet.ora file has an entry as below:

    SQLNET.AUTHENTICATION_SERVICES = (NTS) --ensure the statement is not followed by a "#" which wll result in a comment of the above statement.

    By default operating system login is allowed in Oracle 10g...

    After you login as the super user of DB, you can then change the password of the sys user.

    Hope this helps

    Warm Regards,
    Asif Muhammad
    Last edited by asifonemail; 04-01-10 at 05:27.

  4. #4
    Join Date
    Aug 2009
    Posts
    262
    Hi .

    If you are the server machine ( the one having database software installed)

    and if you are happen to the be administrator of the OS ( windows ?)
    then dont worry ..


    and if you are not the administrator , see to it that ORA-DB role is granted to your user by the OS administrator .


    now how to change password ..


    simply

    connect sys as sysdba
    pass: whocares .

    it will except .



    even if you give
    user : joke as sysdba
    pass: hahaha

    it will accept .

    or you can simply login

    os user administrator as sysdba

    os pass : xxxxxxxx



    now after wards


    alter user sys identified by <new password>

  5. #5
    Join Date
    Aug 2009
    Posts
    262
    SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 1 03:36:49 2010

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> connect sys as sysdba
    Enter password:
    Connected.


    SQL> alter user sys identified by "khgfdwerwkjeg";

    User altered.

    SQL> connect joker as sysdba
    Enter password:
    Connected.

    SQL> show user
    USER is "SYS"

    SQL> alter user jokey identified by "asdasdaadafsdgf"
    2 ;
    alter user jokey identified by "asdasdaadafsdgf"
    *
    ERROR at line 1:
    ORA-01918: user 'JOKEY' does not exist



    SQL> connect jokeyhehaha as sysdba
    Enter password:
    Connected.


    SQL> show user
    USER is "SYS"

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    normal & expected behaviour
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296
    from the db host OS side you are authenticated at server login as the oracle owner.
    so, it doesn't matter what user you login as sys. you are already authenticated.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  8. #8
    Join Date
    Aug 2009
    Posts
    262
    *bowing in respect*

    what else can i perform while sitting on night shift with nothing to do ..... high on caffeine and such a question in sight ....

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by mishaalsy View Post
    *bowing in respect*

    what else can i perform while sitting on night shift with nothing to do ..... high on caffeine and such a question in sight ....

    Read The Fine Manuals found at Search and Download Oracle Database, Application Server, and Collaboration Suite Documentation
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  10. #10
    Join Date
    Aug 2009
    Posts
    262
    sir yes sir ,, ( only recently i found u are a mam not sir ... but untill it is confirmed u are a 'sir')

Posting Permissions

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