|
||||
|
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 […] 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 […] 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 […] 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 […] 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 […] 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. […] 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. […] 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 […] 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 […] 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 […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!