nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Synchronized deployments fail

arabif

I am in the process of testing 'synchronized database deployments' which I plan to propose as a potential solution to my client. I have been challenged by Opendeploy and I am hoping to get some directions/suggestions from devnet.

OpenDeploy (synchronized deployments) is not able to connect to the DataBase (Oracle 10g RAC) and the following error is seen in the RCVR log file. (For the purpose of this test, I am using OD base server as both Source and Target). I am using dbLoader and EAData element.

[html]
DBD: url : jdbc Smiley Surprised

racle

ci8:@TEAMD01R
DBD: login : teamsite
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc Smiley Surprised

racle

ci8:@TEAMD01R...
DBD: Link failure
DBD: Attempt to connect using jdbc Smiley Surprised

racle

ci8:@TEAMD01R failed.
DBD: You must fix the problem before proceeding, because Oracle specific data types are being used.
DBD: ERROR:Unable to connect to TEAMD01R
DBD: ERROR:TDbAgent constructor failed.
[/html]

However, when a standalone database deployment (EA attributes) using the same database.xml file works great. I did have to download the latest ojdbc.jar and copy it to /drivers folder.

[html]
DBD: Assuming TNS name has been specified for "db" attribute.
DBD: url : jdbc Smiley Surprised

racle

ci8:@TEAMD01R
DBD: login : teamsite
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc Smiley Surprised

racle

ci8:@TEAMD01R...
DBD:
Connected to jdbc Smiley Surprised

racle

ci8:@TEAMD01R
DBD: Driver Oracle JDBC driver
DBD: Version 10.2.0.1.0
[/html]

I did research the IWOV support site, devnet and all OD guides but no luck. I don't see this issue reported as a bug either.

Am I missing something? Any pointers will be highly appreciated.

TeamSite: 6.7.2
OD: 6.2.1
Solaris 2.10
Oracle 10g (RAC)

Find more posts tagged with

Comments

nakumar

I guess it's a known issue. If we use the db name directly it won't work, so the workaround is given below.

Instead of

[html]

name = "oracle-db"
db = "10.120.3.39:1521:RAC"
user = "username"
password = "passwd"
vendor = "oracle"/>

[/html]

In the above case "RAC" oracle rac database will not be recognized by OD/DD. Instead we should pass the entire ADDRESS_LIST as shown below.

[html]

name = "oracle-rac-db"
db = "(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.120.3.39)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = RAC.WORLD)))"
user = "username"
password = "passwd"
vendor = "oracle"/>

[/html]

Adam Stoller

I'm glad you found your answer - Oracle RAC support is in its infancy at IWOV. Last year I worked with an Interwoven consultant at a customer site getting several aspects of the Interwoven products to work with Oracle RAC and it took a lot of post-installation manual configuration work, which subsequently got documented in a number of Support KBs and I believe, in part, in the 672 Release Notes.

Note: When searching for terms like this on the support site, put phrases in double quotes - e.g.: "oracle RAC" - that significantly helps to reduce the signal-to-noise ratio.

arabif

Thanks Narendra & Ghoti, for you inputs - It helped.

With some more testing, here is my conclusion.

For standalone deployments, the following works:

1) In database.xml, db attribute value is a SERVICE NAME (resolved in tnsnames.ora)
2) In database.xml, db attribute value is 'entire ADDRESS_LIST'
3) Works fine with both oracle oci-8 & thin drivers

For Synchronized deployments, the following works:

1) In database.xml, db attribute value is 'entire ADDRESS_LIST'
3) Works with oracle thin driver

Thanks again.