Dbvisit Community Dbvisit home       

Go Back   Dbvisit Community > Dbvisit Standby - Technical > Dbvisit Standby - Technical Questions or Issues

Thread Tools Search this Thread Display Modes
Old 05-19-2011, 09:04 PM
tommy.limardi tommy.limardi is offline
Junior Member
Join Date: May 2011
Posts: 1
Default Create standby database from ASM


Does anyone has experience using Dbvisit Standby Database (version 5.3.06) with this configurations:
-Oracle 11gR2 with ASM
-Oracle 11gR2 without ASM

On primary, ASM and Oracle are installed using different user (grid and oracle) and dbvisit_setup is executed with oracle user. The problem arise when creating standby database with error below:

Transferring +DATA/idmdb/datafile/system.256.751554043 to /usr/tmp/system.256.751554043 ...
201105191517 - Database +ASM may be down on idmdbdc. Please check +ASM is the
correct ASM instance, else please contact Dbvisit support.
                Dbvisit terminated.
Return code = 9002
Any help or clues would be very help.

Thank you
Tommy L
Reply With Quote
Old 05-20-2011, 10:13 AM
Mike Donovan Mike Donovan is offline
Dbvisit Team
Join Date: May 2008
Posts: 207
Default RE: Create standby database from ASM

Hello Tommy,

The user that runs Dbvisit needs to have execute permissions on the executables under the "grid" user's ORACLE_HOME, such as ASMCMD and also SqlPlus (for use by the create standby database process (CSD) to log to the ASM instance).

We are aware of this issue presented by the Oracle owner/grid user role separation, and of the fact that the "normal" Oracle user does not have right privileges by default. However we do advise changing permissions as we have outlined, even though this is not an Oracle default recommendation.

Alternatively we have heard of instances of people running Dbvisit as the "grid" user on both servers with the "grid" user obviously applying the logs - and this process seems to work. However recovery would probably require ownership changes on files.
Reply With Quote

asm, grid, return code 9002

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off

Forum Jump

All times are GMT +12. The time now is 09:15 PM.