Hi Manfred, the normal way to change the password of the SYSDBA is: dbmcli -u ... -d ... user_put <sysdba> PASSWORD=<newpwd>
For your database in the current state only a workaround is possible: dbmcli -u ... -d ... db_execute ALTER PASSWORD <sysdba> <newpwd> Regards Bernd > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 21. März 2006 15:33 > An: maxdb@lists.mysql.com > Betreff: Re: Recover backup medium from version 7.4.3.10 with > 7.6.00.16 > > Hello, > > i tried it and got the error: -24909 SYSDBA unknown [load sys_tab ...] > After ok, i entered the SYSDBA login and password (recovered > from the backup > medium) > Then i got the error message box: -24907 wrong SYSDBA > [load_systab ...] > > I have checked the password convention of 7.6.00 and found > out that i have > used a password with "-" in version 7.4.3. I haven't had > problems until now. > > Is there a possibility to change the sysdba password? Then i > would create a > new backup medium after i have changed the password. But I > read in your > archive that the password of the sysdba cannot be changed! > > Regards > Manfred > > > > > -----Original Message----- > From: Heinrich, Tilo > Sent: March 21 2006 12:46pm > To: [EMAIL PROTECTED] > Subject: Re: Recover backup medium from version 7.4.3.10 with > 7.6.00.16 > > Hello Manfred, > > Use DBMGUI->Instance->Configuration->'Upgrade System Tables' > to upgrade your > system tables to version 7.6.00. > > Best regards, > Tilo Heinrich > SAP Labs Berlin > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 21, 2006 12:38 PM > To: [EMAIL PROTECTED] > Subject: Recover backup medium from version 7.4.3.10 with 7.6.00.16 > > Hello, > > i have setup MaxDB 7.6.00.16 on WinXP Professional for test > and development > purposes. > > Furthermore i run SAP DB 7.4.3.10 on Red Hat Linux as > productive system. > > Now i would like to take the backup medium from the > productive system and > create a new instance for recovery on my MaxDB installation > in order to > recover with the backup medium from 7.4.3.10. > > Recovery has completed successfully. > Restart from Recover Wizard: Error Message Box: 0 > After Cancel: Error Message Box: -24988 Sql error [info STATE > -d]; -4004, > Unknown table name:INFO_STATE > > After starting the database in the DBMGUI: -24988 Sql error > [info STATE -d]; > -4004, Unknown table name:INFO_STATE > Database is online, but information is not complete and I > retrieve sveral > Sql errors, if I select different menu items. > > Are there any possibilities to recover a backup medium from a previous > installation? What is the correct way to do this? > > Manfred > > -- > Echte DSL-Flatrate dauerhaft für 0,- Euro*! > "Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/maxdb?unsub=1 > > -- > Echte DSL-Flatrate dauerhaft für 0,- Euro*! > "Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
