Hello, I've downloaded from oracle.com this software to connect with a
Oracle server from my university:
(Instant Client Downloads for Linux x86)
Instant Client Package - Basic: All files required to run OCI, OCCI,
and JDBC-OCI applications
*Instant Client Package - SQL*Plus: Additional libraries and executable
for running SQL*Plus with Instant Client
I've followed the Installation Steps:
1. Download the appropriate Instant Client packages for your platform.
All installations REQUIRE the Basic package.
2. Unzip the packages into a single directory such as "instantclient".
3. Set the library loading path in your environment to the directory in
Step 2 ("instantclient"). On many UNIX platforms, LD_LIBRARY_PATH is the
appropriate environment variable. On Windows, PATH should be used.
4. Start your application and enjoy.
But when I run sqlplus I get:
sqlplus: error while loading shared libraries: libsqlplus.so: cannot
open shared object file: No such file or directory
I tried to define LD_LIBRARY_PATH with the directory, I also add that
directory to PATH, but I've got the same error. I'm using Ubuntu Linux.
Any idea?
Thank you very much.
boogab00@yahoo.com - 23 Dec 2004 21:18 GMT
If you've checked to insure the "libsqlplus.so" does indeed exist, then
this is more than likely an environment issue. Make sure your
ORACLE_HOME is set and check your LD_LIBRARY_PATH variable again.
> Hello, I've downloaded from oracle.com this software to connect with a
> Oracle server from my university:
>
> (Instant Client Downloads for Linux x86)
>
> Instant Client Package - Basic: All files required to run OCI, OCCI,
> and JDBC-OCI applications
>
[quoted text clipped - 17 lines]
>
> sqlplus: error while loading shared libraries: libsqlplus.so: cannot
> open shared object file: No such file or directory
>
> I tried to define LD_LIBRARY_PATH with the directory, I also add that
> directory to PATH, but I've got the same error. I'm using Ubuntu Linux.
> Any idea?
>
> Thank you very much.
Rauf Sarwar - 24 Dec 2004 09:47 GMT
> Hello, I've downloaded from oracle.com this software to connect with a
> Oracle server from my university:
>
> (Instant Client Downloads for Linux x86)
>
> Instant Client Package - Basic: All files required to run OCI, OCCI,
> and JDBC-OCI applications
>
[quoted text clipped - 17 lines]
>
> sqlplus: error while loading shared libraries: libsqlplus.so: cannot
> open shared object file: No such file or directory
>
> I tried to define LD_LIBRARY_PATH with the directory, I also add that
> directory to PATH, but I've got the same error. I'm using Ubuntu Linux.
> Any idea?
>
> Thank you very much.
As pointed out by other poster... if you can see libsqlplus.so then
check that atleast these env vars are setup before launching sqlplus.
1) export ORACLE_HOME=.....
2) Include $ORACLE_HOME/bin in your PATH variable
3) export LD_LIBRARY_PATH=$ORACLE_HOME/lib
Regards
/Rauf
Michael McGuire - 31 Jul 2005 17:57 GMT
> Hello, I've downloaded from oracle.com this software to connect with a
> Oracle server from my university:
--- snip - snip - snip
> But when I run sqlplus I get:
>
[quoted text clipped - 6 lines]
>
> Thank you very much.
The libraries are owned by oracle:oinstall. I made my user a member of the
oinstall group and was able to invoke sqlplus. This isn't the correct
approach but it allowed me to continue on. I'm still looking for the
correct answer in the docs.
IANAL_VISTA - 31 Jul 2005 19:12 GMT
>> Hello, I've downloaded from oracle.com this software to connect with
>> a Oracle server from my university:
[quoted text clipped - 15 lines]
> correct approach but it allowed me to continue on. I'm still looking
> for the correct answer in the docs.
I suspect that root.sh was NOT run after the installation;
which changes the protection masks on key files in the oracle tree.
Dave - 31 Jul 2005 21:59 GMT
>>> Hello, I've downloaded from oracle.com this software to connect with
>>> a Oracle server from my university:
[quoted text clipped - 18 lines]
> I suspect that root.sh was NOT run after the installation;
> which changes the protection masks on key files in the oracle tree.
only 7 months late, nice :-)