We cleared the Oracle schema and restarted Jira. After Importing a backup file from the import wizard results in "JIRA has already been set up." While no other errors were reported, I was unable to log in which seems to indicate that the data was not successfully imported.
Any suggestions would be appreciated.
Hi @Richard Scire, could you please paste the steps of clearing schema here, and make a screenshot for your problem? It seems the JIRA database has not been removed successfully.
Here are the steps as provided by the DBA:
- SA Brought down Jira
- Took an export backup of the JIRAUSER schema
- Dropped the schema with all its objects:
- drop user JIRAUSER cascade;
- Recreated the schema:
- CREATE USER "JIRAUSER"
- IDENTIFIED BY XXXXXXX
- DEFAULT TABLESPACE "JIRA_DATA"
- TEMPORARY TABLESPACE "TEMP"
- ACCOUNT UNLOCK ;
- Gave the necessary grants and quota:
- ALTER USER "JIRAUSER" QUOTA UNLIMITED ON JIRA_DATA;
- grant connect to jirauser;
- grant create table to jirauser;
- grant create sequence to jirauser;
- grant create trigger to jirauser;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Also , you can try drop the database and recreate it, grant the needed permissions and then start the import from xml
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.