ORA-01552 and ORA-00942 Rollback Segments Offline Received During Installation (Doc ID 949371.1)

Last updated on DECEMBER 30, 2016

Applies to:

Oracle Communications ASAP - Version 4.2.0 and later
Information in this document applies to any platform.
***Checked for relevance on 29-January-2014***

Symptoms

This is a fatal error that can occur when installing ASAP.

This error occurs because when ASAP's Oracle database was created, the rollback segments where offline by default. These rollback segments have to be online by the Oracle system account.

The ASAP installation will have to be redone.

These errors are found in the ASAP installation file CreateDatabase.log:

...<cut>...

Convert 'SARM' DB index tablespace to [SARM_INDEX]
Populating static database definitions ...
Populating database definition for CTRL (control.sql)

Sequence created.

'Loading tables/IDENTITY.i'
CHECK (opt5_type = null or opt5_type like '-_'),
*
ERROR at line 18:
ORA-01552: cannot use system rollback segment for non-system tablespace 'ASAP_DATA'


'Loading tables/alrm_cent.i'
CREATE TABLE tbl_alarm_log (
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace 'ASAP_DATA'

...<cut>...

'Loading tables/server_info.i'
CREATE UNIQUE INDEX idx1_alarm_center ON tbl_alarm_center
*
ERROR at line 1:
ORA-00942: table or view does not exist


CREATE UNIQUE INDEX idx1_appl_proc ON tbl_appl_proc
*
ERROR at line 1:
ORA-00942: table or view does not exist

...<cut>...

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