How to change internal password
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: How to change internal password

Hybrid View

  1. #1
    Join Date
    Aug 2001
    Posts
    56

    Angry

    Hi
    I am facing one problem and i am not clear about this.
    when i give connect internal@dbname from the svrmgr propmt.
    i have installed typical installtion of Oracle8.1.7 on windows NT.

    I have changed sys password, as my understaing internal is alias of sys.
    but still i am able to from svrmgr prompt as internal.

    i want to change the Internal password. what i have to do for that.

    regards
    Anuj
    Anuj
    India

  2. #2
    Join Date
    Aug 2001
    Posts
    87
    Internal is another user not same as sys , once you would like to change it you have to delete using oradim80 in winnt
    and then create new one.

    hsbdba

  3. #3
    Join Date
    Aug 2000
    Posts
    236
    I thought that ORADIM is for creating/deleting instance/services and RAPWD for changing internal passwords.

    Nizar

  4. #4
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Hi Anuj

    Create password file by using ORAPWD utility.
    The password you specify while creating pwd file will be password for the internal and sysdba user.


    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Raminder
    Hi Anuj

    Create password file by using ORAPWD utility.
    The password you specify while creating pwd file will be password for the internal and sysdba user.

    Neither internal nor sysdba is a user. Internal for example is an alias for sys.

  6. #6
    Join Date
    Sep 2000
    Posts
    305
    You have to run the ORAPWD Utility to change the password but this is not sufficient you also have to do the following

    Go To
    start >> programs >> Administrative Tools >> User Manager For Domain

    You will have a group i.e ORA_DBA you just Remove its all member and see will it work or not?

    It should work.


  7. #7
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Originally posted by Julian:
    quote:
    --------------------------------------------------------------------------------
    Originally posted by Raminder
    Hi Anuj

    Create password file by using ORAPWD utility.
    The password you specify while creating pwd file will be password for the internal and sysdba user.


    --------------------------------------------------------------------------------


    Neither internal nor sysdba is a user. Internal for example is an alias for sys.
    Excerpt from
    http://otn.oracle.com/docs/products/...6/dba.htm#1207

    For example, the following command creates a password file named ACCT.PWD that allows up to 30 privileged users with different passwords. The file is initially created with the password SECRET for users connecting as SYSOPER or SYSDBA:

    ORAPWD FILE=acct.pwd PASSWORD=secret ENTRIES=30

    Following are descriptions of the parameters in the ORAPWD utility.
    ---------------
    --------------
    PASSWORD
    This parameter sets the password for SYSOPER and SYSDBA. If you issue the ALTER USER statement to change the password after connecting to the database, both the password stored in the data dictionary and the password stored in the password file are updated. The INTERNAL user is supported for backwards compatibility only. This parameter is mandatory.

    ENTRIES
    ---------------------

    What say you Julian?

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Raminder
    Originally posted by Julian:
    quote:
    --------------------------------------------------------------------------------
    Originally posted by Raminder
    Hi Anuj

    Create password file by using ORAPWD utility.
    The password you specify while creating pwd file will be password for the internal and sysdba user.


    --------------------------------------------------------------------------------


    Neither internal nor sysdba is a user. Internal for example is an alias for sys.
    Excerpt from
    http://otn.oracle.com/docs/products/...6/dba.htm#1207


    For example, the following command creates a password file named ACCT.PWD that allows up to 30 privileged users with different passwords. The file is initially created with the password SECRET for users connecting as SYSOPER or SYSDBA:

    ORAPWD FILE=acct.pwd PASSWORD=secret ENTRIES=30

    Following are descriptions of the parameters in the ORAPWD utility.
    ---------------
    --------------
    PASSWORD
    This parameter sets the password for SYSOPER and SYSDBA. If you issue the ALTER USER statement to change the password after connecting to the database, both the password stored in the data dictionary and the password stored in the password file are updated. The INTERNAL user is supported for backwards compatibility only. This parameter is mandatory.

    ENTRIES
    ---------------------

    What say you Julian?
    I would say again the same: Internal is an alias for SYS, SYSDBA and SYSOPER are previligies, not users.


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