CODEWITHSUNDEEP
oracle-databasesqlplus
chocokoala
chocokoala

Reputation: 351

sqlplus on ubuntu, error: Message file sp1<lang>.msb not found

I followed https://itectec.com/ubuntu/ubuntu-how-to-install-sqlplus/ I had downloaded the 21 versions from https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

I am getting this error: Error 6 initializing SQL*Plus SP2-0667: Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

in my instantclient_21_3 folder, it doesn't even have sq1 msb files. I have set the ORACLE_PATH to instantclient directory. Where I can get these msb files?

Upvotes: 0

Views: 941

Answers (1)

Christopher Jones
Christopher Jones

Reputation: 10641

On Ubuntu you can install like:

alien -i --scripts oracle-instantclient19.13-basic-19.13.0.0.0-1.x86_64.rpm
alien -i --scripts oracle-instantclient19.13-sqlplus-19.13.0.0.0-1.x86_64.rpm
apt-get install libaio1

You don't need to (i.e shouldn't) set environment variables or run ldconfig.

This will also work with 21c.

Upvotes: 0

Related Questions