Reseting Oracle File Permissions as it was just after instalation

Posted on 2008-01-29
Medium Priority
Last Modified: 2013-12-19
Hi experts.

Last night I needed to replace a harddisk on my oracle server to another one with more capacity. For complete this task, I did the folowing.

1) Disable Oracle AutoStart on Linux.
2) Shutdown the server
3) Put the new HD, partitioned, formated, and copy the files as ROOT user.
4) Shutdown the server again, remove the old HD, change FSTAB do point the oracle mount points to the new HD
5) Poweron the server, change the permissons to oracle folder (/u01 and /u02. Oracle Instalarion Folders and binaries are on /u01 mouting point)
6) Change owner on /u01 and /u02 to oracle, recursivelly.
7) Change filemode on /u01 and /u02 to 775, recursivelly.
8) Starts the oracle from the new HardDisk.

The database started fine. EM also stared with no problems.
But, when EM try to execute a JOB, that is a operating system command, it doesn't execute, and tells that it "cannot read error message from input".

I think that could can be happening because the permissions that I changed. Does anybody know what could be done to solving this?

Question by:regisdaniel
  • 2
LVL 16

Accepted Solution

Richard Olutola earned 1000 total points
ID: 20768514
When you copied the files as the root user, did you maintain the file permissions? This would have been far easier than trying to guess what file has what permission.

If possible, repeat the process using rsync -Ha so that all permissions are maintained.

Also, normally Oracle doesn't need to own /u01 and /u02. It is OK for root to own these but oracle would own the subdirectories where it needs to read from and write to.


Author Comment

ID: 20768780
Hi rolutola.

Thanks for your answer.
When copied the files, the permissions was changed to the root user. This is why I used the chown and chmod to set all files to oracle user. Unfortunately I can't recopy the files, since the new harddisk already entered in production mode...


Assisted Solution

joebednarz earned 1000 total points
ID: 20769526
I would check the preferred credentials stored in EM for the Host you are running against.  Make sure that user does have privileges to the machine.

Author Comment

ID: 20770030
Hi joebednarz.

The user is the same used to log on before changing the harddisk, the oracle user. I also tried to reconfigure credentials to use the root user, but the error persists.


Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Suggested Courses
Course of the Month3 days, 12 hours left to enroll

599 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question