Policy Server Fails To Start With ORA-25153 Errors (Doc ID 854242.1)

Last updated on OCTOBER 24, 2016

Applies to:

Oracle Communications IP Service Activator - Version 5.2.1 and later
Information in this document applies to any platform.

Symptoms

The Policy Server component failing to startup with the following messages in the log:

20090619-125953|0001|TRC1|Reading linkage table.
20090619-125953|0001|INF1|CTable: Execute failed: ORA-25153: Temporary Tablespace is Empty
...............|....|....|. Statement: select * from "Linkage" order by "Parent" ASC. Position:
14. Native Code: 25153
20090619-125953|0001|INF2|LinkageSet: DbReadLink failed. Reason: ORA-25153: Temporary Tablespace
is Empty
...............|....|....|
20090619-125953|0001|TRC1|Create linkage...
...............|....|....|
...............|....|....|CREATE TABLE "Linkage"
...............|....|....|(
...............|....|....| "Parent" INTEGER,
...............|....|....| "Child" INTEGER,
...............|....|....| CONSTRAINT Keying PRIMARY KEY ("Parent", "Child")
...............|....|....|)
...............|....|....|
20090619-125953|0001|INF1|CTable: Execute failed: ORA-00955: name is already used by an existing
object
...............|....|....|. Statement: CREATE TABLE "Linkage"
...............|....|....|(
...............|....|....| "Parent" INTEGER,
...............|....|....| "Child" INTEGER,
...............|....|....| CONSTRAINT Keying PRIMARY KEY ("Parent", "Child")
...............|....|....|)
...............|....|....|. Position: 13. Native Code: 955
20090619-125953|0001|INF1|CTable: ExecuteDirect failed. Reason: ORA-00955: name is already used by
an existing object
...............|....|....|
...............|....|....|Statement: CREATE TABLE "Linkage"
...............|....|....|(
...............|....|....| "Parent" INTEGER,
...............|....|....| "Child" INTEGER,
...............|....|....| CONSTRAINT Keying PRIMARY KEY ("Parent", "Child")
...............|....|....|)
...............|....|....|
20090619-125953|0001|CRT0|OSLogger: Policy Server: Opening database and table read failed:
ORA-00955: name is already used by an existing object
...............|....|....|
20090619-125953|0001|TRC2|Deleting CSptTransaction operations:0
20090619-125953|0001|TRC2|Deleting CSptTransaction operations:0
20090619-125953|0001|TRC2|CSptObjectModel::~CSptObjectModel: 0x0160a510
20090619-125953|0001|TRC2|CSptObjectModel::~CSptObjectModel: 0x0160a550
20090619-125956|0001|TRC2|Deleting CSptTransaction:0x0160a550
20090619-125956|0001|TRC2|Deleting CSptTransaction operations:0
20090619-125956|0001|TRC2|Deleting CSptTransaction:0x0160a510
20090619-125956|0001|TRC2|Deleting CSptTransaction operations:0
20090619-125957|0001|CRT0|Failed to initialise Object Model. Reason:<Exception
type="ServerException" reason="Couldn't create database instance of CSptApplication"
detail="file:/vobs/OSA/tornado/policy_server/PolicyServer.cpp,line:376,errno:9"/>

Changes

The IPSA system was failed over to another system. The failover system's DB instance did not have the temporary tablespace setup correctly.

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