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

Missing Diskgroup in CRS – Adding Manually

Hello

While doing some setup, I have came across a diskgroup (OCRDG) missing in CRS registry, however the diskgroup is present in the ASM instance and showing mounted.

[root@oinfo12c-rac1 ~]# crsctl stat res -t ——————————————————————————– Name Target State Server State details ——————————————————————————– Local Resources ——————————————————————————– ora.DATA.dg ONLINE ONLINE oinfo12c-rac1 STABLE ONLINE ONLINE oinfo12c-rac2 STABLE ora.LISTENER.lsnr […]

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 […]

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 […]

Cluster not starting- cssd(12103)]CRS-2302:Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).

Hello All,

Long time !!! Its been very busy schedule and could not spend much on the blog at all.

Anyways back now, and here this time with gpnp profile.

Issue is , the node 2 not starting due to gpnp profile missing/mismatch. Following in the crs alert log in node 2 […]

12c Server Pools in action : Instance and service failover to server pools

In the Previous post we have converted the orcl database to server pool OLTP_SP which is running on three nodes rac01,rac03,rac04 and free server is available in rac02.

Okay lets have some discussion before proceeding,

1. Does in pre 11g version , if a instance crashed does it failed over to any node?

No. […]

12c Database : Convert Admin Managed Database to Policy Managed Database

From 11g onwards, the database can be managed in two modes, Administer managed, i.e instance allocation/deletion service allocation/deletion and evictions will be managed by Administrator.

Where in from the 11gr2 onwards the instance allocation to hosts will be based on the cardinality and services running is also based on their configuration with in the serverpools.

[…]

12c Server Pools : Creating & Managing Server Pools

Hello All,

If you have not read server pool concept so far please read it from here.

In this post we were going to see,

1. create the server pools OLTP_SP with 2 nodes minimum and maximum 2 nodes with importance 4

2. That leaves 2 node in free pool out of my 4 […]

Managing Grid Infrastructure 12c : Creating and Testing TAF Services

Hello,

In this post we will create TAF (Transparent Application Failover) Services as such pre-11gr2 method that is available and preferred instances way.

Environment:-

1. 4 Node RAC, rac01,rac02,rac03,rac04 running orcl database and its instances.

2. A service server_taf is created, for which orcl1 is available instance and orcl2 is the preferred instance.

TAF […]

Managing Grid Infrastructure 12c : Adding a New Node in 12c RAC

In Previous post here and here we have seen deleting and adding back the deleted node to Cluster.

In this post we will see how to add a new node in the cluster

Environment, Assuming you have a new server with OS (OEL) installed and,

Phase 1. You have to install or clone the GRID […]