New Features for DBA’s

Subscribe to Posts by Email


 

Subscriber Count

    701

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages
«  
  »

11g Dataguard Standby Password file case sensitive issue

A call today from one of my friend regarding switchover issue, once the role swap has been performed the standby (current primary) is not able to ship the redo log files.

Verification:-

1) v$managed_standby in production(current standby) stucks at sequence “waiting for log”

2) Trace files shows

Redo shipping client performing standby login
OCISessionBegin failed -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges

3) ORA-16191

As usual, its a password file issue, we have done

1) Recreated the password file – no luck

2) Copied the password from standby (current primary) to production (current standby)

But no luck,

After a lot of scratching, got that the database is running 11gR2, apparently my doubt turns to password case sensitive,

1) deleted the password files

2) created the password file with ignorecase=y using orapwd

orapwd file=orapwdgstby entries=100 password=***** ignorecase=y

Viola, this time its worked…….. standby sync resumed. So you will have to use ignorecase=y option for 11g password files as they turned to case sensitive now.

Just for all your information , if you are also may sail in same boat.

-Thanks

Geek DBA

October 13th, 2012 | Tags: , , | Category: Dataguard

3 comments to 11g Dataguard Standby Password file case sensitive issue

  • yezendla
    October 13, 2012 at 8:43 pm

    Hi Geek DBA,

    It’s awesome. I know many people would face the same issue. I was really scratching my head, tried all the possibilities like copying the password files across DR and PRIMARY, creating separate files with same password, used FORCE=y in password files, googled etc.Only one option left with me is disturbing you over weekend. With this solution everything went smooth.

    Guys this helped me a lot.

    Thanks a lot Geek DBA

  • Vijesh
    September 25, 2017 at 10:41 am

    Thanks a lot

    After recreating the password with ignore case, it worked for me as well

    The strange thing is from primary Node 1 log shipping was working.

    From primary Node 2 it was failing with insufficient privileges.

    Regards
    Vijeesh