changing passwords and system copies

[andreas_zigann]

Hello,

since we are changing passwords of the users control, superdba and database schemata user to individual passwords we get problems with system copies.

When we do a system copy and try to set the password of the superdba we get the message wrong sysdba.

We can connect to a copied database by two different passwords to database instance (dbmcli uses the origin of the system, dbmgui the password of the source system of system copy).

Is the passord of superdba stored at two points, filesystem and in the database?

At FAQ I found the hint to load systab after installation, upgrade and system copy.

Can I load systab at any time without risk?

Best Regards

Andreas

[markus_doehr2 · Accepted solution]

AFAIK the password of the SYSDBA can't be changed (easily), it's copied with the database.

You can load the system tables on the new system anytime using

dbmcli -U c load_systab -u superdba,<oldpassword> -ud domain

Markus

[Melanie · Accepted solution]

Hello Andreas,

the SYSDBA password is stored in the database and in the UPC file.

When you create a system copy, the password of the source system is copied with the backup.

You'll have to change it afterwards, as described in note 25591.

Regards, Melanie

[andreas_zigann · Accepted solution]

Hello Melanie,

the problem is, I am not able to change the password of superdba with dbmcli: error message "Wrong SYSDBA".

Sometimes it is possible to change the password of superdba with dbmgui.

A load systab works fine. After the load systab the change of password is possible with dbmcli.

Best Regards

Andreas

[Melanie · Accepted solution]

With loading the system tables the password is updated in the UPC file. As long as a wrong password is stored there, the dbmserver does not allow connecting with this user. But you should always load the system tables after you created a system copy, anyway.

Regards,

Melanie