[Info-vax] [OT] Oracle server password removal - VMS 6.2

[Stephen Hoffman]

On 2012-10-16 17:31:12 +0000, supervinx said:

>>> 
>>> Or sign up for OTN, and go ask the Oracle folks in their own fourms. If
>>> you're allergic to OTN for some reason, then try asking over in the
>>> comp.databases.oracle.server group.
>> No, I never wrote on OTN. I have just posted a hopeless message, since
>> my version is really old :(
>> 
>> Thanks !
> 
> I managed to reset all the passwords, thanks to the OTN forum ;)

Asking your question in the right place often helps.

And because the poster inexplicably didn't include details here nor nor 
link to a blog topic or other posting, here is the URL of the 
associated OTN discussion:

https://forums.oracle.com/forums/thread.jspa?messageID=10638742

...with the details of how to {break into / reset / change / remember / 
alter / recover} the {forgotten / lost / corrupt / missing} database 
passwords for (as it turns out) the Oracle7 Server Release 7.1.5.2.3 - 
Production Release - on OpenVMS Alpha V6.2.

Looks like the core SQL command is:

ALTER USER CRT IDENTIFIED BY CRT;
CONNECT CRT/CRT

where the target user (in this case) is CRT.

See the OTN discussion for details.

-- 
Pure Personal Opinion | HoffmanLabs LLC