Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

When do scripts use plus80.exe and not sqlplus.exe?

When do scripts use plus80.exe and not sqlplus.exe?

When do scripts use plus80.exe and not sqlplus.exe?

Our small software development company distributes an interactive batch PL/SQL Oracle application we developed with 8.0.4 to customers who run 8.0.4, 8.0.5, or 8.0.6. It is not a web based app.

An Oracle DBA for a customer at a VERY LARGE manufacturing company called to complain that our script would not work on 8.0.5 because it is trying to execute sqlplus.exe, and she thought that on 8.0.5 it should be executing plus80.exe.  This is new to us because we tested our installation on all three 8.0.4-5-6 and did not experience this problem.  

Is it that at VERY LARGE companies they disable sqlplus.exe in favor of plus80.exe?

I noted that in 8.0.6, example, there are sqlplus.exe, plus80.exe, and plus80w.exe.  What's the differences between these?

RE: When do scripts use plus80.exe and not sqlplus.exe?

I'm not sure that there's really any difference.  For reasons still not clear to me, Oracle just decided to rename sqlplus to plus80 for a while; then it changed back to sqlplus.  I HAVE noticed that if you install something else, such as Enterprise Manager, it reverts back to plus80.  But even MORE bizarre is the fact that if you go to the DOS prompt (assuming a Windows platform) and enter sqlplus, a second DOS window opens up and plus80 gets invoked!
After poking around a bit, I found that it was just a problem with the PATH variable.  Oracle included a sqlplus file that calls plus80.  By placing my ORACLE_HOME/bin directory at the front of the PATH string, the problem went away.

Your customer might consider either changing PATH (if that will take care of it for them) or a file called sqlplus.bat that will call PLUS80.

RE: When do scripts use plus80.exe and not sqlplus.exe?

Thanks for the quick reply

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close