ORA-12012 Error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_<NN> in 12.2.0 Database
2023-09-27 14:26:42 时间
报错如下:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_88"
ORA-20001: Statistics Advisor: Invalid Task Name For the current user <== Note it
ORA-06512: at "SYS.DBMS_STATS", line 46861
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 734
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 19930
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 21934
ORA-06512: at "SYS.DBMS_STATS", line 46851
解决办法:
$ sqlplus / as sysdba
SQL> EXEC dbms_stats.init_package();
参考文档:ORA-12012 Error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_<NN> in 12.2.0 Database version or higher release (like 18c) (文档 ID 2127675.1)
相关文章
- 'database' is compressed but does not reside in a read-only database or filegroup
- Getting ready for SQL Database
- How to: Update an .edmx File when the Database Changes
- ORA-38760: This database instance failed to turn on flashback database
- Oracle Database 12c Release 2安装详解
- 【英文讲座】Paradigm Shift to Enterprise In-Memory Database Era...
- How to set character_set_database and collation_database to utf8 in my.ini
- How To Backup and Restore PostgreSQL Database using pg_dump and psql
- 【Database】关于SQL Server
- DBCP( 二) DataBase Connection Pool 的使用
- Oracle Database Releases and Support Timelines
- Graph database_neo4j 底层存储结构分析(3)
- Oracle RAC Database 11.1.0.6监听故障案例
- EM 12c: OMS Failed to start After restarting the Repository Database or reboot of the server
- Database returned an invalid value in QuerySet.datetimes(). Are time zone definitions for your datab
- Attempt to fetch logical page (1:164360) in database 17 failed. It belongs to allocation unit 72057594328317952 not to 281474980642816.