当前位置:网站首页>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
边栏推荐
- Opening: identification of double pointer instrument panel
- Double pointer instrument panel reading (I)
- Isparta is a tool that generates webp, GIF and apng from PNG and supports the transformation of webp, GIF and apng
- PG library to view the distribution keys of a table in a certain mode
- SAP UI5 应用开发教程之七十二 - SAP UI5 页面路由的动画效果设置
- [Journal Conference Series] IEEE series template download guide
- What does the SQL name mean
- Interval query through rownum
- Solution: you have 18 unapplied migration (s) Your project may not work properly until you apply
- Error 403 in most cases, you or one of your dependencies are requesting
猜你喜欢

Tersus notes employee information 516 MySQL query (time period uniqueness judgment of 2 fields)

零拷贝技术
![[point cloud series] foldingnet: point cloud auto encoder via deep grid deformation](/img/c0/cc29ae6948dbe42954cd9da326ef77.png)
[point cloud series] foldingnet: point cloud auto encoder via deep grid deformation
![[barycentric coordinate interpolation, perspective correction interpolation] principle and usage opinions](/img/db/2e7d7f519f97f0c4179a29af8942a6.png)
[barycentric coordinate interpolation, perspective correction interpolation] principle and usage opinions
![[point cloud series] so net: self organizing network for point cloud analysis](/img/3c/6136b7aa322c42089f40ce13a2d747.png)
[point cloud series] so net: self organizing network for point cloud analysis

"Xiangjian" Technology Salon | programmer & CSDN's advanced road

校园外卖系统 - 「农职邦」微信原生云开发小程序

How do ordinary college students get offers from big factories? Ao Bing teaches you one move to win!

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

顶级元宇宙游戏Plato Farm,近期动作不断利好频频
随机推荐
PG library to view the distribution keys of a table in a certain mode
【视频】线性回归中的贝叶斯推断与R语言预测工人工资数据|数据分享
Detailed explanation of Oracle tablespace table partition and query method of Oracle table partition
TCP 复位gongji原理和实战复现
Why do you need to learn container technology to engage in cloud native development
Solve tp6 download error course not find package topthink / think with stability stable
Two ways to deal with conflicting data in MySQL and PG Libraries
GDB的使用
Operations related to Oracle partition
为什么从事云原生开发需要学习容器技术
交叉碳市场和 Web3 以实现再生变革
Usereducer basic usage
Software test system integration project management engineer full truth simulation question (including answer and analysis)
Launcher hides app icons that do not need to be displayed
Oracle database recovery data
PG SQL intercepts the string to the specified character position
Lenovo Savior y9000x 2020
Parameter comparison of several e-book readers
Processbuilder tool class
Solution: you have 18 unapplied migration (s) Your project may not work properly until you apply