Oracle RAC request

swathi.raoetr · Post by **swathi.raoetr** » Tue May 16, 2017 1:48 pm

When I try importing the tables from Oracle, despite correct connection details it requests RAC name. "User needs to enter RAC Name for servers on RAC"

chulett · Post by **chulett** » Tue May 16, 2017 2:09 pm

I assume you are talking about the step to import the table metadata from Oracle, yes? Regardless, it's been a very long time but it sounds to me that you may be connecting to a specific instance in the RAC cluster rather than the "RAC name" - the service name of the cluster itself.

ray.wurlod · Post by **ray.wurlod** » Tue May 16, 2017 6:27 pm

I also think that's the case. You're probably using the name of a single node rather than the scan name.

swathi.raoetr · Post by **swathi.raoetr** » Wed May 17, 2017 9:22 am

chulett,

Yes, that is correct. Will take a look at this suggestion. Thanks.

JRodriguez · Post by **JRodriguez** » Wed May 17, 2017 4:36 pm

that...or it might be just a bug

http://www-01.ibm.com/support/docview.w ... wg1JR56685

swathi.raoetr · Post by **swathi.raoetr** » Thu May 18, 2017 6:39 am

Julio,

Unfortunately, I have limited access on the datastage environment.

swathi.raoetr · Post by **swathi.raoetr** » Thu May 18, 2017 6:40 am

Correction: Its a development environment, hence a single node cluster. So why would it ask for RAC name?

chulett · Post by **chulett** » Thu May 18, 2017 8:50 am

Because it's still a RAC cluster. It doesn't know nor care how many nodes there are.