CODEWITHSUNDEEP
databaselinuxoracle11gsqlplus
user140053
user140053

Reputation:

sqlplus doesn't start on linux 64

I installed, on Mint15 64bit, the Oracle Instant client package 11

Each time I try running sqlplus I get message

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

Of course I set correctly the $ORACLE_HOME. I tried to set LANG=us Same result.

I tried with instant oracle 12.1, same results !?

Except waving to MariaDb ;) What part is wrong in my install ?

Upvotes: 1

Views: 7199

Answers (3)

user140053
user140053

Reputation:

Ok, Done... In fact, the sqlplus binary must be in $ORACLE_HOME/sqlplus !

Larry... Why did you "hardcode" that ;)

Upvotes: 0

linux_fanatic
linux_fanatic

Reputation: 5167

export ORACLE_HOME=/yourpath
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=your sid
sqlplus / as sysdba

Have you added the ORACLE_HOME bin path to the PATH and are you running the sqlplus command with oracle user.

Thanks & Regards,
Alok Thaker

Upvotes: 1

Alex Poole
Alex Poole

Reputation: 191235

The installation instructions at the bottom of the download page say:

Set the library loading path in your environment to the directory in Step 2 ("instantclient"). On many UNIX platforms, LD_LIBRARY_PATH is the appropriate environment variable. On Windows, PATH should be used.

You need to set LD_LIBRARRY_PATH, not (just) ORACLE_HOME. And make sure it's exported, not just set in your current shell.

Upvotes: 0

Related Questions