Home > IT Answers > Oracle > Running SQL PLUS on a server
Lynrobbins
5 pts.
 Running SQL PLUS on a server
Oracle, SQL Plus, SQL Server, SQLPlus
Can I use mapped drives and environment variables to run SQLPLUS from a local machine(without any Oracle products) to a server. The mapped server has the Oracle products? Example:

W - map to my Oracle server C drive

EV = w:oracleora92binsqlplusw

cmd : start %EV%

I'm trying to host out of Oracle Forms 6i to run a scrip to create flat files. The server with Forms does not have SQLPLUS installed.

 



Software/Hardware used:
windows servers, Oracle 9i
ASKED: November 29, 2010  8:02 PM
UPDATED: December 1, 2010  4:44 PM
RELATED QUESTIONS
 
  Help
 Approved Answer - Chosen by carlosdl

You CAN definitely run sqlplus using a mounted drive. I am currently remotely logged into a windows 2008 server with NO Oracle software installed. I mounted a drive where Oracle is installed as X. From a command window I set ORACLE_HOME and added %ORACLE_HOME%bin to the PATH variable. I was then able to execute SQL*Plus from that command window. On a UNIX server this is done frequently. After reading the comments I couldn't understand why it would not be similarly possible on a Windows system.... so I tried it. By using a mounted drive it is like having the software locally. Just be sure all the environment variables are set appropriately and use the right connect string.

ANSWERED:  Nov 30, 2010  4:11 PM (GMT)  by carlosdl
 
Other Answers:

I beleive that you will need to have SQLPlus installed locally as you’ll need the Oracle drivers and tnsnames.ora locally.

Last Wiki Answer Submitted:  November 29, 2010  8:41 pm  by  Denny Cherry   64,550 pts.
Latest Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see other answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

No, that cannot be done.

To run SQL*Plus on a machine, it must be installed on that machine.

But maybe we can suggest other solutions. Can you provide more details ?

You said that you wanted to run SQLPLus from a machine without any oracle products installed, but at the end you mention a server with Forms that doesn’t have SQL*Plus.

Can you explain how are you planning to generate those files, where are you planning to generate them and what Oracle products (if any) are installed on that machine ?

The more details you provide, the better your chances to get useful responses.

carlosdl
 63,580 pts.
 

Then I was wrong.

Most windows applications need to load libraries at runtime and many times having access to the executable file is not enough to be able to run it, and that’s why I assumed so in this case.

I’m glad Jcmdba replied with the correction.

Will try it.

carlosdl
 63,580 pts.
 

I have done this for years on Windows. It is really handy for depolying new workstations. You don’t have to install the Oracle products on each workstation. You need the mapped network drive, the Oracle registry settings would point to the mapped drive, and the path variable to the mapped network drive bin folder

Randym
 1,740 pts.