Solved

SQL*PLus calls plus33..should call plus80

Posted on 2000-04-27
2
572 Views
Last Modified: 2008-03-10
I use Oracle 8.0.4.

In the command line I try to use sqlplus that calls plus80, but it keeps calling plus33(which gives an error message) Registry key: EXECUTE_SQL was "plus33", but I changed it to "plus80"...still does not work.
0
Comment
Question by:migue
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 4

Expert Comment

by:jtrifts
ID: 2758609
In your registry, under:
HKEY_LOCAL_MACHINE --> SOFTWARE --> ORACLE -->

There must be a key called PLUS80.  Its string value should be pointing to your plus80 location, typically C:\ORANT\PLUS80

Further, I would recomment adding a key called PLUS_DFLT and set the string value to PLUS80.

You should also have a PLSQL80 key that points to c:\orant\plsql80 (though this will not affect sql*plus.

Your sqlpath should point to c:\orant\dbs (I believe).

And finally, as you say, they EXECUTE_SQL key should have the string PLUS80 as you noted that you have done.

Hope this helps,

JT

0
 
LVL 4

Accepted Solution

by:
jtrifts earned 30 total points
ID: 2784601
Hello?

Did you not like this response?

Please accept or reject or post comments or delete this question.

Regards,

JT
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question