Can Undo Tablespace share across multiple DB nodes?

Posted by Hari on Jul 31, 2018; 12:19pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Can-Undo-Tablespace-share-across-multiple-DB-nodes-tp6518.html

Dear Erman,

We have a 5 Node RAC Database for one of my Production Instance. Today we have faced an issue for Undo Tablespace.

There was Concurrent Programs which were running on DB node 1 which has failed with ORA-01555 Snapshot too old error.

The program was running on node 1 had used Undo Segment which belongs to node 5 undo tablespace which has almost 100% used.

my questions are
1. Can Undo Tablespace share across multiple node?
2. If yes, how can we share it? If the answer is No, How it happened today in my environment? Is there logic to access different db node undo segment?

CONCURRENT_QUEUE_NAME     USER_CONCURRENT_QUEUE_NAME                         PROCESS_COUNT NODE_NAME       DB_INSTANCE

------------------------- -------------------------------------------------- ------------- --------------- ----------------

SALES                   SALES                                                   50 hostname       inst_1

SQL> select instance_num,TABLESPACE_NAME, SEGMENT_NAME from dba_rollback_segs where SEGMENT_NAME='_SYSSMU2604_3127774908$';

INSTANCE_NUM                             TABLESPACE_NAME                SEGMENT_NAME
---------------------------------------- ------------------------------ ------------------------------
5                                        APPS_UNDOTS5                   _SYSSMU2604_3127774908$



Thanks In Advance.

Thanks,
Hari.