• Community
  • Products
  • Jira
  • Questions
  • Why am I am getting the message, The database specified is not empty. Please specify an empty database for your installation.

Why am I am getting the message, The database specified is not empty. Please specify an empty database for your installation.

() I am getting this message when I tried to test the external Oracle Database connection when I downloaded JIRA and started to install the application. I tried to test the database connection but it was giving me this message. Can anyone tell me why this error message is popping up? Please advise.

5 answers

1 accepted

1 vote
Accepted answer

Do you have prior data in the DB? As the error message indicates, connect to an empty database.

Yes I have prior data in the database but I recently another Install of JIRA 4.4.4 on another server and I successfully tested the database connection and it worked. Why would it give me a problem now?

Did you perform and upgrade or didnt you perform a clean install at that time? For new installation it expects that the database is empty.

I tried Jira 5.2.5 32bit Windows installer on 32bit Windows 2008 with IE9 and hit the same problem when trying to connect to an external Oracle 11g fresh created new DB instance. I did have other DB instances running on the same Oracle host. Maybe Jira is not happy with other DB instance running side by side with its DB?! :-)

I created a brand new user and granted it with the 4 user rights mentioned in the Jira doc. Also I created a seperated new tablespace and made it the default for the new user. Then I connected the DB with this new user and was able to bypass the complaint about the "DB not empty". However, I still have problem with AD ldap user login if my Jira 5.2.5 (also 5.2.1) is connected to Oracle 11g DB.

Lando from AI.

0 votes

This error might be caused by the bug below which was fixed on JIRA 5.2.5:

The error is only displayed using the JIRA Setup Wizard, and the workaround for those using a version prior to the fix is to manually edit the dbconfig.xml file or to run the JIRA Configuration Tool to configure the DB. This workaround is also detailed on the bug above.

So I assume we should not have such problems with JIRA 5.7.5. But we do have. Initially we were using a cloned database (as we like to test a newer version of JIRA on a test system before permorming an upgrade) in order to switch from embedded database to Oracle database. Then we tried the JIRA configuration tool. Worse. Then again with the wizard and an emptied database strongly according to the documentation. Conclusion: what is the definition on an empty database?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,723 views 17 21
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you