Change Internal Password
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Change Internal Password

  1. #1
    Join Date
    Jan 2002
    Posts
    1

    Thumbs down

    Hi Everybody

    At the moment I'm working with OEM 8i release 8.1.6 and migrating for OEM 9i on NT2000 platform and I've been problem when I tried to change the Internal/Sys user password. I used the command ORADIM and ORAPWD, but now I get connect with my old/new password. I don't Know what's happening. I think that have many people ( user ) with the same problem. Please, I hope that anyone can solve my problem.

    Thank´s

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,001
    Sometimes rebooting after changing the internal password works. Of course you know that Oracle 9i does not have internal or svrmgrl.

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I've been problem when I tried to change the Internal/Sys user password
    Internal is not exactcly same as SYS. 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
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    where will this orapwd file reside in sun machine?
    we tried but getting error

    wht should by "FILE = " (imean the file parameter)

    thnx,
    Cheers!
    OraKid.

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    The name of the password file must be of the format $ORACLE_HOME/dbs/orapw{$ORACLE_SID }because the name and location of the password file is hard coded in the file "sparams.h" (the line is: # define SS_SIDPWFILE_DEFAULT "?/dbs/orapw@"). Thus, the file must be put in the "dbs" directory and named "orapw".

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