Page 1 of 1
Oracle RAC request
Posted: Tue May 16, 2017 1:48 pm
by swathi.raoetr
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"
Posted: Tue May 16, 2017 2:09 pm
by chulett
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.
Posted: Tue May 16, 2017 6:27 pm
by ray.wurlod
I also think that's the case. You're probably using the name of a single node rather than the scan name.
Posted: Wed May 17, 2017 9:22 am
by swathi.raoetr
chulett,
Yes, that is correct. Will take a look at this suggestion. Thanks.
Posted: Wed May 17, 2017 4:36 pm
by JRodriguez
Posted: Thu May 18, 2017 6:39 am
by swathi.raoetr
Julio,
Unfortunately, I have limited access on the datastage environment.
Posted: Thu May 18, 2017 6:40 am
by swathi.raoetr
Correction: Its a development environment, hence a single node cluster. So why would it ask for RAC name?
Posted: Thu May 18, 2017 8:50 am
by chulett
Because it's still a RAC cluster. It doesn't know nor care how many nodes there are.