cancel
Showing results for 
Search instead for 
Did you mean: 

How to fix aborted MAXDB upgrade?

Former Member
0 Kudos

Hi,

I did a systemcopy to Windows 2008 R2 MAXDB 7.6. The first copy went well, I did the upgrade to Maxdb 7.8, very thing fine.

Now I copied the second system to the server every thing until the upgrade to MADB 7.8 went fine.

But while upgrading to 7.8 the upgrade stopped, so that I had to abort it.

Now the first system works fin, but the second system dows not even respond to dbmcli -d <DBID>.

sdbregview shows

GlobalC:\sapdb\programs   7.9.08.04
LegacyC:\sapdb\programs   7.6.00.35
S02   C:\sapdb\S02\db     7.8.02.23 not running system
CL_S01C:\sapdb\clients\S017.8.02.30
CL_S02C:\sapdb\clients\S027.8.02.23
S01   C:\sapdb\S01\db     7.8.02.30

sdbverify shows everything fine, besides:

Checking package JDBC

ERR:  Failed

ERR:    Checking installation "Global" failed

ERR:      Checking ACL for D:\sapdb\data\globals\config\install failed

ERR:        ACL entry BUILTIN\Users with rights GENERIC_READ  not found

ERR:    Checking installation "S02" failed

ERR:      Checking ACL for D:\sapdb\data\installations\S02\config\install failed

ERR:        ACL entry BUILTIN\Users with rights GENERIC_READ  not found

ERR:    Checking installation "CL_S01" failed

ERR:      Checking ACL for C:\sapdb\clients\S01\data\installations\CL_S01\config\install failed

ERR:        ACL entry BUILTIN\Users with rights GENERIC_READ  not found

ERR:    Checking installation "CL_S02" failed

ERR:      Checking ACL for C:\sapdb\clients\S02\data\installations\CL_S02\config\install failed

ERR:        ACL entry BUILTIN\Users with rights GENERIC_READ  not found

ERR:    Checking installation "S01" failed

ERR:      Checking ACL for C:\sapdb\S01\data\installations\S01\config\install failed

ERR:        ACL entry BUILTIN\Users with rights GENERIC_READ  not found

As windows service the old SAPDB services for system S02 are registered...

So I think the S02 installation is complete rubbish and I tried to delete it, install 7.6 again, import backup and try an other upgrade to 7.8.

But I can't delete the installation, because the the S02 System is registered!

How do I deinstall the S02 if I can't connect to the database?

How do I unregister the database S02?

Thanks a lot,

Christian

Accepted Solutions (1)

Accepted Solutions (1)

yashwanthkumar_kethineed
Active Participant
0 Kudos

Hi Christian,

Please post the output of "dbmcli db_enum"

Do you have more than one instance installed on this host ?

Please attach the upgrade log to the post. I would like to see what went wrong with the upgrade, so that we can fix this installation. You can find the logs under /sapdb/data/wrk directory.

FYI

db_enum writes out database instances which are on the host.

To get rid of the database instance you can run this command: Be carefull.

dbmcli -d <dbname> -u <dbm>,<password> db_stop

dbmcli -d <dbname> -u <dbm>,<password> db_drop

Regards,

Yashwanth

Former Member
0 Kudos

Hi Yashwanth,

thanks for your reply.

db_enum show:

S02    C:\sapdb\S02\db                   7.8.02.23    fast    offline
S02    C:\sapdb\S02\db                   7.8.02.23    slow    offline
S01    C:\sapdb\S01\db                   7.8.02.30    fast    offline

S01    C:\sapdb\S01\db                  

7.8.02.30    slow    offline

So there is an other DB installed.

I can't connect using dbmcli, so I cant drop the database.

Sorry, but I can't find a SDBUPDMsg<digit>.log for this upgrade....

Best regards

Christian

yashwanthkumar_kethineed
Active Participant
0 Kudos

Hi Christian,

You wont be able to uninstall the software unless you drop/delete the instance.

What error do you see when trying to connect using the dbmcli tool ?

Let me know if these commands work for you :

Before you unregister the database, Make sure the scheduler is stopped.

dbmcli -u DBM,<password> -d S02 scheduler_stop

To unregister the database instance:

dbmcli -u DBM,<password> -d S02 db_unreg -f

If you are able to succesfully unregister the S02, then you can proceed with the uninstall using the SDBUNINST tool as follows:

Run as administrator/root user:

sdbuninst -i S02 -autoresolve

sdbuninst -i CL_S02 -autoresolve

Regards,

Yashwanth

Former Member
0 Kudos

Hi Yashwanth,

yes, I tried to uninstall (Start -> programm -> MXD -> S02 -> uninstall) but it mentioned that there is a DB connected...

My problem is, that I can't connect with dbmcli.

A "dbmcli -d S02 -U c" is running for 24 hours now and it did not return until now!

I did not find any error message or something else...

Best regards

Christian

former_member229109
Active Contributor
0 Kudos

Hello Christian,

If you planning to drop the S02 database instance & forgot the password of DBM database user,

run the command as administrator:

C:\sapdb\S02\db\pgm\dbmdrop -d S02

If you didn't delete the UPC configuration files for S02 instance, it will be dropped.

Please be careful to run this command, as the data/log volumes will be deleted and config files for S02 will be lost.

Run "dbmcli db_enum" after that. After S02 will be dropped, you could uninstall the database instance software, SAP Note No. 1668638.

Run "C:\sapdb\programs\bin\sdbuninst -i S02

Or run "sdblaunch" from C:\sapdb\programs\bin as Administrator & go with uninstall the MAXDB software and select the correct options.

Regards, Natalia Khlopina

Former Member
0 Kudos

Hi,

SAP got in contact with me. The problem could be solved.

The problem was a destroyed shared memory, so a reboot and a repeat of the upgrde was the solution.

Best regards,

Christian

Answers (0)