topic ISE - CSCty54756 - how do I reindex a ISE database? Need help pl in Network Access Control

ISE - CSCty54756 - how do I reindex a ISE database? Need help please!

JParks1979 — Mon, 11 Mar 2019 03:34:15 GMT

Anybody know how to implement the workaround below?

Indexes got corrupted in MNT DB

Symptom:
The ISE Dashboard will not show up any activities and when checked in the mnt-collector.out log file from support bundle you will see indexing errors
Conditions:
If you see indexing error as below :
java.sql.SQLException: ORA-01502: index 'MNT.SYS_C0011721' or partition of such index is in unusable state.
java.sql.SQLException: ORA-01502: index 'MNT.SYS_C0011720' or partition of such index is in unusable state
Workaround:
As a quick workaround Indexes needs to be re-executed and all this execution needs to be done under the guidance of MNT Dev
Further Problem Description:
When you observe if the dash board is not logging any information , even though authentications are happening successfully , then when we check the support bundle for mnt-collector.out log and if we happen to see the above SQL Exceptions , we can conclude that due to index errors , dash board is not writing any logs.

ISE - CSCty54756 - how do I reindex a ISE database? Need help pl

Marcin Latosiewicz — Fri, 21 Jun 2013 16:15:19 GMT

Open up a TAC case. The guys will help you get this running or check for the error.

Basically they need to access DB on MNT node.

Re: ISE - CSCty54756 - how do I reindex a ISE database? Need hel

JParks1979 — Sat, 22 Jun 2013 03:36:34 GMT

Thanks i TAC'd it. Appreciate the quick response

Sent from Cisco Technical Support iPhone App

ISE - CSCty54756 - how do I reindex a ISE database? Need help pl

harvisin — Mon, 01 Jul 2013 05:57:23 GMT

Hello,

I went through your query and I would suggest you to go for TAC, they would be help you out.

ISE - CSCty54756 - how do I reindex a ISE database? Need help pl

JParks1979 — Mon, 01 Jul 2013 15:43:30 GMT

FYI I opened up TAC case and was provided with a utility to download to the ISE appliance which gives you root access as well as extra CLI commands to indentify and correct the corrupt the indexes. Once this was done the issue was resolved.

Hello all,I actually have the

Isah Mohammed — Fri, 07 Nov 2014 09:17:22 GMT

Hello all,

I actually have the same problem with my Cisco ISE with Dashboard showing nothing and cisco ISE returning Database Failure like as shown below:

"Database failure (nnpc-ise, Posture)
Exception:
ORA-01502: index 'MNT.SYS_C0011756' or partition of such index is in unusable state"

Kindly advise me on how i can fix this error.

NOTE: I AM USING CISCO AS AS STANDALONE MODE I DO NOT HAVE MONITORING NODE.

What is ISE version and patch

Venkatesh Attuluri — Fri, 14 Nov 2014 10:44:40 GMT

What is ISE version and patch level. Is this machine virtual or appliance. What is the disk space allocated