Hi all, just created a MyToad account, linked my computer, uploaded scripts, executed the scripts, but get “Unable to create Oracle session” when I check the results.
The scripts do not run, but I can run them manually in Toad for Oracle. Any clue what I should check here? Thanks!
Could you try to enable the email notifications and see if any of the information returned from them is incorrect. The results email should contain a link to
your result on MyToad, filename, script, and database.
Are you by any chance using a mixed case user?
Thanks,
From: grego [mailto:bounce-grego@toadworld.com]
Sent: Tuesday, August 06, 2013 7:44 PM
Subject: [Toad for Oracle - Discussion Forum] “Unable to create Oracle session” in MyToad
"Unable to create Oracle session" in MyToad
Thread created by grego
Hi all, just created a MyToad account, linked my computer, uploaded scripts, executed the scripts, but get “Unable to create Oracle session” when I check the results.
The scripts do not run, but I can run them manually in Toad for Oracle. Any clue what I should check here? Thanks!
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Thanks Mike, I think it could be due to using a direct connection and not TNS. I can’t TNSPING. Even when I try to email from Script Manager, it’s not working.
You should be okay using a direct connection.
A couple questions… Are you behind a proxy server? Can you execute a script on the database from the command line using tsr.exe successfully?
Right clicking on the MyToad Monitor and bringing up the error log might have some information as well.
From: grego [mailto:bounce-grego@toadworld.com]
Sent: Wednesday, August 07, 2013 9:07 AM
Subject: RE: [Toad for Oracle - Discussion Forum] “Unable to create Oracle session” in MyToad
RE: “Unable to create Oracle session” in MyToad
Reply by grego
Thanks Mike, I think it could be due to using a direct connection and not TNS. I can’t TNSPING. Even when I try to email from Script Manager, it’s not working.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Checking on your suggestions, Mike. Will report back shortly. Thanks again for the help!!
I’m not behind a proxy server. I tried running a script from Quest Script Runner, and get “ORA-12154: TNS:can’t resolve”
I also get “ORA-12505: TNS:does not currently know SID given in connect descriptor” I have a feeling it’s something with tnsnames.ora.
I don't believe QSR/TSR Support direct connect. I'll double check in the morning to be sure. If not, I'll see if it can be added.
Greg
On Aug 7, 2013, at 5:59 PM, "grego" bounce-grego@toadworld.com wrote:
Reply by grego
I'm not behind a proxy server. I tried running a script from Quest Script Runner, and get "ORA-12154: TNS:can't resolve"
I also get "ORA-12505: TNS:does not currently know SID given in connect descriptor" I have a feeling it's something with tnsnames.ora.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Thanks Greg, appreciate it. This is the method my team uses, so if it can be added as an enhancement, that would be great.
Greg,
Turns out TSR and QSR both support direct connect. As an experiment, I created a simple file that contained select * from scott.emp;
I then ran TSR using the following command line syntax:
-f “c:\hr.sql” -c gliss/XXXX@192.168.218.133:1521/XE -o “c:\output.txt”
The more generic version is:
-f “c:\scott.sql” -c /@:/<service_name> -o “c:\output.txt”
Can you connect so SQL*Plus using that syntax? connect /@:/<service_name
Can you try that test on QSR/TSR?
Thanks,
Greg
From: grego [mailto:bounce-grego@toadworld.com]
Sent: Wednesday, August 07, 2013 6:35 PM
Subject: RE: [Toad for Oracle - Discussion Forum] “Unable to create Oracle session” in MyToad
RE: “Unable to create Oracle session” in MyToad
Reply by grego
Thanks Greg, appreciate it. This is the method my team uses, so if it can be added as an enhancement, that would be great.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Once I input that syntax, I get prompted with the Oracle Login box, and after I had entered the info, it produces the ORA-12154 error. Maybe I can check my TNSNAMES.ora file to ensure it’s set properly? I still have a feeling it’s something to do with my setup.
Thanks
If you’re using directconnect, TNSNames isn’t required. I had renamed mine for the experiment to be sure that it wasn’t an issue.
From: grego [mailto:bounce-grego@toadworld.com]
Sent: Thursday, August 08, 2013 10:01 AM
Subject: RE: [Toad for Oracle - Discussion Forum] “Unable to create Oracle session” in MyToad
RE: “Unable to create Oracle session” in MyToad
Reply by grego
Once I input that syntax, I get prompted with the Oracle Login box, and after I had entered the info, it produces the ORA-12154 error. Maybe I can check my TNSNAMES.ora file to ensure it’s
set properly? I still have a feeling it’s something to do with my setup.
Thanks
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
