DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: internal password

  1. #1
    Join Date
    Nov 2000
    Posts
    416

    internal password

    I have changed default internal password < oracle > to something else with orapwd utility but still connect internal/oracle works!!!!! the new password works as well. I am running 8i mon win 2k can you tell me how I can get rid of < oracle > password permanently.
    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Sep 2002
    Posts
    411
    drop your password file and create the new password file with the desired password.

  3. #3
    Join Date
    Nov 2000
    Posts
    416
    Bilive me. I did that but still internal/oracle works!!!!! Why???
    An ounce of prevention is worth a pound of cure

  4. #4
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Your internal has no password actually
    You can connect as
    connect internal

    without password:-)
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  5. #5
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    you can enter any name for internal password it will still connect. it doen't have any password.
    siva prakash
    DBA

  6. #6
    Join Date
    Jun 2002
    Location
    VA,USA
    Posts
    83
    hi,
    use this command,

    svrmgrl> alter user sys identified by ;

    your internal password will change.
    saravana kumar

  7. #7
    Join Date
    Jun 2002
    Location
    VA,USA
    Posts
    83
    hi,
    the above command is

    svrmgrl> alter user sys identified by newpassword.

    it changes your internal password and sys password.
    u can connect as internal/newpassword.
    saravana kumar

  8. #8
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    What's behind of command :
    alter user sys identified by newpassword.


    Does it change the password file ?
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  9. #9
    Join Date
    May 2002
    Posts
    2,645
    See Note 114384.1 on MetaLink.

    See Ask Tom
    http://asktom.oracle.com/pls/ask/f?p...%7Bpassword%7D

Posting Permissions

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


Click Here to Expand Forum to Full Width