Subscribe to Posts by Email

Subscriber Count

    696

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

Grid Infrastructure Permission issues – ora-27303 startup egid – 60321 (oinstall), current egid = 60329 (asmadmin)

Not strange though, but well possible to get into trap of permission issue from 11gr2 GI since the user separation (GI Owner, RDBMS Owner) and the additional groups (asmadmin, asmoper etc) has created lots of mess around, especially when you are not good in selecting the right groups/owners in the installation.

I have been told […]

11gr2 gipcd connection refuse : one of the node not starting

Well , we have got an issue that one of the node is not starting up , its a two node GRID Infrastructure and the logs shown as below

in crs alert_rac01.log

CRSD not started – unable to locate OCR

in gipcd.log

2014-09-10 06:23:00.186: [    GIPC][1117619840] gipcCheckInitialization: possible incompatible non-threaded init from [prom.c […]

Convert Single instance to rac to a different server

Convert Single Instance (ASM) to RAC Instance (ASM) to different Server

Assuming you have already the following environment setup and ready

    1. 11gr2 Clusterware is already installed on your target machine (XYZ)     2. Target xyz is configured with +DATA as diskgroup     2. Source ABC is having single instance in ASM […]

addnode.sh failed with bin/lsnodes: struct size 0

Whilst adding a node failing with following errors in the addnode.log

INFO: /u01/app/11.2.0.4/grid/oui/bin/../bin/lsnodes: struct size 0 INFO: Vendor clusterware is not detected. INFO: Error ocurred while retrieving node numbers of the existing nodes. Please check if clusterware home is properly configured. SEVERE: Error ocurred while retrieving node numbers of the existing nodes. Please check if […]