Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Oracle / Oracle Server / July 2005

Tip: Looking for answers? Try searching our database.

Problem with SQLPLUS for Linux

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
star69 - 23 Dec 2004 20:45 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

    *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 :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.