[OT] Oracle server password removal - VMS 6.2

[supervinx]

Hi !
I have a DEC 2000 AXP 300 (370), with Oracle server installed, but I have
no passwords.
There's a way to reset them ?
Thanks !



--
http://www.supervinx.com/Retrocomputer

[Stephen Hoffman]

On 2012-10-14 22:10:30 +0000, supervinx said:

> I have a DEC 2000 AXP 300 (370), with Oracle server installed, but I
> have no passwords.
> There's a way to reset them ?

Them? Your VMS passwords? Or whatever Oracle passwords you've encountered?

If the former: http://labs.hoffmanlabs.com/node/204

Google (or Bing or DuckDuckGo or Blekko) is your friend, too. This is
not the first time somebody's forgotten a password, after all.

--
Pure Personal Opinion | HoffmanLabs LLC

[supervinx]

Il Sun, 14 Oct 2012 19:05:57 -0400, Stephen Hoffman ha scritto:

> On 2012-10-14 22:10:30 +0000, supervinx said:
>
>> I have a DEC 2000 AXP 300 (370), with Oracle server installed, but I
>> have no passwords.
>> There's a way to reset them ?
>
> Them? Your VMS passwords? Or whatever Oracle passwords you've
> encountered?
>

You're right, I was unclear.
Them = Oracle passwords.
I stated it in the subject, but I forgot to outline in the body.

I already got rid of VMS ones.


--
http://www.supervinx.com/Retrocomputer

[Stephen Hoffman]

On 2012-10-14 23:32:53 +0000, supervinx said:

> Them = Oracle passwords.

Bing finds the following information on resetting a forgotten database
system password, and which look to be a reasonable starting point...

http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/how-to-reset-oracle-database-system-user-password-445054

https://forums.oracle.com/forums/thread.jspa?messageID=2308978&tstart=0
https://forums.oracle.com/forums/thread.jspa?messageID=9201557&tstart=0
https://forums.oracle.com/forums/thread.jspa?threadID=897559
http://docs.oracle.com/html/B13738_01/apb.htm
http://docs.oracle.com/html/B10506_01/ch1.htm

And the Oracle OTN forums are where the Oracle folks tend to lurk. Not
so much here in c.o.v., though you might get lucky.

[supervinx]

I've already found many og them, except the last two, VMS related.
I should adapt Windows tips.
I couldn't connect through
sqplplus / as sysdba, since may be I'm connected through the wrong user (SYSTEM).
I should check which users are registered in the system.



--
http://www.supervinx.com/Retrocomputer

[Syltrem]

"supervinx" <nes...@libero.it> wrote in message
news:k5gdak$5e0$1...@tdi.cu.mi.it...

Don't know what version of Oracle you've got but prior to 10.x you ahev to
use double quotes as in:

$ SQLPLUS "/ as sysdba"

On a VMS 6.2 you probably don't have 10.x of Oracle.

If you don't know what user has the SYSDBA right, check the owner of the
Oracle files (executables or database files) with DIR/SEC or the user
running the instances (SH SYS/FU/PROC=*PMON)

HTH
Syltrem

>
> --
> http://www.supervinx.com/Retrocomputer

[supervinx]

Hmmm, it says

Oracle_V47701>sqlplus "/ as sysdba"

SQL*Plus: Release 3.1.3.5.1 - Production on Fri Feb 13 03:22:54 2009

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

ERROR: ORA-01017: invalid username/password; logon denied

I logon into VMS as user ORACLE (all files are owned by this user)

--
_
___ _ _ _ __ ___ _ ____ _(_)_ __ __ __
/ __| | | | '_ \ / _ \ '__\ \ / / | '_ \\ \/ /
\__ \ |_| | |_) | __/ | \ V /| | | | |> <
|___/\__,_| .__/ \___|_| \_/ |_|_| |_/_/\_\
|_|

[Stephen Hoffman]

On 2012-10-15 22:32:09 +0000, supervinx said:

> Hmmm, it says
>
> Oracle_V47701>sqlplus "/ as sysdba"
>
> SQL*Plus: Release 3.1.3.5.1 - Production on Fri Feb 13 03:22:54 2009
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
> ERROR: ORA-01017: invalid username/password; logon denied
>
> I logon into VMS as user ORACLE (all files are owned by this user)

Use the VMS SYSTEM user when you're doing this sort of database
administration. (Use of the system-level user was explicitly mentioned
in some of those replies I'd linked to, when you're attempting to
override access.)

Better, wipe the disks and reinstall from distros, and don't deal with
ancient software unless you have to.

You're going to have enough "fun" with that Jensen box, anyway.

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.

[supervinx]

> Use the VMS SYSTEM user when you're doing this sort of database
> administration. (Use of the system-level user was explicitly mentioned
> in some of those replies I'd linked to, when you're attempting to
> override access.)
>

The result is the same, with ORACLE or SYSTEM.
Other accounts login with a custom menu that manages the db (it should
be a rdbms), but they fails.

> Better, wipe the disks and reinstall from distros, and don't deal with
> ancient software unless you have to.
>

I'm tempted, since the system is a bit messy. There are two shadow set each
with a missing disk
(DKA100, DKA200) (DKA300,DKA400),
DKA200 and DKA300 are missing,
They are mounted at startup with the /shadow option,
mount dsa0: /shadow=($1$dka100:,$1$dka200:) /system V47701_sys
and DKA100 is the system disk. According to a friend of mine this is not a
good practice ...

> 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 !

[supervinx]

>> 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 ;)



--
http://www.supervinx.com/Retrocomputer

[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.

[supervinx]

Touché :)

I was writing from another PC and I hadn't the details handy ...

Here they are:

VMS 6.2 / Oracle V7 (Oracle7 Server Release 7.1.5.2.3)

1) Login as ORACLE user (SYSTEM is not enough).

2) SQLDBA

3) CONNECT INTERNAL

4) SELECT USERNAME FROM DBA_USERS; In order to get a list of the DB users.

5) ALTER USER xxx IDENTIFIED BY password; xxx is an user chosen from
the list 4), password is a new password chosen by us.

6) CONNECT xxx/password or EXIT;

Then we can login with SQLPLUS.

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

[supervinx]

> 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.

Hmmm, now I understand the meaning of "you're allergic".
I had some troubles in the forum, since I haven't
an Oracle license (but the former owner did) ;)




--
http://www.supervinx.com/Retrocomputer

[Syltrem]

"Stephen Hoffman" <seao...@hoffmanlabs.invalid> wrote in message
news:k5i3v0$kor$1...@dont-email.me...

> On 2012-10-15 22:32:09 +0000, supervinx said:
I logon into VMS as user ORACLE (all files are owned by this user)
>
> Use the VMS SYSTEM user when you're doing this sort of database
> administration. (Use of the system-level user was explicitly mentioned in
> some of those replies I'd linked to, when you're attempting to override
> access.)

Oracle does not like to be managed from the SYSTEM account.
You just can't use an account with UIC group <= SYSGEN(MAXSYSGROUP)

It`s been over 10 years since I've been using Oracle 7.3 I have forgotten
you couldn't do this from SQLPLUS back then.

Syltrem

[Syltrem]

"supervinx" <nes...@libero.it> wrote in message

news:k5kd9m$pt0$1...@speranza.aioe.org...

> Touché :)
>
> I was writing from another PC and I hadn't the details handy ...
>
> Here they are:
>
> VMS 6.2 / Oracle V7 (Oracle7 Server Release 7.1.5.2.3)
>
> 1) Login as ORACLE user (SYSTEM is not enough).
>
> 2) SQLDBA
>

This must be a command symbol.
The real command is SVRMGRL
http://www.orafaq.com/wiki/Svrmgrl

Syltrem