Incorrect LiveCache Delete - cleanup when deleting LC manually?

[tj_wilkinson2]

Hello,

I incorrectly deleted livecache by removing /sapdb/<SID>/*.

Now when I run sdbuninst, it still shows <SID> as installed. I try to delete it an I get a bunch of messages about it can't delete the system because no files exist.

Can someone tell me how to clean this up? Thank you.

~TJ

[former_member229109 · Accepted solution]

Hello TJ,

1. If itu2019s not production system, and you are planning to uninstall the database software

=>

You could try to fix it by yourself:

• Run as root user the sdbverify to check the installed database software packages.

• Run u201Csdbregview u2013lu201D or u201Csdbuninst u2013lu201D to review the list of the valid/invalid installed database software packages.

• Run as root user :

cd /sapdb/programs/bin

./sdbverify --set_corrupted_invalid

Say u201CYu201D for the Database Kernel deleted manually

This sets the affected packages to invalid.

• Run u201Csdbregview u2013lu201D or u201Csdbuninst u2013lu201D to review the list of the invalid database software packages.

• Download the liveCache software from the SAP Market place.

Unpack it & sdbinst can now be used to install the software again.

The packages previously set to invalid are then installed again.

• After that you could follow the SAP Note No. 599129 < Uninstalling MaxDB/SAP DB software using SDBUNINST >. Please also review the SAP Note No. 1334206

2. Did you create the SAP ticket, where this issue was reported, as recommended by Lars?

Thank you and best regards, Natalia Khlopina

[tj_wilkinson2 · Accepted solution]

Natalia,

Thank you for the prompt response. Yes, I do have a message open. The number is: 6986 / 2010.

This is not a production, it's a sandbox. The other system on the same server is a development system.

I will try as you suggested. Thank you.

~TJ

[former_member229109 · Accepted solution]

Hello TJ,

You could try to fix it by yourself:

• Run as root user the sdbverify to check the installed database software packages.

• Run u201Csdbregview u2013lu201D or u201Csdbuninst u2013lu201D to review the list of the valid/invalid installed database software packages.

• Run as root user :

cd /sapdb/programs/bin

./sdbverify --set_corrupted_invalid

Say u201CYu201D for the Database Kernel deleted manually at /sapdb/LCX/db

This sets the affected packages to invalid.

• Run u201Csdbregview u2013lu201D or u201Csdbuninst u2013lu201D to review the list of the invalid database software packages.

• Download the liveCache software from the SAP Market place., SAP Note 1345427

May be you have already the liveCache software of the version 7.7.6.15, check it.

Unpack it & sdbinst can now be used to install the software again.

Go to the supdirectory created after you unpack the SAR file & run as root:

./sdbinst u2013package "Database Kernel"

< select the ID of LCX instance >

The packages previously set to invalid are then installed again.

• After that you could follow the SAP Note No. 599129 < Uninstalling MaxDB/SAP DB software using SDBUNINST >. Please also review the SAP Note No. 1334206

Did you already try those steps?

Thank you and best regards, Natalia Khlopina

[tj_wilkinson2 · Accepted solution]

I'm working on it now. When I ran the: ./sdbverify --set_corrupted_invalid, it didn't find any invalid packages, or ask me to set any as invalid. I already still had the software on the server, so I ran the install for the LCX instance and it put the '/sapdb/LCX' directory back, with files in it.

Per note 599129, I'm now going to try to delete LCX by running: sdbuninst -package "Database Kernel" -autoresolve and choosing the LCX option. I'm hoping this will finally clean up LCX and let me reinstall the older version - which was my whole reason for deleting it to begin with.

Thank you for checking.

~TJ

[tj_wilkinson2 · Accepted solution]

That resolved my issue. Thank you.

[lbreddemann]

Hi there!

You may want to open a support message for that.

Since the situation needs a thorough analysis before we know what and how should be done.

best regards,

Lars

[tj_wilkinson2]

I opened a message - here are the details. Also, there's another livecache instance on the same server (LCD) so whatever I do to clean up LCX needs to leave LCD intact. Thank you.

Hello,

I am trying to uninstall livecache and I incorrectly deleted livecache by

removing /sapdb/LCX/* and /sapdb/data/wrk/LCX/*.

Now when I run: ./sdbuninst -package "Database Kernel" -autoresolve ...

It shows LCX still installed:

existing packages:

0: Database Kernel in /sapdb/LCX/db 7.7.6.15

1: Database Kernel in /sapdb/LCD/db 7.7.03.22 64 bit

2: none

If I select 0 to delete LCX, the first time it listed a bunch of files it

couldn't delete because they didn't exist.

The second time I ran ./sdbuninst -package "Database Kernel" -autoresolve

I got ...

0: Database Kernel in /sapdb/LCX/db 7.7.6.15

1: Database Kernel in /sapdb/LCD/db 7.7.03.22 64 bit

2: none

Again, I tried to delete 0 for LCX ...

uninstall following package(s):

Database Kernel /sapdb/LCX/db 7.7.6.15

start uninstallation now (y/n)?y

unregister Database Kernel 7.7.6.15

done

However, if I run ./sdbuninst -package "Database Kernel" -autoresolve a

third time, it still shows that LCX exists:

0: Database Kernel in /sapdb/LCX/db 7.7.6.15

1: Database Kernel in /sapdb/LCD/db 7.7.03.22 64 bit

2: none

How do I clean this up? Thank you.

~TJ