changing sys & system password
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: changing sys & system password

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    What is the step by step way of changing the INTERNAL & SYSTEM password? it is through ORADIM? or
    ORAPWD utility?

    Please advise ASAP.
    Thanks

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    INTERNAL is a proxy user which in turns comes to be SYS.In order to change the password of INTERNAL and SYS user perform the following steps

    1.Remove the old password file which resides in
    $ORACLE_HOME/database directory.

    2.With the orapwd utility create a password file which contains the password for INTERNAL and SYS.

    orapwd file=c:\orant\dbs\passwd.ora password= entries=10

    To change the password for SYSTEM give the following command

    Connect as sys
    sql>alter user system identified by ;

    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards,
    ROhit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    2.With the orapwd utility create a password file which contains the password for INTERNAL and SYS.
    This is not exactly true, in fact if I have to say, right or wrong, I would say wrong.

    The password file is meant for INTERNAL not for SYS. Let me explain it with an example:

    You have the default password for SYS change_on_install. Then you connect as SYS:

    $sqlplus /nolog
    SQL>connect sys/change_on_install
    Connected.

    Now create the password file:

    $orapwd file=orapwABC password=xyz entries=3

    Now, try again:

    $sqlplus /nolog
    SQL>connect internal
    Connected.

    Startup the instance

    SQL>connect sys/change_on_install
    Connected.

    connect sys/change_on_install as sysdba
    Now you get ORA-01017: invalid password

    The difference is that SYS connecting as SYSDBA is like INTERNAL, they both use the password file, SYS however, uses its own password.




  4. #4
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Thanks for all the input but can someone who really did change his/her password and infact has confirmed password changed.
    Idid follow the step with ORAPWD. utility and ORADIM but when I connect with internal /oracle I expect login error not to be gracefully connected.

    Please send me a step by step to clean cut procedure that works. I REALLY NEED YOUR HELP...please
    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    If you are in the DBA's group, you will not be prompted for password when you connect as INTERNAL. Even if you have the password file. I assumed you knew that.




  6. #6
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Yes I know that. but the point I'm trying to make over is that when you change internal password with ORAPWD utility it shouldn't connect you gracefully just by typing INTERNAL.
    I renamed the PWD_SID in the orant bin and create a password file and connected with both new password and INTERNAL/ORACLE.

    I expect to error login when entered
    SQLPLUS> INTERNAL/ORACLE
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Ablakios
    Yes I know that. but the point I'm trying to make over is that when you change internal password with ORAPWD utility it shouldn't connect you gracefully just by typing INTERNAL.
    I renamed the PWD_SID in the orant bin and create a password file and connected with both new password and INTERNAL/ORACLE.

    I expect to error login when entered
    SQLPLUS> INTERNAL/ORACLE
    Well, that's not the case with INTERNAL :-) Upgare to 9i, there you will not have that problem. There is no INTERNAL.

    In 9i, you cannot even log in from client's SQL*PLUS as SYS. Has anyone noticed that in 9i?


  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    in 9i you need sysdba to access the catalog as well

  9. #9
    Join Date
    May 2001
    Location
    Delhi
    Posts
    341


    I am running SAP on Oracle 8i/NT

    My SAP admn wans me to change the oracle standard passwords. I understand that I can change the passwords as

    SYSTEM
    SQLPLUS>connect SYSTEM/manager
    connected

    SQLPLUS>password
    New password - i'll enter new password


    SYS
    SQLPLUS>connect SYS/change_on_install
    connected

    SQLPLUS>password
    New password - i'll enter new password


    INTERNAL
    I need to create new pwd file or Can i change like as i do with system.


    help me...with method
    --------------------------
    The Time has come ....

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938


    help me...with method
    You should try to understand that login as SYS is not the same as INTERNAL. INTERNAL is same as SYS as SYSDBA. And if you are in the DBA's group you will not be propted for password, you don't need one. That is how Oracle works.

    Since you use NT, I suggest you comment out the line SQLNET_AUTHENTICATION_SERVICES in your sqlnet.ora file. Then you will be asked for password.


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