on 11-15-2012 9:47 AM
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
Global | C:\sapdb\programs | 7.9.08.04 |
Legacy | C:\sapdb\programs | 7.6.00.35 |
S02 | C:\sapdb\S02\db | 7.8.02.23 not running system |
CL_S01 | C:\sapdb\clients\S01 | 7.8.02.30 |
CL_S02 | C:\sapdb\clients\S02 | 7.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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.