changing passwords and system copies
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?
Melanie Handreck replied
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.