Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Colombia
    Posts
    9

    Angry Unanswered: A problem with passwords!

    Hi, I need some help, look I changed the passwords for the users SYSTEM, SYS and ADMIN, and now I forgot them, so I can't do anything as administrator of the DB.... I know this sounds creepy but my mind had a little lose of data If anyone knows how to recover those passwords or how to make new ones please tell me.

    Thanks

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    you do not state your version.

    However, make a new passwordfile would work.


    otherwise, connect at command-line of the host through telnet or at the terminal (not through a client) and use:

    sqlplus anyuser/password@sid

    SQL*Plus: Release 9.2.0.2.0 - Production on Thu Jul 10 10:50:14 2003

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


    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
    With the Partitioning and OLAP options
    JServer Release 9.2.0.2.0 - Production

    sid:username> connect / as sysdba
    Connected.
    sid:username> show user
    USER is "SYS"
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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