Hi all,
this is the next post for this now archived thread. I upgraded to Java 8 + v4.1.3.20 in the meantime.
How do I run a script for several connections without opening the connections one by one and F5-running the script?
In TOAD one could do it like:
CONNECT user1/pwd1@12.34.56.78:1521/DB11G
@myscript.sql
CONNECT user2/pwd2@12.34.56.78:1521/DB11G
@myscript.sql
CONNECT user3/pwd3@12.34.56.78:1521/DB11G
@myscript.sql
This question was also asked on SO and IMHO the way I showed is correct, see the SQL Developer User Guide.
This is my script:
CONNECT MYUSERNAME/mypw@1.2.3.4:1521/DB11G
@myscript.sql
This is the response I get using v4.1.3.20:
Error starting at line : 1 in command -
CONNECT MYUSERNAME/mypw@1.2.3.4:1521/DB11G
Error report -
Connection Failed, Error Reports:
USER = MYUSERNAME
URL = jdbc:oracle:thin:@1.2.3.4:1521/DB11G
Error Message = Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Retry up to 3 times
Error starting at line : 1 in command -
CONNECT MYUSERNAME/mypw@1.2.3.4:1521/DB11G
Error report -
Connection Failed
Commit
I use connection type "basic" in SQL Developer with just the same data, which works like a charm.
Do you have an idea what might go wrong here?
Thank you
Blama