tag:blogger.com,1999:blog-18544104.post115159552538102137..comments2024-01-13T10:17:55.043-08:00Comments on Stephen's Oracle Blog: Does Oracle cache the SYSDBA password?Stephen Boothhttp://www.blogger.com/profile/18227774573735486445noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-18544104.post-37311753827482689972008-01-25T08:52:00.000-08:002008-01-25T08:52:00.000-08:00If the remote_login_passwordfile parameter is set ...If the remote_login_passwordfile parameter is set to exclusive, you cannot re-create the password file with the database open. If however, you have it set to shared you can.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18544104.post-1151909737297973072006-07-02T23:55:00.000-07:002006-07-02T23:55:00.000-07:00dberg,I read that note, it's pretty much verbatim ...dberg,<BR/><BR/>I read that note, it's pretty much verbatim what the example on orafaq (mentioned in my followup to this entry) says. The difficulty is that it's not explicit that you need to bounce the database for the changed SYSDBA password to take effect. Look at the last two steps:<BR/><BR/>5. Add, in the init<SID>.ora file, the following: <BR/> <BR/> REMOTE_LOGIN_PASSWORDFILE=Stephen Boothhttps://www.blogger.com/profile/18227774573735486445noreply@blogger.comtag:blogger.com,1999:blog-18544104.post-1151891900616349032006-07-02T18:58:00.000-07:002006-07-02T18:58:00.000-07:00Recently I had to increase the entries in our pass...Recently I had to increase the entries in our password files. The only way was to recreate every password file for each db. <BR/><BR/>See Metalink Note:1029539.6<BR/><BR/>Unfortunately it's a HOWTO not a WHYTO.<BR/><BR/>dbergAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18544104.post-1151705026560555462006-06-30T15:03:00.000-07:002006-06-30T15:03:00.000-07:00I don't recall ever reading or hearing that you sh...I don't recall ever reading or hearing that you shouldn't recreate the password file with the database up. I'm sure it's never been mentioned on a training course I've been on when they've talked about recreating the password file.Stephen Boothhttps://www.blogger.com/profile/18227774573735486445noreply@blogger.comtag:blogger.com,1999:blog-18544104.post-1151704125721206322006-06-30T14:48:00.000-07:002006-06-30T14:48:00.000-07:00I remember reading somewhere that one shouldn't re...I remember reading somewhere that one shouldn't recreate the orapw file while the database is open. Whether this is a caching mechanism or a way to avoid inconsistencies I don't know.Anonymousnoreply@blogger.com