Bitbucket Data Center is not coming up after an upgrade with "ORA-00257: Archiver error" error message in logs
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
After upgrading Bitbucket Data Center to the higher version, Bitbucket is not coming up and showing an "ORA-00257: Archiver error" error in the logs.
Error Message in atlassian-bitbucket.log
2024-11-05 10:20:00,221 ERROR [spring-startup] c.a.j.s.w.s.JohnsonDispatcherServlet SpringMVC dispatcher [springMvc] could not be started
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'licenseValidator' defined in class path resource [critical-context.xml]: Invocation of init method failed; nested exception is org.springframework.dao.DataAccessResourceFailureException: Unable to retrieve license details from the database: ; nested exception is java.sql.SQLException: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804)
at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanFactoryPostProcessors(PostProcessorRegistrationDelegate.java:171)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:756)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:573)
at javax.servlet.GenericServlet.init(GenericServlet.java:143)
at java.base/java.lang.Thread.run(Unknown Source)
... 22 frames trimmed
Caused by: org.springframework.dao.DataAccessResourceFailureException: Unable to retrieve license details from the database: ; nested exception is java.sql.SQLException: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.Environment
Tested on Bitbucket Data Center 8.19.10
Applicable to other Bitbucket Data Center versions.
Diagnosis
- Involve DBA team and check if there is any issue with Database.
Check the available space on the filesystem where the Oracle archive redo logs are stored. This can be done with the following SQL query and If the disk is full, try to free space.
show parameter log_archive;
Cause
"ORA-00257: Archiver Error" generally occurs when Database Archive log reached the FRA limit.
Solution
To overcome this issue, user need to clear the Archive logs or user may need to increase the FRA limit with help of DBA team.