|
||||
|
OMS (Enterprise Manager) is generating huge quatity of logs. Logs generated by the Grid Infrastructure are spread across modules. There are logs for http Apache module, log for Infrastructure, agents logs and traces, opmn logs etc. Here are the location of logs that use a lot of disk space: 1) Agent Log and Trace Files: […] Once the grid agent has been installed on target servers, we have to log to Grid control and configure the targets located by the agent, in order to collect the metrics by agent and upload to OMS, (typically dbnsmp password etc to be provided) other wise the in GUI you will see metric collection errors […] We may need sometimes to export or import the monitoring templates in Oracle grid control from one environment to new environment, for example when you upgrade or a new OMS infrastructure has been built, in this case the emcli export/import will help you to copy the monitoring templates between environments, lets see how to do […] As you aware spfile located in asm disks only starting 11gR2 in cluster environment. When CRSD need to start the various resources of the node or updates it changes in OCR. the location of spfile also should known to crsd. Here the gpnp profile comes into handy. (read more here for gpnp) The order […] In 11gR2, Oracle has introduced a cache called flash cache which is a secondary cache of the buffer cache. This flash cache is resides in L2 Cache of the system (RAM) and can be very fast compare to the disk. The SSD disks which gives you the benefit of high speed disks , the same […] In the previous post we discussed about the Parent & Child Cursors in Oracle and how do they work or shared. To get into deeper, Oracle controls the sharing of cursors with parameter called cursor_sharing. It has three values EXACT SIMILAR FORCE In this post we will create a table which has some records with […] What are PARENT AND CHILD CURSORS IN ORACLE A cursor is a memory area in library cache allocated to a SQL statement which stores various info about the SQL statement like its text, execution plan, statistics etc. Each SQL statement has One Parent cursor One or more child cursors PARENT CURSOR It […] Cluster integrity and cluster membership will be governed by occsd (oracle cluster synchronization daemon) monitors the nodes using 2 communication channels: – Private Interconnect aka Network Heartbeat – Voting Disk based communication aka Disk Heartbeat Network heartbeat:- Each node in the cluster is “pinged” every second Nodes must respond in css_misscount time (defaults to […] Hello, A long notes (confusing) on listeners in 11gR2 RAC. You all aware of we have two listeners running in database servers in Grid Infrastructure (Aka RAC) namely scan listeners and node listeners. How does they work? The SCAN works by being able to resolve to multiple IP addresses reflecting multiple listeners in the cluster […] Hello All, My best wishes for Christmas and upcoming new year to you all! This year has been very promising to me via this blog which earned me a lot of good friends and fellow DBA’s, indeed I have a learnt a lot too via this channel. I recognized that the journey of this blog […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!