ORA-00988: missing or invalid password(s)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-00988: missing or invalid password(s)

  1. #1
    Join Date
    Jul 2000
    Posts
    41

    Question

    Is anyone familiar with this error when reseting passwords
    in Oracle 8.1.6.0.0 on Windows NT?

    I expired my system passord and I cannot renew the passwor
    because of some bug (1225555)
    Oracle says that the bug has been fixed in
    release 8.1.7.

    SQL> alter user system password expire;

    User altered.


    SQL> connect system/navs!ne3x@risk
    Changing password for system
    New password: ********
    Retype new password: ********
    ERROR:
    ORA-00988: missing or invalid password(s)


    I there a work around this? How can I reset the password
    using Server Manager?

    Please help!!!!

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    svrmgrl
    SVRMGR> connect internal
    SVRMGR> alter user system identified by YOUR_NEW_PASSWORD;
    SVRMGR> exit

    This would change the password for SYSTEM.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jun 2001
    Location
    Belgium
    Posts
    13
    svrmgrl > connect internal
    svrmgrl > alter user system identified by ...

    or connect as sys in sqlplus and alter system's password..

  4. #4
    Join Date
    Jun 2001
    Location
    Belgium
    Posts
    13
    i guess posting at the same time is inavoidable Sambavan

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Yep


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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