Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2003
    Posts
    62

    Unanswered: changing internal password

    I have lost my internal users's password.

    How can I change this password without connecting internal ?

  2. #2
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Do you have another user with DBA permissions? If so you might be able to "alter user internal identified by {your new password}". For the future you should stop relying on "internal". That login/facility goes away in 9i.

    The other option is reload Oracle. Be sure to export all your data first.

    There might be other options (many smart people will read this), but I do not think so.
    NOTE: Please disregard the label "Senior Member".

  3. #3
    Join Date
    Sep 2003
    Posts
    156

    Re: changing internal password

    Originally posted by jleb
    I have lost my internal users's password.

    How can I change this password without connecting internal ?
    There are other options, you dont have to reload oracle...

    The SYS account is in the database only.
    You cannot log on as this account unless the database is open. The internal account is from the password file. When you ran the oradim,
    it created a password file for that instance. The database does not have to be open for you to log on as INTERNAL. This is required so
    you can limit privileges to start the database.

    When the password file is created, it creates two users by default, SYS and INTERNAL. To connect as sys using the password file instead of the database security, you must specify "AS SYSDBA". This will connect you as SYS using the password file.

    To change the password of internal:
    ==================================

    Make sure that you have shutdown the database before you change the password. Do not remove or modify the password file if you have a database or instance mounted using
    REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE(or SHARED). If you do, you will be unable to reconnect remotely using the password file. Even if you replace it, you cannot use the new password file, because the timestamp and checksums will be wrong.

    The ORACLE_HOME\DATABASE\PWD.ORA file contains the internal password. This is a binary file and cannot be manually edited. The ORAPWD.EXE utility was created for DBAs who need to change the INTERNAL login password.

    From the DOS prompt run:

    orapwd file=c:\oracle_home\database\pwd.ora
    For example it could be something like:
    orapwd file=c:\oracle\database\pwdorcl.ora password=oracle entries=5

    FILE = Path and name of the password file. (mandatory)
    Password = Password for SYS and INTERNAL. (Mandatory)
    Entries = Maximum number of distinct DBAs and OPERs. (Optional, default=5)

    There are no spaces around the equal-to <=> character.
    rgs,

    Ghostman

  4. #4
    Join Date
    Aug 2003
    Posts
    62
    I try the "alter user " command for internal user.

    It doesn't work in 8.1.7. The user internal is not an ordinary user.

  5. #5
    Join Date
    Aug 2003
    Posts
    62

    Re: changing internal password

    Is it possible to modify the orapwd file without shuting down the database ?

    My database is shutdown/restarted every weeks. I'd like to change the pwd file and wait next reboot. Is it possible.

  6. #6
    Join Date
    Jan 2004
    Location
    Bogor
    Posts
    2

    Talking Re: changing internal password

    in server manager type:
    ALTER USER SYS IDENTIFIED BY <NEW PASSWORD>

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296

    Re: changing internal password

    Originally posted by jleb
    I have lost my internal users's password.

    How can I change this password without connecting internal ?
    If you log into the host terminal (goto the machine) you should be able to open a command prompt and type:
    svrmgrl
    connect internal

    the machine should use OS authentication.
    If it doesn't then maybe you just need to set the oracle_sid and then try it.
    - 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
  •