SV- Unable to start Registry error -ORA-01658

book

Article ID: 186031

calendar_today

Updated On:

Products

CLOUDTEST CA Application Test CA Cloud Test Mobile MOBILECLOUD Service Virtualization

Issue/Introduction

We are getting the below error message when we try to connect Oracle database with Registry. The Registry started successfully when we start first time with Derby, but started getting this error after trying to start with Oracle. Attached the registry log with this case.



Error in Registry : 

ORA-01658 unable to create initial extent for segment in tablespace sysaux

2020-03-02 16:32:38,855Z (11:32) [main] WARN  org.eclipse.persistence        - org.eclipse.persistence   WARNING:   Local Exception Stack:   Exception [EclipseLink-4011] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException  Exception Description: Error preallocating sequence numbers.  The sequence table information is not complete.  at org.eclipse.persistence.exceptions.DatabaseException.errorPreallocatingSequenceNumbers(DatabaseException.java:143)  at org.eclipse.persistence.sequencing.StandardSequence.getGeneratedVector(StandardSequence.java:73)  at org.eclipse.persistence.sequencing.DefaultSequence.getGeneratedVector(DefaultSequence.java:163)  at org.eclipse.persistence.sequencing.Sequence.getGeneratedVector(Sequence.java:257)  at 

2020-03-02 16:32:38,855Z (11:32) [main] ERROR com.itko.lisa.coordinator.TestRegistryImpl - 

The Enterprise Dashboard Server at 'https://wsvl216a.qa.pncint.net:1506'

could not be contacted, and no current activation was found in the local

activation cache for this registry.


This registry will not be allowed to start until it can be activated by a

valid Enterprise Dashboard Server.

Please contact your DevTest System Administrator or contact

CA Customer Support for more information.2020-03-02 16:32:38,870Z (11:32) [Thread-6] INFO  com.itko.lisa.net.ActiveMQFactory - Closing AMQ connections

Cause

ORACLE issue: Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.

Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL.

Environment

Release : 10.6

Component : CA Service Virtualization

Resolution


Work with your DBA  to get this resolved.  Not a DEVTEST issue.  


Here are some suggestions:


ORA-01658: unable to create INITIAL extent for segment in tablespace string

Cause: Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.

Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL.

The obvious cure for the ORA-01657 error is to:

1 - Make the INITIAL extent size smaller

2 - Empty the recycle bin



Additional Information

http://www.dba-oracle.com/sf_ora_01658_unable_to_create_initial_extent_for_segment_in_tablespace_string.htm