ORA-01658 error during Registry start up
Article ID: 246124
Updated On:
Products
Issue/Introduction
Post upgrading to 10.7.2 the registry service is not coming post starting it get crashed after couple of seconds.
Below error is seen in Registry log but the DB users having same permissions could complete upgrade the fine for other Registries of UAT environment.
2022-07-17T09:19:32,411Z (05:19) [main] INFO com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard - Checking if any database structure changes need to be done.
2022-07-17T09:19:32,505Z (05:19) [main] INFO com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard - No database structure changes required in module REPORTING
2022-07-17T09:19:32,505Z (05:19) [main] INFO com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard - No database structure changes required in module ACL
2022-07-17T09:19:32,505Z (05:19) [main] INFO com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard - No database structure changes required in module VSE
2022-07-17T09:19:32,520Z (05:19) [main] INFO com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard - Upgrading previous DevTest version 10.5.2 to 10.7.2
2022-07-17T09:19:32,520Z (05:19) [main] INFO com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard - Checking if upgrade will be possible
2022-07-17T09:19:32,708Z (05:19) [main] ERROR System.err - [DevTest AGENT:][ERROR][5704][13][main][Jul 17, 2022 5:19:32 AM] !!!!!!!! Database user permission check failed !!!!!!!!
2022-07-17T09:19:33,849Z (05:19) [main] ERROR System.err - [DevTest AGENT:][ERROR][5704][13][main][Jul 17, 2022 5:19:33 AM] Please ensure the user has privileges to create/alter/drop table, view and index and manipulate data.
2022-07-17T09:19:34,864Z (05:19) [main] ERROR System.err - [DevTest AGENT:][ERROR][5704][13][main][Jul 17, 2022 5:19:34 AM] Failed statement: INSERT INTO LISA_TEMP_TABLE1__ VALUES ('A', 'B') Error: ORA-01658: unable to create INITIAL extent for segment in tablespace DEVTEST_16_APP_DATA_TBS
2022-07-17T09:19:35,990Z (05:19) [main] ERROR com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard - DDLs cannot be executed in this module REPORTING database user does not have sufficient permissions.
2022-07-17T09:19:35,990Z (05:19) [main] ERROR com.itko.lisa.coordinator.TestRegistryImpl - Database initialization is not possible in module REPORTING. Not enough db permissions to execute DDL statements.
com.itko.lisa.exception.UpgradeException: Database initialization is not possible in module REPORTING. Not enough db permissions to execute DDL statements.
at com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard.checkIfAllDatabasesAreWritable(DatabaseSafeGuard.java:157) ~[lisa-core-10.7.2.jar:?]
at com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard.checkIfMigrationIsPossible(DatabaseSafeGuard.java:134) ~[lisa-core-10.7.2.jar:?]
at com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard.checkIfDatabaseCanBeChanged(DatabaseSafeGuard.java:104) ~[lisa-core-10.7.2.jar:?]
at com.itko.lisa.coordinator.TestRegistryImpl.main(TestRegistryImpl.java:2178) [lisa-core-10.7.2.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_232]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_232]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_232]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_232]
at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:84) [i4jruntime.jar:?]
at com.exe4j.runtime.WinLauncher$2.run(WinLauncher.java:90) [i4jruntime.jar:?]
Environment
Release : 10.7.2
Component : DevTest Registry
Cause
The issue happened for this Registry due to the low tablespace for this DB schema and the Registry DB user tried to acquire more tablespace but failed due to insufficient permissions. This was not the issue in other Registry DBs and hence they passed with available permissions because no structural change was needed.
Resolution
Engage the DBA to check and increase the table space as required. Then restart the Registry and it would start fine as it didn't had to run any command that needs extra privileges.
Feedback
