Re: Change the default password for INTERNAL.

I just thought I will let you know that Oracle provides a way to do 'connect internal' without a password. This would require creating local groups under NT (like dba group under Unix). It also requires SQL*Net configuration. Depending on the version of Oracle you are using, check the manual.

Murali

Juhan Kundla wrote in message <37B9661B.55890456_at_ensib.ee>...
>Internal password is only an issue on NT in that sense, that on Unix,
>which is more secure OS, everybody uses operating system authentication.
>But on NT the password file authentication is commonly used. There is an
>utility orapwd (Unix) or orapwd80 (NT + Oracle 8.0.xx), which can be
>used to change the internal password.
>
>And yes, there is a so called default password for internal, which is
>"oracle" if the starter database is created during Oracle installation.
>I have created all my databases manually using oradim and svrmgr, so I
>didn't know that.
>
>Glenn Heinze wrote:
>>
>> I believe the internal password is only an issue on NT. I don't have an
NT
>> instance to test this on, but I did pull this out of my notes (what I am
>> saying is that you will want to test first on an test database):
>>
>> On NT, the internal password file can be changed by executing the
following,
>> provided external verification is not used:
>>
>> oradim80 -delete -sid <sid>
>> oradim80 -new -sid <sid> -intpwd <new password>
>>
>> Otherwise 'orapwd80' needs to be used. This modifies the hidden
>> file'pwd<sid>.ora' and sets internal and sys to the specified password:
>>
>> orapwd80 file=...\dbs\pwd<sid>.ora password=<newpass> maxusers=5
>>
>> Juhan Kundla wrote in message <37B824D1.6A712EE0_at_ensib.ee>...
>> >AFAIK there is no default password for internal. You have to supply a
>> >pswd for internal during instance creation using oradim utility. I don't
>> >know exactly, but in order to change that pswd, you have to either
>> >recreate your db-instance or there is an option to change that with
>> >oradim.
>> >
>> >
>> >Kenneth C Stahl wrote:
>> >>
>> >> What is the default password for INTERNAL. The only time I ever use
>> >> INTERNAL is when I am logged into UNIX as oracle and then I just
simply
>> >> enter "CONNECT INTERNAL" and it does not prompt for a password. I am
>> >> aware, of course, that if I am not logged into the os oracle account
>> >> that I will be prompted for a password if I try to "connect internal"
>> >> but didn't know that there is actually a password that could be
entered
>> >> there.
>> >>
>> >> Ken
>> >>
>> >> Ravi Kondamuru wrote:
>> >>
>> >> > Hi, I have been able to change the password of SYS from the
>> >> > default. However I have found that the alias "INTERNAL" still has
the
>> >> > default password. Can someone help me understand how to change the
>> >> > password for INTERNAL. thanks, - Ravi.
>> >
>> >
>> >--
>> >Ilusat suve...
>> >
>> > \ | /
>> > \ | /
>> > -----( )-----
>> > / | \
>> > / | \
>> >
>> >...ja päikest :)
>> >
>> >Juku
>
>
>--
>Ilusat suve...
>
> \ | /
> \ | /
> -----( )-----
> / | \
> / | \
>
>...ja päikest :)
>
>Juku
Received on Wed Aug 18 1999 - 04:11:27 CDT