SQLPLUS problem

UNIX AIX
1

Hi guys,

Here is the error i get by running a "sqlplus -v" after installing an oracle client 10.2.0.5 on an AIX 5.3.9 server.

Could not load program sqlplus:
Symbol resolution failed for sqlplus because:
Symbol __pthread (number 307) is not exported from dependent
module /usr/lib/libpthreads.a[shr_xpg5_64.o].
Examine .loader section symbols with the 'dump -Tv' command.

Aio0 available.
lsdev -C -l aio0
aio0 Available Asynchronous I/O (Legacy)

Don't seem to have any problem while installing ..
Any help?

Thx.

2

Seems like an environment problem, but I forget, what is the library path in AIX, like LD_LIBRARY_PATH on Solaris. Might be finding no or wrong library files in dynamic link. You might run 'ldd -rsv sqlplus' and see where it is getting libs, or not.

3

FYI: my system:

oslevel -s
5300-12-02-1036


set | grep -i oracle
LD_LIBRARY_PATH=/usr/lib:/home/oracle/instantclient_10_2:/opt/freeware/lib:/usr/local/lib
LIBPATH=/usr/lib:/home/oracle/instantclient_10_2:/opt/freeware/lib:/usr/local/lib:/home/sybase/sql12.0.0/ASE-12_0/lib:/home/sybase/sql12.0.0/OCS-12_0/lib
PWD=/home/oracle/instantclient_10_2
TNS_ADMIN=/home/oracle/instantclient_10_2


/home/oracle/instantclient_10_2/bin>./sqlplus -v

SQL*Plus: Release 10.2.0.2.0 - Production

unxd1:/home/oracle/instantclient_10_2/bin>

Also:

ORACLE_HOME=/home/oracle/instantclient_10_2
ORACLE_TERM=vt100
ORATAB=/etc/oratab
TNS_ADMIN=$ORACLE_HOME
ORA_NLS10=$ORACLE_HOME/nls/data
SQLPATH=$ORACLE_HOME/sqlplus/admin

my PATH contains $ORACLE_HOME
4

Thx guys.
A package was missing, and it was the cause of the issue.