Skip to Content

changing passwords and system copies

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 17, 2009 at 08:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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