一个朋友遇到了如下问题：

oracle用户可以用sqlplus连接数据库，不论是否使用连接串。

另外一个用户如果不使用连接串就会报tns-12547错误，并提示找不到libjox.a模块

metalink上找到如下文档：

Subject:	Cannot connect to 9.2 database - Dependent module libjox9.a(shr.o) could not be loaded
	Doc ID:	Note:209272.1	Type:	PROBLEM
	Last Revision Date:	09-OCT-2002	Status:	PUBLISHED

Fact(s)
~~~~~~~

  Attempting to connect to a 9i(9.2) database.
  Environment variables are set to point to the 9.2 database.
  ORACLE_HOME, ORACLE_SID are set correctly.


Symptom(s)
~~~~~~~~~~

When connecting we get the following errors:

  $ sqlplus system/rem920
  SQL*Plus: Release 9.2.0.1.0 - Production on Thu Aug 29 14:48:55 2002
  Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
  exec(): 0509-036 Cannot load program oracleREM920 because of the following 
  errors:
          0509-150 Dependent module libjox9.a(shr.o) could not be loaded.
          0509-022 Cannot load module libjox9.a(shr.o).
          0509-026 System error: A file or directory in the path name does 
                   not exist.
  ERROR:
   ORA-12547: TNS:lost contact


Change(s)
~~~~~~~~~

However, while connecting if connect string is given it connects fine.
  Eg:   
      $ sqlplus system/rem920@connect_string


Cause
~~~~~

The LIBPATH environment variable is not set properly.


Fix
~~~

Add the following: $ORACLE_HOME/lib to the LIBPATH environment variable.

For eg:
        LIBPATH=$ORACLE_HOME/lib32:$JAVA_HOME/lib:$ORACLE_HOME/lib


References
~~~~~~~~~~

------------------------------------

注意aix平台的环境变量是LD_LIBRARY_PATH