Toad World® Forums

Automation Designer Change Connection

Toad for Oracle
#1

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

#2

#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.

#3

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.

#4

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
image608×661 64.1 KB

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

image
image821×671 86.9 KB

Maybe this is a good time to get the beta. :slight_smile: Toad for Oracle 14.2 Beta