当前位置:网站首页>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
边栏推荐
- Oracle renames objects
- 零拷贝技术
- JS compares different elements in two arrays
- On the bug of JS regular test method
- SAP UI5 应用开发教程之七十二 - SAP UI5 页面路由的动画效果设置
- Ai21 labs | standing on the shoulders of giant frozen language models
- Solution: you have 18 unapplied migration (s) Your project may not work properly until you apply
- torch. Where can transfer gradient
- Window function row commonly used for fusion and de duplication_ number
- Ding ~ your scholarship has arrived! C certified enterprise scholarship list released
猜你喜欢
Tersus notes employee information 516 MySQL query (time period uniqueness judgment of 2 fields)
Opening: identification of double pointer instrument panel
Apache Atlas Compilation and installation records
The interviewer dug a hole for me: how many concurrent TCP connections can a single server have?
[machine learning] Note 4. KNN + cross validation
[indicators] precision, recall
According to the salary statistics of programmers in June 2021, the average salary is 15052 yuan. Are you holding back?
MySQL and PgSQL time related operations
Android clear app cache
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
随机推荐
On the bug of JS regular test method
Machine learning -- PCA and LDA
Playwright contrôle l'ouverture de la navigation Google locale et télécharge des fichiers
SAP ui5 application development tutorial 72 - trial version of animation effect setting of SAP ui5 page routing
Oracle creates tablespaces and modifies user default tablespaces
Android clear app cache
Oracle database combines the query result sets of multiple columns into one row
Interface idempotency problem
Oracle renames objects
Common commands of ADB shell
Core concepts of microservice architecture
Xi'an CSDN signed a contract with Xi'an Siyuan University, opening a new chapter in IT talent training
sys. dbms_ scheduler. create_ Job creates scheduled tasks (more powerful and rich functions)
Storage scheme of video viewing records of users in station B
Comparison and summary of applicable scenarios of Clickhouse and MySQL database
Plato farm, a top-level metauniverse game, has made frequent positive moves recently
Test the time required for Oracle library to create an index with 7 million data in a common way
Campus takeout system - "nongzhibang" wechat native cloud development applet
[Video] Bayesian inference in linear regression and R language prediction of workers' wage data | data sharing
RTOS mainstream assessment