Login or Register to Ask a Question and Join Our Community


AIX

SQLPLUS problem

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems AIX SQLPLUS problem
# 1  
Old 04-21-2011
SQLPLUS problem
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  
Old 04-28-2011
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  
Old 05-03-2011
FYI: my system:

Code:
oslevel -s
5300-12-02-1036

Code:
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

Code:
/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:
Code:
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

Last edited by purdym; 05-03-2011 at 02:02 PM.. Reason: Fixed variables.
# 4  
Old 05-05-2011
Thx guys.
A package was missing, and it was the cause of the issue.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Problem on SQLplus command ""bash: sqlplus: command not found""

Hi all, i face an error related to my server ""it's running server"" when i use sqlplus command $ sqlplus bash: sqlplus: command not found the data base is up and running i just need to access the sqlplus to import the dump file as a daily backup. i already check the directory... (4 Replies)
Discussion started by: clerck
4 Replies

2. Shell Programming and Scripting

Sqlplus error - sqlplus -s <login/password@dbname> : No such file or directory

i am using bash shell Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127. IFS="," declare -a Arr=($Variable1); SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE} echo "set head off ; " > ${SQLCMD} echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies

3. Shell Programming and Scripting

Problem in quitting/exiting from sqlplus

Hello, This is my first post and I would be very thankful if you can help me. I've already searched in the forum and I've found a very similar thread in wich my problem is solved, but the thread is closed and the solution given in it doesn't work in my shell: 153194-problem-quitting-sqlplus ... (11 Replies)
Discussion started by: JuanPerez
11 Replies

4. Shell Programming and Scripting

Sqlplus Help

When i run the following script am getiing the output correct but i want to get it in the form of a table, could any one help me please. the script is a s follows count=`sqlplus -s $ORACLE_ACCOUNT << EOF set heading off set wrap on set feedback off column ChangeNumber format a12 column... (9 Replies)
Discussion started by: jhon1257
9 Replies

5. Shell Programming and Scripting

SQLplus and Shell script problem

sql_rows=`sqlplus -s / <<EOF set heading off set pagesize 1000 set tab off set linesize 120 wrap off column "Path" format a15 --column "No_Of_files" format a10 select tablespace_name, substr(file_name,1,instr(file_name,'/',1,2)) as "Path" , count(*) as "No_Of_files" from dba_data_files ... (7 Replies)
Discussion started by: desibabu
7 Replies

6. Shell Programming and Scripting

problem in quitting from sqlplus

Hi all, I have a scenario where im connecting to sqlplus executing a query,redirecting the output to a file and manipulating the file MY CODE IS AS FOLLOWS sqlplus -s /nolog << EOF > $UTILITIES_HOME/temp/analyze.temp.log & set linesize 3000 set trimspool on set pagesize... (2 Replies)
Discussion started by: niteesh_!7
2 Replies

7. Shell Programming and Scripting

Sqlplus

I am looking to loop round a load of files and execute each in sqlplus, I have looked at the forum to see what was posted in the past, but most of the examples seem to use the sql being passed in through the script, which is not really what I am looking for, can someone tell me if the code below is... (9 Replies)
Discussion started by: LiquidChild
9 Replies

8. UNIX for Advanced & Expert Users

Problem while calling Oracle 10g SQLPLUS files

Hi all, Iam facing a lot of problem while calling Oracle 10g SQLPLUS files from shell. What is the standard procedures to be taken care. Any help would be useful for me. Thanks in advance, Ganapati. (2 Replies)
Discussion started by: ganapati
2 Replies

9. Shell Programming and Scripting

KSH Sqlplus problem

Hi, trying this =============================== Temp=`sqlplus -s user/passwd <<EOF WHENEVER SQLERROR EXIT 1 set serverout on set feedback off set heading off select nam from tabel1 where x=y; EOF` echo Temp>>$logfile ================================= The select statement is... (2 Replies)
Discussion started by: amitkr
2 Replies

10. Shell Programming and Scripting

Sqlplus

Hi all, I am new to SQLPLUS, can anyone tell me what is the following codes doing? DECLARE cursor c1 is select bts_int_id, max(ave_busy_tch/res_av_denom14) maxBusyTch from p_nbsc_res_avail where to_char(period_start_time,'yyyymmdd')=to_char((sysdate-1),'yyyymmdd') group by... (4 Replies)
Discussion started by: antkiu
4 Replies
Login or Register to Ask a Question