# SQLPLUS problem

**URL:** <https://community.unix.com/t/sqlplus-problem/286763>\
**Category:** AIX\
**Created:** [April 21, 2011, 8:52am UTC](https://community.unix.com/t/sqlplus-problem/286763 "2011-04-21T08:52:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chapel](https://community.unix.com/letter_avatar/chapel/32/5_5575768a8748004e209b776fc1b2916d.png) [@Chapel](https://community.unix.com/u/Chapel)\
**Post date:** [April 21, 2011, 8:52am UTC](https://community.unix.com/t/sqlplus-problem/286763/1 "2011-04-21T08:52:27Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![DGPickett](https://community.unix.com/letter_avatar/dgpickett/32/5_5575768a8748004e209b776fc1b2916d.png) [@DGPickett](https://community.unix.com/u/DGPickett)\
**Post date:** [April 28, 2011, 2:51pm UTC](https://community.unix.com/t/sqlplus-problem/286763/2 "2011-04-28T14:51:35Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![purdym](https://community.unix.com/letter_avatar/purdym/32/5_5575768a8748004e209b776fc1b2916d.png) [@purdym](https://community.unix.com/u/purdym)\
**Post date:** [May 3, 2011, 12:58pm UTC](https://community.unix.com/t/sqlplus-problem/286763/3 "2011-05-03T12:58:24Z")

</div>

FYI: my system:

```nohighlight
oslevel -s
5300-12-02-1036

```

```nohighlight
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

```

```nohighlight
/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:

```nohighlight
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

```

---

<div class="post-metadata">

**Author:** ![Chapel](https://community.unix.com/letter_avatar/chapel/32/5_5575768a8748004e209b776fc1b2916d.png) [@Chapel](https://community.unix.com/u/Chapel)\
**Post date:** [May 5, 2011, 7:56am UTC](https://community.unix.com/t/sqlplus-problem/286763/4 "2011-05-05T07:56:26Z")

</div>

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