Home » Server Options » RAC & Failsafe » is there any way/tool to connect clinet to RAC on single node
is there any way/tool to connect clinet to RAC on single node [message #639669] Tue, 14 July 2015 02:08 Go to next message
mvrkr44
Messages: 131
Registered: December 2012
Senior Member
hi All,

My question may be silly,but i want to know is there any way/tool to connect to RAC on single node (currently i have 3 nodes) when they client login till session end.

in current situation when we are loggining in client application..we are connecting to Node-1,but while working some times my session connecting to NODE-2 also..so it is creating me problem somes times like error ORA-2049.because at a same time i am inserting into two tables which are dependent (PK & FK).so it is holding lock.i tried differnet ways but i didn't succeed.now we don't have time to change application also.
so i need other solutions to restrict client application to connect to only one node till session ends on RAC Database(3 node configuration)

REgards,
Rajesh
Re: is there any way/tool to connect clinet to RAC on single node [message #639670 is a reply to message #639669] Tue, 14 July 2015 02:15 Go to previous messageGo to next message
John Watson
Messages: 8351
Registered: January 2010
Location: Global Village
Senior Member
The answer is simple: connect to a service running on only one instance. However, that will not solve your problem. Row and table locking issues will remain, no matter where your sessions are connected. It is not RAC releated.
Re: is there any way/tool to connect clinet to RAC on single node [message #639671 is a reply to message #639670] Tue, 14 July 2015 02:19 Go to previous messageGo to next message
mvrkr44
Messages: 131
Registered: December 2012
Senior Member
Hi John,

In Standlaone db i don't have any problem.when we moved to RAC DB we are getting error.
So i tried different ways to solve.but i failed.
So i am trying any way to connect to only one node till the session end from application?

Regards,
Rajesh
Re: is there any way/tool to connect clinet to RAC on single node [message #639673 is a reply to message #639671] Tue, 14 July 2015 02:21 Go to previous messageGo to next message
John Watson
Messages: 8351
Registered: January 2010
Location: Global Village
Senior Member
I've told you what to do.
Re: is there any way/tool to connect clinet to RAC on single node [message #639678 is a reply to message #639669] Tue, 14 July 2015 03:16 Go to previous messageGo to next message
Michel Cadot
Messages: 67374
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Still the same question than your previous topic: ora 2049 error distributed_lock_timeout, isn't it?

So I bet you'll have the same answers.

Re: is there any way/tool to connect clinet to RAC on single node [message #639682 is a reply to message #639678] Tue, 14 July 2015 03:37 Go to previous messageGo to next message
mvrkr44
Messages: 131
Registered: December 2012
Senior Member
s.same question.But now i need to restrcit user/client to connect to single Node untill session ends.
Re: is there any way/tool to connect clinet to RAC on single node [message #639683 is a reply to message #639678] Tue, 14 July 2015 03:38 Go to previous messageGo to next message
John Watson
Messages: 8351
Registered: January 2010
Location: Global Village
Senior Member
Ah. Same answer: create and use an appropriately configured service.
Do you actually know what a service is? I shall ignore this topic (and any others that look related) until you show some evidence that you have looked into the offered solutions.
Re: is there any way/tool to connect clinet to RAC on single node [message #639684 is a reply to message #639683] Tue, 14 July 2015 03:41 Go to previous message
mvrkr44
Messages: 131
Registered: December 2012
Senior Member
Now i tried one more solution...
Now I disabled & enabled foreign keys of Table .
Now i am not getting error.
Previous Topic: ora 2049 error distributed_lock_timeout
Next Topic: scandisks command not found ASM disks
Goto Forum:
  


Current Time: Wed Sep 30 04:15:38 CDT 2020