Running SQL PLUS on a server

5 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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.
    69,225 pointsBadges:
    report
  • Jcmdba
    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.
    555 pointsBadges:
    report
  • carlosdl
    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.
    69,225 pointsBadges:
    report
  • Randym
    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
    1,740 pointsBadges:
    report
  • Lynrobbins
    [...] 5. CharlieBrowne, TomLiotta, Labnuke99 and Teandy worked together trying to figure out how to help a member copy a high volume of data between AS/400s. 6. You learn something new everyday in the forums. Learn from Jcmdba on running SQL Plus on a server. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following