By Katsumii-Oracle on Jul 03, 2013
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/126.96.36.199/dbhome_1/BIN/sqlplus scott
I hope this tip helps reducing your DBA time.