Home » Infrastructure » Unix » "sqlplus" command error & About Oracle lib files merged
"sqlplus" command error & About Oracle lib files merged [message #421069] Fri, 04 September 2009 02:08 Go to next message
bacanaks
Messages: 7
Registered: September 2009
Junior Member
Hi all,
I'm new for ORACLE and new for this forum.
I have a trouble with my Oracle DB.
First problem was "file system full" error for /export/home directory. When I was trying to solve this, I moved the /export/home/oracle directory. And so everything was down. Then I moved back the directory again. And I empty another files.Then usage of that directory decreased 100% to 94%.

But after doing above,I have new problem.
Now,when I type "sqlplus" command
Open failed for libclntsh.so.8.0 file. And process is killed.

What am I do? Please help me now..
Re: "sqlplus" command error [message #421073 is a reply to message #421069] Fri, 04 September 2009 02:24 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Cal your Database Administrator to ask restore database from backup Using new oracle home (You need to install oracle with out database).

Thanks
Re: "sqlplus" command error [message #421076 is a reply to message #421073] Fri, 04 September 2009 02:34 Go to previous messageGo to next message
bacanaks
Messages: 7
Registered: September 2009
Junior Member
Ooo,really..
There is a problem. I don't have any DBA in my company.I'm a new and uniq computer engineer here. So I'm the DBA. I do this and I haven't done any ORACLE install ever.
Re: "sqlplus" command error [message #421127 is a reply to message #421076] Fri, 04 September 2009 07:47 Go to previous messageGo to next message
bacanaks
Messages: 7
Registered: September 2009
Junior Member
I searched a lot for this issue.Then run this
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

But nothing changed.

I'm receiving this message when I typing sqlplus
Quote:
h:[w]$ sqlplus
ld.so.1:sqlplus: fatal :libclntsh.so.8.0 : open failed : No such file or directory
Killed



Do you have any idea about what do I? Please help..
Re: "sqlplus" command error [message #421128 is a reply to message #421127] Fri, 04 September 2009 07:57 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:

No such file or directory



Well. The only option at this point would be to restore from backup. Or from someplace where that libclntsh.so.8.0 and other files wound up.
About Oracle lib files (merged) [message #421185 is a reply to message #421069] Sat, 05 September 2009 02:41 Go to previous messageGo to next message
bacanaks
Messages: 7
Registered: September 2009
Junior Member
Hi,I'm new DBA of the oracle server and I have root access. We use Sun Machine.
I was getting "file system full" error for /export/home directory.And when I was trying to reduce usage of /export/home directory,I moved /oracle/app directory.Then everything worse, and I moved back again.
mv -r /export/home/oracle/app  /tmp

This is my moving action. But I didn't wait the action and press Ctrl+C and this is the moving back command.
mv -r /tmp/app  /export/home/oracle/app1

And then I moved files in app1 to app directory. For example
mv /export/home/oracle/app1/product/8.1.5/lib/libordaud.so   /export/home/oracle/app/product/8.1.5/lib

I moved few library files to the app/product/8.1.5/lib directory

Yesterday,I reduced the usage of /export/home directory 100% to 94% with another ways. But after moving action I explain above, I'm getting this error:
Quote:
h:[w]$ sqlplus
ld.so.1:sqlplus: fatal :libclntsh.so.8.0 : open failed : No such file or directory
Killed


I see the libclntsh.so.8.0 file when check the lib directory.
I typed this command too:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

But nothing changes.
Do you know any idea about my case?Thanks..
Re: About Oracle lib files (merged) [message #421186 is a reply to message #421185] Sat, 05 September 2009 02:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remove all and restart a fresh and clean install.
And as this is the continuation of your previous topic there was no need to start a new one.
I merge both and move them to Unix forum.

Regards
Michel

[Updated on: Sat, 05 September 2009 02:53]

Report message to a moderator

Re: About Oracle lib files (merged) [message #421269 is a reply to message #421186] Mon, 07 September 2009 03:16 Go to previous messageGo to next message
bacanaks
Messages: 7
Registered: September 2009
Junior Member
Hi again..
I solved the lib files problem and the "sqlplus" command works.
But after entering username and password, I'm getting
Quote:
ORA-12547:TNS:lost contact" error

What can I do now? Is there anyone to have any idea about this issue?
I changed the server's location to work easy. So server's ethernet port is down now. Is the "lost contact" error related to this?
Re: About Oracle lib files (merged) [message #421272 is a reply to message #421269] Mon, 07 September 2009 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Remove all and restart a fresh and clean install.

Regards
Michel
Re: About Oracle lib files (merged) [message #421295 is a reply to message #421272] Mon, 07 September 2009 06:03 Go to previous messageGo to next message
bacanaks
Messages: 7
Registered: September 2009
Junior Member
My new error code is ORA-01034.
What is the reason for
Quote:
$sqlplus
username:devreabone
password:********

ORA-01034:ORACLE not available



Do you help me,please?
Re: About Oracle lib files (merged) [message #421301 is a reply to message #421295] Mon, 07 September 2009 06:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01034: ORACLE not available
 *Cause: Oracle was not started up. Possible causes include the following:
         - The SGA requires more space than was allocated for it.
         - The operating-system variable pointing to the instance is
           improperly defined.
 *Action: Refer to accompanying messages for possible causes and correct
          the problem mentioned in the other messages.
          If Oracle has been initialized, then on some operating systems,
          verify that Oracle was linked correctly. See the platform
          specific Oracle documentation.

Regards
Michel
Re: About Oracle lib files (merged) [message #421489 is a reply to message #421301] Tue, 08 September 2009 13:08 Go to previous message
bacanaks
Messages: 7
Registered: September 2009
Junior Member
Thanks everybody,

I solved my problem yesterday. My Oracle is working well.

If you wonder what was the problem or what did I do to solve this problem,I explain.

I changed some lib files permissions. For exp:

chmod 644 libclntsh.so.8.0


I restarted listener with

lsnrctl start


I checked if my database was up with:

ps -ef | grep smon


I started my database.

And I did another things that I don't remember now:)

In brief, work,work,work..Then oracle will work.
Previous Topic: error in writing /tmp/oraInstall
Next Topic: Ping is Disabled
Goto Forum:
  


Current Time: Fri Mar 29 18:04:48 CDT 2024