Re: strange error on switchover to standby

I finally tracked it down. It was trying to create a directory /oracle/app/audit/TEST1. Not sure why, since the audit directory is defined as /oracle/app/audit/TEST in the spfile, and it is using that directory, since once the instance came up, the audit_dump_dest was correctly defined. And the problem only ocurred on instance one. Really strange. Anyway, it is fixed.

On Sat, Jan 21, 2017 at 4:41 AM, Ls Cheng <exriscer_at_gmail.com> wrote:

> Can it create DIAG directory and underneath?
>
>
>
> On Fri, Jan 20, 2017 at 8:56 PM, Andrew Kerber <andrew.kerber_at_gmail.com>
> wrote:
>
>> I am getting a strange error when I am trying to switchover to my standby
>> database. The first switchover worked fine, so I am switching over to my
>> original primary, and I am getting this message:
>>
>> DGMGRL> switchover to 'TEST';
>> Performing switchover NOW, please wait...
>> Operation requires a connection to instance "TEST3" on database "TEST"
>> Connecting to instance "TEST3"...
>> Connected as SYSDBA.
>> Error: ORA-48189: OS command to create directory failed
>> Error: ORA-16625: cannot reach database "TEST"
>>
>>
>> It looks like it is trying to create a directory, but I cannot figure out
>> what directory it is trying to creat. I expect its a simple ownership
>> problem, but I cannot figure out what directory I need to work on. I tried
>> setting the trace level to support in dgmgrl, but it didnt show the
>> information I needed. Any ideas?
>>
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l