Re: Troubles with changing password for SYS in password file

On 9. Dec., 00:08 h., sybra..._at_hccnet.nl wrote:
> On Sat, 8 Dec 2007 14:25:33 -0800 (PST), mariok
>
> <mario.kacko..._at_gmail.com> wrote:
> >I have to make this clear:
> >There are more then 100-databases on more then 50-servers in my
> >company.
> >My duty is to change passwords for more then 1000 database
> >users(schemas, actually) including user SYS on a regular basis.
> >I cannot do that by typing passwords. I have to automate this process
> >and therefore I want to use "alter user <usr> identified by values
> >'<hash>'" statement.
> >But user SYS is the issue.
>
> >Mario K.
>
> SYS is not the issue.
> The issue it took you almost a day to specify the problem correctly.
>
> I think you should investigate centralized password management as
> provided by Oracle Internet Directory and/or LDAP.
> I could suggest using UTL_FILE.PUT_LINE and UTL_FILE.GET_LINE to get
> passwords across, but then you probably start to nag about unencrypted
> passwords again. I also could suggest running orapwd on multiple
> databaes, and receive the same complaint.
> I can only hope you did disable O/S authentication on that mess,
> because if you didn't your request is just a big joke.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Thanks very much,
I will try suggestions.

Mario K. Received on Sun Dec 09 2007 - 04:16:53 CST