当前位置:网站首页>RAC environment alert log error drop transient type: systp2jw0acnaurdgu1sbqmbryw = = troubleshooting
RAC environment alert log error drop transient type: systp2jw0acnaurdgu1sbqmbryw = = troubleshooting
2022-04-23 13:42:00 【Not dizzy yet】
In recent daily inspection , A user found RAC An error is reported in the environment :
*** 2022-02-22 19:34:58.672
Drop transient type: SYSTP2JW0acnAurDgU1sBqMBryw==
Inquire about ORACLE MOS Website , Similar problems with documentation :Receiving ORA-21780 Continuously in the Alert Log and SMON Trace Reports "Drop transient type". (Doc ID 1081950.1).
The simple explanation is SMON There was a problem cleaning up these objects , Only in RAC The environment appears ; Two processing schemes are given in the document , as follows :
There are two possible solutions.
Solution #1
------------
Step 1
Make sure you have a good full backup.
Step 2
spool obj.lis
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
set pagesize 1000
select o.* from obj$ o, type$ t
where o.oid$ = t.tvoid and
bitand(t.properties,8388608) = 8388608 and (sysdate-o.ctime) > 0.0007;
spool off
Step 3
Find the object owner:
Step 4
Drop the objects.
DROP TYPE "SYSTPf/r2wN4keX7gQKjA3AFMSw==" FORCE;
Solution #2
------------
You can prevent SMON to cleanup transient types by setting event 22834 like below.
However, this can cause transient types to increase.
SQL> alter system set events '22834 trace name context forever, level 1';
System altered.
To turn off:
SQL> alter system set events '22834 trace name context off' ;
System altered.
版权声明
本文为[Not dizzy yet]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204230601579765.html
边栏推荐
- [tensorflow] sharing mechanism
- Feature Engineering of interview summary
- Oracle and MySQL batch query all table names and table name comments under users
- Oracle database combines the query result sets of multiple columns into one row
- Django::Did you install mysqlclient?
- Solve tp6 download error course not find package topthink / think with stability stable
- Oracle view related
- 集简云 x 飞书深诺,助力企业运营部实现自动化办公
- Comparison and summary of applicable scenarios of Clickhouse and MySQL database
- Oracle kills the executing SQL
猜你喜欢

为什么从事云原生开发需要学习容器技术

Example interview | sun Guanghao: College Club grows and starts a business with me
![[official announcement] Changsha software talent training base was established!](/img/ee/0c2775efc4578a008c872022a95559.png)
[official announcement] Changsha software talent training base was established!
![[barycentric coordinate interpolation, perspective correction interpolation] principle and usage opinions](/img/db/2e7d7f519f97f0c4179a29af8942a6.png)
[barycentric coordinate interpolation, perspective correction interpolation] principle and usage opinions

聯想拯救者Y9000X 2020

Ai21 labs | standing on the shoulders of giant frozen language models

PG SQL intercepts the string to the specified character position

TIA博途中基于高速计数器触发中断OB40实现定点加工动作的具体方法示例

Static interface method calls are not supported at language level '5'

QT calling external program
随机推荐
Generate 32-bit UUID in Oracle
JS time to get this Monday and Sunday, judge the time is today, before and after today
TIA博途中基于高速计数器触发中断OB40实现定点加工动作的具体方法示例
torch. Where can transfer gradient
Lenovo Savior y9000x 2020
"Xiangjian" Technology Salon | programmer & CSDN's advanced road
Logstash数据处理服务的输入插件Input常见类型以及基本使用
Remove the status bar
Oracle lock table query and unlocking method
【重心坐标插值、透视矫正插值】原理以及用法见解
TCP reset Gongji principle and actual combat reproduction
为什么从事云原生开发需要学习容器技术
MySQL and PgSQL time related operations
Oracle view related
Usereducer basic usage
Longitude and latitude position of provincial capitals in China
Oracle defines self incrementing primary keys through triggers and sequences, and sets a scheduled task to insert a piece of data into the target table every second
Tangent space
Static interface method calls are not supported at language level '5'
[Journal Conference Series] IEEE series template download guide