Sqlplus -V in Oracle

Question

I'm trying to get Oracle installed.

If I type just sqlplus -V I get this error

    Error 6 Initializing SQL*Plus
    Message file sp1<Lang>.msb not found
    SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

However if I type

/home/oracle/product/11.1.0/db_1/bin/sqlplus -V

it works. I then set my PATH, ORACLE_HOME and export them. Everything works. If I close the terminal and reopen, I'm back to the start with orginal error.

How can I set my PATH and ORACLE_HOME permanently?

Dave Costa · Accepted Answer · 2011-11-09 16:38:31Z

3

In general, in Unix and Unix-like systems, you put commands to set up your environment into a shell-specific file such as .cshrc in your home directory. Which file you should use and what exact commands to include depend on the shell you are using.

In this case, there may be a script provided by Oracle to set up the appropriate environment variables, which you would invoke from your shell setup script. I am not sure if they provide this on Unix installations, but they do for OpenVMS and I suspect they same would be true on Unix. If so, I would expect a script with a name similar to orauser to exist in the Oracle home directory (/home/oracle/product/11.1.0 in your case).

answered Nov 9, 2011 at 16:38

Dave Costa

48.3k8 gold badges61 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

En-Motion Over a year ago

When I log in as my Oracle user there is a .profile file. I hardcoded PATH and ORACLE_HOME there. It works now.

Daniel Haviv · Accepted Answer · 2011-11-09 16:33:06Z

0

type

which sqlplus

you will notice it is not running from /home/oracle/product/11.1.0/db_1/bin

answered Nov 9, 2011 at 16:33

Daniel Haviv

1,0361 gold badge8 silver badges16 bronze badges

Collectives™ on Stack Overflow

Sqlplus -V in Oracle

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related