cancel
Showing results for 
Search instead for 
Did you mean: 

Sqlplus Error

SOLVED
Go to solution
Shoyru
Occasional Contributor

Sqlplus Error

I have a user who encountered the following error when trying to connect to sqlplus through Unix.

$sqlplus

Pthread internal error: message: __libc_reinit() failed, file: /ux/core/kern/pt3
Return Pointer is 0xc02a9273
Quit

Is it a problem with the unix kernel parameters? How do I fix this problem? Much advice appreciated! Thanks.
Dum Dee Dee....
2 REPLIES
Graham Cameron_1
Honored Contributor
Solution

Re: Sqlplus Error

There is some stuff on metalink about this.
Seems it may be to do with SHLIB_PATH, which may be pointing at the wrong place.

Can you try these 2 commands

"type sqlplus"
"echo $SHLIB_PATH"

heres what I get on my system...

# type sqlplus
sqlplus is /app/oracle_tmp/product/920/bin/sqlplus
# echo $SHLIB_PATH
/app/oracle_tmp/product/920/lib

Make sure your SHLIB_PATH points to the same $ORACLE_HOME as your sqlplus is in.

If in doubt, post the output of your 2 commands back here.

-- Graham
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Shoyru
Occasional Contributor

Re: Sqlplus Error

Hey Graham, that was a wonderful solution! True enough, when I did a # echo $SHLIB_PATH, it returns "SH'.
I went to edit the .profile and bingo, it runs perfectly. 10 points for you! Thanks!
Dum Dee Dee....