| "sqlplus" command error & About Oracle lib files merged [message #421069] |
Fri, 04 September 2009 02:08  |
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 #421076 is a reply to message #421073] |
Fri, 04 September 2009 02:34  |
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 |
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 |
ThomasG
Messages: 1940
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 |
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 |
Michel Cadot
Messages: 29419
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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]
|
|
|
| Re: About Oracle lib files (merged) [message #421269 is a reply to message #421186] |
Mon, 07 September 2009 03:16 |
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 #421301 is a reply to message #421295] |
Mon, 07 September 2009 06:26 |
Michel Cadot
Messages: 29419
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
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
I checked if my database was up with:
I started my database.
And I did another things that I don't remember now:)
In brief, work,work,work..Then oracle will work.
|
|
|
] 
Members
Search
Help
Register
Login
Home
