It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

migrating Confluence to another server

Hi, 

We need to create a ditto copy of our Confluence production server which has a huge amount of data. We want to do it for our test purposes. To achieve this, we followed below process.

1) Copied the existing app folder to new server at the same path.

2) Copied database (Oracle 12C) to a new server and gave it a new name.

3) Installed Confluence (same version, 7.1.2) on new server.

4) Set application-data in new installation

5) modified the confluence.cfg.xml file to reflect new database name.

 

After this we started Confluence on new instance. It starts and we are able to open it. But we are not able to login into it. 

In the logs it gives lots database related errors. Like below:

 

*****************

Caused by: Error : 955, Position : 13, Sql = CREATE TABLE "AO_7CDE43_SERVER_CONFIG" (
"CUSTOM_TEMPLATE_PATH" CLOB,
"DEFAULT_USER_ID_TEMPLATE" VARCHAR(255),
"ENABLED_FOR_ALL_USERS" NUMBER(1),
"GROUPS_WITH_ACCESS" CLOB,
"ID" NUMBER(11) NOT NULL,
"NOTIFICATION_MEDIUM_KEY" VARCHAR(255),
"SERVER_NAME" VARCHAR(255),
PRIMARY KEY("ID")
), OriginalSql = CREATE TABLE "AO_7CDE43_SERVER_CONFIG" (
"CUSTOM_TEMPLATE_PATH" CLOB,
"DEFAULT_USER_ID_TEMPLATE" VARCHAR(255),
"ENABLED_FOR_ALL_USERS" NUMBER(1),
"GROUPS_WITH_ACCESS" CLOB,
"ID" NUMBER(11) NOT NULL,
"NOTIFICATION_MEDIUM_KEY" VARCHAR(255),
"SERVER_NAME" VARCHAR(255),
PRIMARY KEY("ID")
), Error Msg = ORA-00955: name is already used by an existing object

 

***************

It seems it is trying to re-create all the tables. Can someone please guide as what wrong are we doing here. We just want to create a mirror image of Confluence server. Instead of using Confluence's own backup-restore function. We are trying to use direct copy from server to server and db to new db.

 

Regards

Sanan

 

3 answers

0 votes
DPK_J Community Leader Dec 20, 2019

I suggest you to follow step mentioned below, this know issue with Confluence and Oracle.

https://confluence.atlassian.com/confkb/ora-00955-name-is-already-used-by-an-existing-object-317949251.html

0 votes

Hi,

before upgrading/installing Confluence 7 on the new server, I would try to get it running with the old version. As we don't use Oracle I can only describe my steps when setting up a test/staging server:

1. Make a consistent backup of the Confluence database & restore the backup on the test database server using the SAME db name / schema etc...

2. Stop Confluence & create a copy of the install & data directories. Restart Confluence.

3. Restore the install & data directory on the test/staging application server using the exact same directory structure & access rights.

4. Edit the server.xml (Tomcat configuration) in the conf subdir

We use datasources controlled by Tomcat & not Confluence specific datasources. Therefore I only have to configure the resource settings for the JDBC datasource to point to the test/staging db server & check user & password.

I also configure disable mails send from the test server by setting:

 -Datlassian.mail.senddisabled to true

in the system properties.

https://confluence.atlassian.com/doc/configuring-system-properties-168002854.html

5. Depending on your server OS, you might want to register Confuence as a service.

6. Start the test server using the same user name used on your production server.

The test server should startup without any errors, apart from the disabled mailing.

Any upgrades to Confluence 7 should be done AFTER a successful migration to the test server.

Best

JP

Hi JP,

After renaming the schema and user name same as old db. it has has worked. Now db is able to connect.

thanks for the tip.

 

regards

sanan

problem is solved.

Thanks for the replies.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

How is your team having fun and bonding, remotely, utilizing Confluence?

Thanks everyone for answering last week’s question. The winner of the random drawing from those who commented is: @LarryBrock I’ll contact you separately with your prize details. This wee...

327 views 9 7
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you