Windows: starting sqlplus in new window from cygwin bash

Posted by katsumii on Oracle Blogs See other posts from Oracle Blogs or by katsumii
Published on Tue, 2 Jul 2013 23:58:30 +0000 Indexed on 2013/07/03 5:12 UTC
Read the original article Hit count: 233

Filed under:

/web

When I start sqlplus, more often than not, I want it to start in new window,
whether it be on Linux/Solaris GNOME or Windows.

I seldom use GNOME so I never bothered to figure out how.
On Windows, one can use Windows menu or Win+R "Run" dialog but I prefer using
bash. Because, this way, I can keep the history in ~/.bash_history file.

There are 2 ways. Using cmd.exe or cygstart.

For example, to start default sqlplus.exe to connect to default local instance.

$ cmd /c "start sqlplus sys/oracle as sysdba"

2nd example. To start sqlplus in 2nd Oracle home and to connect to non-default local instance.

$ ORACLE_SID=orcl cygstart /cygdrive/g/app/product/11.2.0.3/dbhome_1/BIN/sqlplus scott

I hope this tip helps reducing your DBA time.

Related posts about /web

Why is Java EE 6 better than Spring ?

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Java EE 6 was released over 2 years ago and now there are 14 compliant application servers. In all my talks around the world, a question that is frequently asked is Why should I use Java EE 6 instead of Spring ? There are already several blogs covering that topic: Java EE… >>> More
Hosting a website on Heroku.... I know how to, but im running into problems!

as seen on Pro Webmasters - Search for 'Pro Webmasters'
I'm starting to learn more on the back-end scale of programing. Recently I started up Heroku for the second or third time. This time I actually installed the Git update to my Mac and installed Heroku in the terminal. I wanted to upload a static html site with the sinatra gem. Everything worked out… >>> More
Microsoft .NET Web Programming: Web Sites versus Web Applications

as seen on Samir ASP.NET with C# Technology - Search for 'Samir ASP.NET with C# Technology'
In .NET 2.0, Microsoft introduced the Web Site. This was the default way to create a web Project in Visual Studio 2005. In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Site is a file/folder based Project structure. It… >>> More
VS2008 - Unable to Add Web Reference to Web Application Project (The web services enumeration compon

as seen on Stack Overflow - Search for 'Stack Overflow'
I've run into a situation where I was unable to add a Web Reference in Visual Studio 2008 to a Web Application Project. The error I couldn't resolve was "The web services enumeration components are not available. You need to reinstall Visual Studio to add web references to your application." How… >>> More
Outlook Web Access: "Outlook Web Access has encountered a Web browsing error"

as seen on Super User - Search for 'Super User'
When one of my colleagues is accessing Outlook Web Access from IE, he frequently gets an error reported: "Outlook Web Access has encountered a Web browsing error". The error report includes the following: Client Information User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4… >>> More

Developer IT