Today we have looked over ASM Instance Remotely. We can see that the normal instance of RDBMS is different from ASM. Connect to ASM Instance Remotely Being DBA we are aware that By Default Oracle ASM don’t allow remote sysdba connection since ASM instance is in NOMOUNT state. You Might get ORA-12528: TNS:listener: all appropriate […]
Monthly Archives: July 2018
Managing Client Connectivity using DBMS_SERVICE package and After Startup Trigger
In the previous Article, we have seen understanding and managing user connectivity in Data Guard Environment. Understanding and managing client connectivity In this Article, we will see Creating After Startup Trigger which will manage service for different database roles. Step 1: Create services in a Primary database with DBMS_SERVICE package. Note: We need to […]
Understanding and managing client connectivity
While managing Data Guard Standby databases in our environment one of the key responsibility of DBA is End-user connectivity to a proper database or we can say clients connect to the correct database even in case of failover. To know Oracle DataGuard Oracle Dataguard Architecture Your client connectivity should be managed in such a […]
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
As we are working on the series of listener errors. Now we are going to work on “ORA-12514“. Let’a have look on the steps which we use to resolve this issue. Cause: “The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a SID […]
Recover Data File in Primary Database in Data Guard Environment
Recovering Data File in Primary Database from the standby database. You have two approaches for data file restoration when your data file gets corrupted or deleted in data guard environment. Restore from RMAN backup Recover it from Standby Database. In our routine, we use the first approach where we simply restore it using RMAN restore command […]
Highly Available VIP (HAVIP)
Highly Available IP (HAIP) comes from 11.2.0.2 on-words and maximum 4 define for Private network Now in 12c version introduces Highly Available VIP (HAVIP) a Clusterware-monitored VIP that can be used for non-Database applications. Typically, VIPs are created for VIP or SCAN listeners for Database connections. In some cases, the need arises to create a […]
rtld: 0712-001 Symbol CreateIoCompletionPort was referenced
In My Case Cause of below the issue at storage level. failing currently due to LVM inconsistency Below screenshot where CRS services are running on another node. iocp0 is now available on pdb02 Ref: AIX 12.1.0.2 Installation Fails with “rtld: 0712-001 Symbol CreateIoCompletionPort was referenced ” (Doc ID 1949184.1)
ORA-00245 (Snapshot Control File Configuration)
Beginning with 11.2.0.2, for any form of database control file backup operations, Oracle no longer acquires the controlfile enqueue lock. This change requires snapshot control file accessibility to all instances in a RAC database, in contrast to a single-instance database, to successfully complete a manual or auto control file backup operation. When the snapshot control file […]
CHM (Cluster Health Monitor)
Which is analyzing the Os and cluster resource related degradation and failures. Its store real time OS metric in the CHM repository and also report and alert when certain metrics pass the resource utilization threshold. Tool can be replay the historical data to trace back what was happening at the time of failure, and its […]
LREG New BG Process In 12c
In 11.2 Pmon process propagates the service metrics to the listeners registered in local_listener and remote_listener initialization parameter. As the remote_listener specifies specifies the address of scan listener and the local_listener parameter specifies the address of the VIP listener, PMON process propogates the service metrics to both SCAN and VIP listeners. You can trace listener registration using […]