Filesystems, Disks and Memory

I'm new DBA of the oracle server and I have root access. I don't know how many users on the server We use Sun Machine.

Code:

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.

Code:

mv -r /tmp/app  /export/home/oracle/app1

And then I moved files in app1 to app directory. For example

Code:

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:

Code:

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:

Code:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

But nothing changes.
Do you konow any idea about my case?Thanks..

Are you using Solaris 10? If you are /tmp is volatile filesystem that uses swap space. This means that if the machine is rebooted or loses power everything it /tmp experiences bit oblivion.

Why are you moving library files around?

I would move everything back to exactly where it was at.

Can you post the output from:

Code:

df -k

I am concerned that you may be confusing the output of "ls -l" of the /export/home directory with matters related to disc space usage of /export/home directory.

If you have not done so already, it is time to consider how to restore the damaged areas from backup. It would be prudent to find out what has filled the /export/home directory and to repair that problem first.


As for moving everything back, this line is worrying depending on what was in the target tree to start with (and whether that tree existed):
It would help to see any non-comment lines in the file /etc/oratab so we know the names of the oracle instances and can relate them to the directory trees.

Unless you have Oracle database segments or Oracle temporary files in the Oracle appplication tree the most likely files to fill this tree are: Oracle listener logs, Oracle audit logs and Oracle trace logs.

Have you tried a blunt search of the filesystem looking for Oracle log files which grow in size or sheer number of files?

This command might reveal your issue with /export/home : (Adjust -mtime <days> if this is a recent install).

Code:

find /export/home/ -mount -mtime -60 -exec ls -lad '{}' \;

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:

Code:

chmod 644 libclntsh.so.8.0

I restarted listener with

Code:

lsnrctl start

I checked if my database was up with:

Code:

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.