我试图在云Linux框上安装Oracle Instant Client 12.1 in.rpm和sqlplus in.zip,但出现错误:未找到消息文件sp1.msb。
即时客户端和sqlplus下载URL:
http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
在网上查了一下,我还是搞不清楚。

my ~/.bash_profile:
export ORACLE_HOME=/usr/lib/oracle/12.1/client64
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=american_america.utf8

source ~/.bash_profile

echo $PATH
/usr/lib/oracle/12.1/client64/bin
echo $ORACLE_HOME
/usr/lib/oracle/12.1/client64

sqlplus在/usr/lib/oracle/12.1/client64/bin中解压缩,否则找不到命令。
欢迎任何建议。

最佳答案

这是我的解决办法,希望有帮助。解压Oracle即时客户机存档文件后,我必须创建一些目录,移动文件并手动创建tnsnames.ora。这是我设置后的布局:

$ pwd
/home/oracle/instantclient_11_2
$ find . -type f|egrep -v "sdk|htm|README"
./lib/ojdbc6.jar
./lib/ojdbc5.jar
./lib/xstreams.jar
./lib/libsqora.so.11.1
./lib/libnnz11.so
./lib/libociei.so
./lib/libsqlplus.so
./lib/libocijdbc11.so
./lib/libsqlplusic.so
./lib/libclntsh.so.11.1
./lib/libocci.so.11.1
./bin/adrci
./bin/sqlplus
./bin/odbc_update_ini.sh
./bin/genezi
./bin/uidrvci
./sqlplus/admin/glogin.sql
./network/admin/tnsnames.ora

样品tnsnames.ora:
$ cat /home/oracle/instantclient_11_2/network/admin/tnsnames.ora
ACNTUAT =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.54.32.10)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = acntuat)
    )
  )

~/.bashrc中的环境变量(适用于所有操作系统用户)
export ORACLE_HOME=/home/oracle/instantclient_11_2
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBARY_PATH:$ORACLE_HOME/lib
export SQLPATH=$ORACLE_HOME/sqlplus/admin
export NLS_LANG=AMERICAN_AMERICA.UTF8
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"

此时,命令'sqlplus user/passwd@acntuat'应该可以工作。

关于linux - oracle Instant Client 12.1 SP2-0667:找不到消息文件sp1 <lang> .msb,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/21016393/

10-16 20:29