2009-09-09 01:16 AM - edited 2015-12-18 01:39 AM
I would like to change Oracle user when I need to clone Oracle database by using SMO. Is it possible to do that? When I change Oracle user parameter in SMO cloning wizard and doing clone, I always got an error "control file could not be created". I also assigned user permission and owner to original Oracle path but the problem still exist. Please kindly give me an idea.
Solved! SEE THE SOLUTION
2009-09-09 06:43 AM
I assume that you are trying to create a clone on the same host where
the source database is residing with different oracle user name, if so I
was able to find a workaround trying in our lab.
1. Created a different user on the same host and associate with the
original dba group.
2. Changed the directory permissions of the source database mountpoints
such that the user and the group has the write permissions. (
3. Changed the Oracle datafiles permissions such that user and the group
has the write permissions. (-rwxrwxr-x)
4. Create a clone through SMO specifying the new user created in the
first step and it worked fine.
Note: The above changes mentioned in step 2 and 3 are not recommended by
2009-09-09 09:11 AM
Thank you very much for your advise. I will check with my customer because they changed permission for me but I think they maybe miss no 3. What is the real world when other people clone Oracle database, do they use another user instead of original user? Because this is my customer requirement.