Last updated on OCTOBER 01, 2012
Applies to:Enterprise Manager for Oracle Database - Version 220.127.116.11 to 18.104.22.168 [Release 11.1]
Information in this document applies to any platform.
The 'Host and Cluster Preferred Credentials' are set for the sudo/"Run as" in Grid Control. Creating a grid control job that runs an OS script and performing a manual Dataguard switchover using sudo works successfully. However, when performing a Data Guard switchover using sudo in Grid Control results to the following error:
Error: startup mount
SQL*Plus: Release 22.214.171.124.0 Production on Tue May 29 12:00:56 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> SQL> Connected to an idle instance.
SQL> SQL> ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/dbatest/spfiledbatest.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/dbatest/spfiledbatest.ora
ORA-27300: OS system dependent operation:open failed with status: 13
ORA-27301: OS failure message: Permission denied
ORA-27302: failure occurred at: sskgmsmr_7
cannot stat initial working directory for <EMHOME>/sysman/emd: Permission denied at /app/oracle/product/agent11g/perl/lib/5.10.0/File/Temp.pm line 893
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms