RAC ONE: Relocate instance hangs as undo tablespace was dropped (Doc ID 2236066.1)

Last updated on MARCH 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

* RAC ONE Database with two nodes

* Relocating the DB hangs, the command executed was:

srvctl relocate database -db <db_unique_name> -node <target node>

* The alert for the database instance located on the target node shows the message:

[14052] no undo tbs, wait for pnp

* On the node where the instance was running originally the process RMS0 shows the messages:

* pnp work: # new threads that need to be created = 0
* pnp work: no new public threads are needed
* pnp work: online undo count(*) = 1
* pnp work: total number of undo tablespaces that need to be created = 1
* kjpnp_work: Error! OCIStmtFetch2 returned xffffffff
* kjpnp_work: OCI errcode = 1426
* kjpnp_work: OCI errbuf = ORA-01426: numeric overflow

* kjpnp_work: release PP enqueue and abort gpnp work

RMS0 closes PP enq

Those messages suggest the RDBMS found a single undo tablespace and needs to create another one, but somehow we got the error ORA-01426.

 

Changes

After the RAC ONE database was created, the undo tablespaces were recreated using bigfiles:

CREATE BIGFILE UNDO TABLESPACE <tablespace name>  DATAFILE SIZE 1G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

Eventually one undo tablespace was removed, leaving the database with a single undo tablespace.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms