Change the password for internal?

[Dan1]

Hi,

I am using ORACLE 8.i and I don't know how to change the password for "internal". The password for the custom installation is "oracle". I tried to connect as "internal", then I typed "password" after the SQL prompt, but I could not change the old password "oracle". Does anybody know how to fix this problem?
Many thanks,
Dan1

[moff]

Hi,

The password should be the same as the SYS user.
Although when I entered the Sys user password at the password prompt for INTERNAL it didn't work until I reset the Sys password:

alter user sys identified by NEW_PASSWORD

connect internal
password : NEW_PASSWORD

Hope this helps

moff.

[Dan1]

Hi moff,

thank you for your quick reply!! You are right; the password for sys and internal is the same. I could change it by the way you described it. :-)

Dan

[akbar]

hey moff,

My heart moved out when i heard u saying resetting sys password will reflect for internal pasword.How is it dear.The way u have shown doesn't work on oracle8 as well as oracle8i.

I knew a way to change internal password at the command prompt type,try this as this works in oracle8i(8.1.6)
c>oradim -delete -sid SIDNAME
c> oradim -new -sid NEWSIDNAME -INTPWD
GIVENEWPASSWORD -STARTMODE AUTO

U find out the sid from the registry if u had forgetten,

This GIVENEWPASSWORD is the password of u'r internal and not sys.

U have to elaborate u'r reply as i m responsible for my reply.

Awaiting to for u'r action.

akbar

[moff]

akbar,

Not sure what your getting at!

When you say 'The way u have shown doesn't work on Oracle8 as well as Oracle8i' Do you mean it does not work on Oracle 8, Oracle 8i or both?

I'm running 8.1.7 and it worked for me.

Dan1 is using Oracle8.i and it appears to have worked for him.

Moff


[Edited by moff on 02-09-2001 at 09:10 AM]

[Dan1]

Hi akbar,

well it seems that it doesn't take much for your "heart to move out"...I did what moff suggested me to do, and the default passwd for internal is not valid anymore. I admit that it is not quite logical, but removing the old passwd for sys did affect the internal passwd! So I have no idea why moff's idea worked - anyway, it did. i use Oracle 8i. But thanks, akbar, i will have to try your solution as well.
By the way, i appreciate any reply, elaborated or not. The essential is that it leads you on the right track.

Dan