错误 ：ORA-20000: index "INTER"."SCHEDULE_INDEX_100" or partition of such index is in unusable state

错误 ：ORA-20000: index "INTER"."SCHEDULE_INDEX_100"  or partition of such index is in unusable state
结果：导致数据挂掉
监听状态：lsnrctl status
数据库状态：ps -ef|grep ora_


方法：
1、启动数据
startup


2、启动监听
lsnrctl start


3、登录数据查看不可用索引
SQL> select owner, index_name,status from dba_indexes where status='UNUSABLE';


OWNER        INDEX_NAME       STATUS
------------------------------ ------------------------------ --------
INTER        SCHEDULE_INDEX_100       UNUSABLE


SQL> set linesize 200
SQL> select owner, index_name,status,TABLE_NAME from dba_indexes where status='UNUSABLE';


OWNER        INDEX_NAME       STATUS   TABLE_NAME
------------------------------ ------------------------------ -------- ------------------------------
INTER        SCHEDULE_INDEX_100       UNUSABLE PBOSS_BUSI_SCHEDULE_100


4、重建索引
ALTER INDEX inter.SCHEDULE_INDEX_100 REBUILD;