# Command Line Logon Screen

**URL:** <https://forums.toadworld.com/t/command-line-logon-screen/9421>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [April 13, 2010, 9:17am UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421 "2010-04-13T09:17:15Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![shahidc](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@shahidc](https://forums.toadworld.com/u/shahidc)\
**Post date:** [April 13, 2010, 9:17am UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/1 "2010-04-13T09:17:15Z")

</div>

I want to use a batch-script to open toad and connect to a database.  
But after toad starts it follows a logon screen – I don’t need it, because the logon information comes from the script.  
Another Question is the count of toad instancces. If I start the script the second time another toad.exe opens. I would like to have only one instance.

I am searching a complete list of parameters for command line syntax.  
Does anybody know an URL/Link ?

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [April 13, 2010, 9:17am UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/2 "2010-04-13T09:17:15Z")

</div>

Toad options offers way to not see login screen ….

---

<div class="post-metadata">

**Author:** ![shahidc](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@shahidc](https://forums.toadworld.com/u/shahidc)\
**Post date:** [April 13, 2010, 9:43am UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/3 "2010-04-13T09:43:06Z")

</div>

Yes, I found the option under “StartUp” - thanks.

Do you know to use only one instance of Toad ? (no hook under “Allow multiple copies of toad to be loaded” - but it does not work)

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [April 13, 2010, 9:43am UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/4 "2010-04-13T09:43:06Z")

</div>

Are you using the Automation Designer? Or are you trying to use the  
command-line?

---

<div class="post-metadata">

**Author:** ![sbharti](https://avatars.discourse-cdn.com/v4/letter/s/f4b2a3/32.png) [@sbharti](https://forums.toadworld.com/u/sbharti)\
**Post date:** [April 13, 2010, 10:04am UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/5 "2010-04-13T10:04:04Z")

</div>

I am also interested in knowing how to invoke and kill Toad using RUN (Windows)  
utility.

When I work from home I remote connect to my desktop and then start Toad.

If some query is running long or say Toad freezes then I want to kill it using  
Ctl+Alt+Del windows utility.

But this shows the processes running on my home laptop (not on remote work  
desktop) !!!

In such situation, I am stuck and wish I could kill this Toat Session from the  
command prompt.

Regards,

Shiva.

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [April 13, 2010, 10:09am UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/6 "2010-04-13T10:09:39Z")

</div>

Don’t kill your Toad, kill your Oracle session.

Login to the database, find your Toad session in the Session Browser, and  
kill/disconnect it.

---

<div class="post-metadata">

**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\
**Post date:** [April 13, 2010, 11:22am UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/7 "2010-04-13T11:22:14Z")

</div>

Of course your friendly DBA (or Mordach) has to give you a license to kill. If  
you see the big red X greyed out in session browser then you don’t have  
that right.

Also sometimes it is necessary to kill the Oracle session because killing Toad  
or killing SQL\*Plus may not stop certain Oracle processes.  
 ![image001.jpeg](https://global.discourse-cdn.com/quest/original/1X/e8288ef7bf69daaab6959f752b25ca292478b911.jpeg)

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [April 13, 2010, 11:24am UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/8 "2010-04-13T11:24:31Z")

</div>

You should always be able to kill yourself…but that’s a different  
story I suppose.

---

<div class="post-metadata">

**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\
**Post date:** [April 13, 2010, 11:25am UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/9 "2010-04-13T11:25:55Z")

</div>

If you are running the Windows REMOTE DESKTOP then Ctrl-Alt-End is the  
equivalent of Ctrl-Alt-Del. I use that regularly because once I am finished  
doing what I need to do I want to reset my computer. I don’t leave it  
running al the time. So Ctrl-Alt-End brings up the dialogue where I can chose  
RESTART.

There are other key combinations but I have forgotten or never learned them.  
 ![image001.jpeg](https://global.discourse-cdn.com/quest/original/1X/e8288ef7bf69daaab6959f752b25ca292478b911.jpeg)

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [April 13, 2010, 11:28am UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/10 "2010-04-13T11:28:18Z")

</div>

Actually Oracle issues an error message when you try to kill your current  
session – it prevents suicide J

---

<div class="post-metadata">

**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\
**Post date:** [April 13, 2010, 11:33am UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/11 "2010-04-13T11:33:57Z")

</div>

No I can’t. I can kill others but the minute I click on my Toad session  
the X gets greyed out. If I start another toad session then I can see my evil  
twin session but I can kill the Oracle process if I find the session in the  
INACTIVE sessions and choose the appropriate SID. But the Toad session is not  
killed and when I click back on the old session it resurrects itself and is  
there. So NO, you can’t kill yourself.  
 ![image001.jpeg](https://global.discourse-cdn.com/quest/original/1X/e8288ef7bf69daaab6959f752b25ca292478b911.jpeg)

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [April 13, 2010, 11:38am UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/12 "2010-04-13T11:38:21Z")

</div>

Right

I meant you should be able to kill sessions that belong to you, not actually  
kill the active session via same active session

And by should, I mean that’s would be a reasonable request for just about  
any development env I can imagine…unless of course it’s the type  
where your app uses only one session any/all work, but you get the idea I hope

---

<div class="post-metadata">

**Author:** ![sbharti](https://avatars.discourse-cdn.com/v4/letter/s/f4b2a3/32.png) [@sbharti](https://forums.toadworld.com/u/sbharti)\
**Post date:** [April 13, 2010, 12:31pm UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/13 "2010-04-13T12:31:42Z")

</div>

Well … the problem is somehow my whole window freezes.

I do not get an opportunity to login to database and find out the Oracle  
Session.

At this point of time I look for Ctl+Alt+Del assuming I can kill that Toad  
Process.

This defenitely does not work.

So what are my alternatives ?

1. Wait till that Toad+Oracle activity is complete.

2. Hope that you can invoke RUN command and then Kill the TOAD process.

Is Option 2 doable in my scenario ?

---

<div class="post-metadata">

**Author:** ![sbharti](https://avatars.discourse-cdn.com/v4/letter/s/f4b2a3/32.png) [@sbharti](https://forums.toadworld.com/u/sbharti)\
**Post date:** [April 13, 2010, 12:43pm UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/14 "2010-04-13T12:43:49Z")

</div>

Erwin … I tried to login to my Desktop from my friends terminal ( via Remote  
Desktop utility ) and use Ctl+Alt+End but it did not do anything.

I have Windows XP on my office m/c.

But thanks for this info.

I will try it from my home and see if it works.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [April 13, 2010, 1:12pm UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/15 "2010-04-13T13:12:30Z")

</div>

look for pskill.exe on [www.sysinternals.com](http://www.sysinternals.com), a microsoft site. it has lots more  
free system utilities that are not available in standard installation.

for example…

c:\pslist

pslist v1.28 - Sysinternals PsList  
Copyright ⌐ 2000-2004 Mark Russinovich  
Sysinternals

Process information for :

c:\pskill

PsKill v1.13 - Terminates processes on local or remote systems  
Copyright © 1999-2009 Mark Russinovich  
Sysinternals - [www.sysinternals.com](http://www.sysinternals.com)

Usage: pskill [-t] [\computer [-u username [-p password]]]  
-t Kill the process and its descendants.  
-u Specifies optional user name for login to  
remote computer.  
-p Specifies optional password for user name. If you omit this  
you will be prompted to enter a hidden password.

Saurabh

---

<div class="post-metadata">

**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\
**Post date:** [April 13, 2010, 1:22pm UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/16 "2010-04-13T13:22:39Z")

</div>

Here is a screenshot of the HELP from REMOTE-DESKTOP  
 ![image001.jpeg](https://global.discourse-cdn.com/quest/original/1X/e8288ef7bf69daaab6959f752b25ca292478b911.jpeg)

---

<div class="post-metadata">

**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\
**Post date:** [April 13, 2010, 1:22pm UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/17 "2010-04-13T13:22:39Z")

</div>

Here is a screenshot of the HELP from REMOTE-DESKTOP

 ![image001.png](https://global.discourse-cdn.com/quest/original/2X/d/debd8b068b617c576dedbd2129b8f8642981d4d6.png)

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [April 13, 2010, 2:55pm UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/18 "2010-04-13T14:55:28Z")

</div>

If you’re remote desktop-ing into your windows session with Toad running,  
why aren’t you just hitting the “Cancel” button in Toad to  
terminate your transaction?

 ![image001.png](https://global.discourse-cdn.com/quest/original/2X/d/debd8b068b617c576dedbd2129b8f8642981d4d6.png)

---

<div class="post-metadata">

**Author:** ![shahidc](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@shahidc](https://forums.toadworld.com/u/shahidc)\
**Post date:** [April 14, 2010, 1:16am UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/19 "2010-04-14T01:16:51Z")

</div>

I am using a command-line.

Like this: TOAD.exe -c -max aaa/xxx@yyyy

I am sure there a more parameter as the TOAD Help describes. btw. I am using Version 9.1.\*

---

<div class="post-metadata">

**Author:** ![vina](https://avatars.discourse-cdn.com/v4/letter/v/df788c/32.png) [@vina](https://forums.toadworld.com/u/vina)\
**Post date:** [August 6, 2012, 7:33pm UTC](https://forums.toadworld.com/t/command-line-logon-screen/9421/20 "2012-08-06T19:33:10Z")

</div>

Hi

Could u tell me what option to use to prevent the prompts?

Thanks i advance
