Subscribe
Accepted Solution

How to change oracle user when using SMO clone feature?

[ Edited ]

Dear Sir,

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.

Thank you.

Regards,

Re: How to change oracle user when using SMO clone feature?

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. (

-rwxrwxr-x)

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

any Oracle.

-Praveen.

Re: How to change oracle user when using SMO clone feature?

Dear Shetty,

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.

Thank you.

Regards,

Re: How to change oracle user when using SMO clone feature?

Some customers do, it makes life easier for them. Typically these customers have an unix user for each oracle SID.

oradev1, oratest1, .. ..