Problem Migrating to Oracle DB using... :: JetBrains Developer Community

Up to Discussions in General Topics

10 Replies Last post: Feb 5, 2010 1:34 AM by steven dunning

steven dunning

26 posts since
May 28, 2009

Currently Being Moderated

Jan 25, 2010 11:26 PM

Problem Migrating to Oracle DB using MaintainDB Utility

Trying to migrate from internal database to an Oracle database. MaintainDB seems to "hang" after attempt to connect to Oracle. I had an account setup name 'teamcity' with permissions as specified on http://www.jetbrains.net/confluence/display/TCD5/Setting+up+an+External+Database

Here is my command line:

C:\TeamCity\bin>maintainDB migrate -T D:\TeamCity\.BuildServer\config\database.oracle.properties -A D:\TeamCity\.BuildServer

and the output:

TeamCity maintenance tool. (C) 2000-2009 JetBrains s.r.o.

Command line arguments: migrate -T D:\TeamCity\.BuildServer\config\database.oracle.properties -A D:\TeamCity\.BuildServer
Using TeamCity data directory: D:\TeamCity\.BuildServer
Using internal database.
Using source database
        database type: HSQLDB
        database driver: org.hsqldb.jdbcDriver
        connection: jdbc:hsqldb:file:D:\TeamCity\.BuildServer/system/buildserver

        login as: <empty>
Connected to the Source DB successfully.
Using explicitly specified target database settings: D:\TeamCity\.BuildServer\config\database.oracle.properties
Using target database
        database type: ORACLE
        database driver: oracle.jdbc.driver.OracleDriver
        connection: jdbc:oracle:thin:@dvlp2
        login as: teamcity

Contents of database properties file:

driverName=oracle.jdbc.driver.OracleDriver
connectionUrl=jdbc:oracle:thin:@dvlp2
connectionProperties.user=teamcity
connectionProperties.password=teamcity

maxConnections=50

connectionProperties.SetBigStringTryClob=true

validationQuery=select 1 from dual

Marina Grechko

600 posts since
Oct 12, 2009

Currently Being Moderated

Jan 27, 2010 5:25 PM

in response to: steven dunning

Re: Problem Migrating to Oracle DB using MaintainDB Utility

Steven,

Do you still have the problem?

Could you please take a thread dump at the moment when the tool is hanging.

Report Abuse

steven dunning

26 posts since
May 28, 2009

Currently Being Moderated

Jan 27, 2010 8:01 PM

in response to: Marina Grechko

Re: Problem Migrating to Oracle DB using MaintainDB Utility

Dump file is attached.

Attachments:

TC_MaintainDB_Dump.txt.zip (1.1 K)

Report Abuse

Marina Grechko

600 posts since
Oct 12, 2009

Currently Being Moderated

Jan 29, 2010 3:05 PM

in response to: steven dunning

Re: Problem Migrating to Oracle DB using MaintainDB Utility

Thank you for the feedback!

According to the dump, there is an error connecting to the database, but maintainDB do not reporting the error. We've created an issue for the problem, please watch it at http://youtrack.jetbrains.net/issue/TW-10860.

Could you please check that database properties are correct and you able to connect to the database with this properties under the same account as TeamCity uses?

Report Abuse

steven dunning

26 posts since
May 28, 2009

Currently Being Moderated

Jan 29, 2010 5:08 PM

in response to: Marina Grechko

Re: Problem Migrating to Oracle DB using MaintainDB Utility

I am able to connect to Oracle via the Windows client using the same credentials that are supplied in the database.properties file. The only thing that I can think of at the moment is that perhaps there is an error with the connectionUrl property or a problem with the Oracle client jars TC is using.

Report Abuse

Pavel Sher

Currently Being Moderated

Feb 1, 2010 8:49 PM

in response to: steven dunning

Re: Problem Migrating to Oracle DB using MaintainDB Utility

Steven, do you have a TeamCity server running when you start migration? If so, try again with stopped TeamCity server.

---

Original message URL: http://www.jetbrains.net/devnet/message/5255674#5255674

steven dunning

26 posts since
May 28, 2009

Currently Being Moderated

Feb 1, 2010 9:22 PM

in response to: Pavel Sher

Re: Problem Migrating to Oracle DB using MaintainDB Utility

TeamCity server was in fact stopped when I attempted migration.

Report Abuse

Pavel Sher

2,081 posts since
Mar 6, 2008

Currently Being Moderated

Feb 1, 2010 9:26 PM

in response to: steven dunning

Re: Problem Migrating to Oracle DB using MaintainDB Utility

Please ignore my last comment, it was not related to this issue.

Report Abuse

Leonid Bushuev

134 posts since
Sep 30, 2002

Currently Being Moderated

Feb 2, 2010 5:21 PM

in response to: steven dunning

Re: Problem Migrating to Oracle DB using MaintainDB Utility

Hello Steven,

> connectionUrl=jdbc:oracle:thin:@dvlp2

The "dvlp2" is an alias that is specified in the "tnsnames.ora" file, isn't it?

Unfortunately, the thin driver doesn't refer to the tnsnames file. Could you please specify the connection URL in the following form:

connectionUrl=jdbc:oracle:thin:@<hostname>:<port>:<instancename>

The port is usually 1521.

Best regards!

P.S. Please let me know did it help. Thanks!

Leonid

Report Abuse

Leonid Bushuev

134 posts since
Sep 30, 2002

Currently Being Moderated

Feb 2, 2010 5:24 PM

in response to: Leonid Bushuev

Re: Problem Migrating to Oracle DB using MaintainDB Utility

P.S. If you prefer to use oracle connection with tnsnames aliases,

write me the version of your oracle software (and edition – XE or not) and I'll try to help you how to manage it.

Best regards,

Leonid

Report Abuse

steven dunning

26 posts since
May 28, 2009

Currently Being Moderated

Feb 5, 2010 1:34 AM

in response to: Leonid Bushuev

Re: Problem Migrating to Oracle DB using MaintainDB Utility

You were exactly right. I was specifying the TNS identifier. Once I changed that to the real hostname it worked perfectly.

Thanks!

Report Abuse

Go to original post