Data Backup and Recovery

How to change oracle user when using SMO clone feature?

vichaupari
4,244 Views

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,

1 ACCEPTED SOLUTION

shetty
4,244 Views

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.

View solution in original post

3 REPLIES 3

shetty
4,245 Views

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.

vichaupari
4,244 Views

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,

jcosta
4,244 Views

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

oradev1, oratest1, .. ..

Public