# Automation Designer Change Connection

**URL:** <https://forums.toadworld.com/t/automation-designer-change-connection/52868>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [May 24, 2021, 6:58pm UTC](https://forums.toadworld.com/t/automation-designer-change-connection/52868 "2021-05-24T18:58:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jbirkenstamm](https://avatars.discourse-cdn.com/v4/letter/j/94ad74/32.png) [@jbirkenstamm](https://forums.toadworld.com/u/jbirkenstamm)\
**Post date:** [May 24, 2021, 6:58pm UTC](https://forums.toadworld.com/t/automation-designer-change-connection/52868/1 "2021-05-24T18:58:29Z")

</div>

All my DB interaction actions connected to lets say "NJSP1" DB Instance. Since IT upgraded Oracle and DB environment, I got moved to "NJSPAUD" DB instance.

I have to go into each import/export and other actions and change the DB instance. Since NJSP1 no longer exists, I select the action and properties and a Schema/Password/DB dialog prompts me to enter new credentials.

#1 - is there a way to do this without touching every actions that requires DB interaction?

#2 - I tried manually changing the DB and I get "ORA-02391: exceeded simultaneous SESSIONS\_PER\_USER limit" after 4 or 5 action updates. How do I get around this as well?

Thanks in advance.

John

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [May 24, 2021, 7:08pm UTC](https://forums.toadworld.com/t/automation-designer-change-connection/52868/2 "2021-05-24T19:08:10Z")

</div>

#1: In 14.1 and prior no. In the 14.2 beta, yes. You can multi-select actions or apps, then right-click to change connection on them.  
#2: Hard to say because I'm not exactly sure of your steps, but if you are making a new connection each time, then maybe instead, you could make the new connection from the login window, leave it connected, then go through your actions and just select it.

---

<div class="post-metadata">

**Author:** ![jbirkenstamm](https://avatars.discourse-cdn.com/v4/letter/j/94ad74/32.png) [@jbirkenstamm](https://forums.toadworld.com/u/jbirkenstamm)\
**Post date:** [May 24, 2021, 7:27pm UTC](https://forums.toadworld.com/t/automation-designer-change-connection/52868/3 "2021-05-24T19:27:42Z")

</div>

Thanks John. I like the multi-select action. I assume change connection is not a single select prior to 14.2.  
for #2, I go into each action by select/properties and provide schema/password and DB instance. A side effect is that it creates a new session every time. So, I have to periodically have to end connection on the ones created by this action. Wonder if that suppose to happen. I don't have multi-thread checked.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [May 24, 2021, 8:13pm UTC](https://forums.toadworld.com/t/automation-designer-change-connection/52868/4 "2021-05-24T20:13:03Z")

</div>

In 14.2, you can just right-click the app(s) or action(s), choose "Change connection" and pick another connection from the login window. No need to open each action or even make a connection if it's already in the login window. This is a completely new feature. It did not exist in 14.1, even for single select.

 ![image](https://global.discourse-cdn.com/quest/original/2X/f/ff1b8c0c2fa02427498ef9092b855fbae3d1ea4d.png)

For #2, can you just do this to choose an existing connection? (I know, not every type of action has this toolbar item).

 ![image](https://global.discourse-cdn.com/quest/original/2X/f/f7389dbccdf3ee491c84ffe4f1f32f5c0e138d3f.png)

Maybe this is a good time to get the beta. 🙂[Toad for Oracle 14.2 Beta](https://forums.toadworld.com/t/toad-for-oracle-14-2-beta/41283)