Re: Internal password

[Quoted] [Quoted] Pass words of sys and internal are two different things... what you are missing is this...

Internal password is set at the time of the sid creation...

I dont know about the linux server, but it is done using the ORADIM utility in Windows NT.
[Quoted] Now if you really want to change the password of internal...all you need to do this...

1. Find the orapwd<sid> file on your machine.
2. change the name of the file.
3. If the server does not find this file, your instance will not start the next time... which means you have to created a new file now...
4. this is how you do it. - run the oradim utility... oradim - delete -sid <sid name> oradim -new -sid <same sid name> -intpwd <New internal password> ....other options as required.. for a complete detail of the oradim utility options, please look in the oracle server manual, available online as well at

http://www.cs.umbc.edu/help/oracle8/server.815/a67781/index.htm

and wala you are done...
now the internal password has changed... best of luck..

face any difficulty...
write back..
i have done it myself...

Laurent Boutet wrote:

> Hi !
> Indeed, I can Alter the Internal password with "alter user sys identified by
> toto"
> Safely, I know the Internal password with which I am connected !
>
> But but me and other french "newsgoupers" have problems !
> So :
>
> login sys/titi is ok
>
> I am connecting with internal/titi
>
> Now I modify the password :
>
> SQL>password
> Modification of SYS password
> Previous pass: titi
> new : toto
>
> I log off
> then login with sys/toto => ok
>
> I log off
> then login with internal/toto => insufficient privileges
>
> I log off
> then login internal/titi => ok !!!
>
> So Internal is still with the previous pass !!!!
>
> More...I have an other problem :
> When I create my database, Oracle ask me for Internal passe. I give it :
> "toto"
> At the end of the creation of the database, Oracle tells me the following
> pass :
> Internal : ****
> SYS : change_on_install
> SYSTEM : manager
>
> but here, Internal <> SYS !!!!
> I can't login with Internal/change_on_install !!!
> I can't login with SYS/toto !!!!!!!!!!
>
> What's the problem ??????
>
> Thanks
>
> Laurent
>
> "Howard J. Rogers" <dba_at_hjrdba.com> a écrit dans le message de news:
> a6o97g$rc1$1_at_lust.ihug.co.nz...
> > alter user sys identified by whatever.
> >
> > Internal is just a keyword that means 'log me on as SYS with sysdba
> > privileges'. Therefore, by altering SYS's password, you modify
> internal's.
> >
> > However, the 'internal" keyword is deprecated from Oracle 8.0 onwards, and
> > disappears completely in 9i, so the correct form of log on is 'connect
> > sys/whatever as sysdba'.
> >
> > Regards
> > HJR
> > --
> > ----------------------------------------------
> > Resources for Oracle: http://www.hjrdba.com
> > ===============================
> >
> >
> > "Laurent Boutet" <laurent.boutet1_at_libertysurf.fr> wrote in message
> > news:a6n9e6$mda$1_at_reader1.imaginet.fr...
> > > Hi !
> > >
> > > How do I change the Internal password ?????
> > >
> > > Thanks in advance
> > > Laurent
> > >
> > >
> >
> >

--

Atul Agrawal                     | Atul Agrawal
Masters Student, CS Deptt.       | 3501, St Paul Street,
Johns Hopkins University         | Apt # 1018,
3400, N Charles Street, NEB 224  | Baltimore,
Baltimore, MD 21218.             | MD 21218.
                                 |
Hello: 410-516-8291 (Lab)        | Hello: 410-366-6852 (Resi)