Oracle 23c New Features for DBA'sAll,
Please find the structured 11gR2 GI Clusterware log locations and its relevancy.
Directory structured (Source: Oracle Documentation)
Log Locations
Continue reading 11gR2 RAC: Important Trace Directories & Log Locations
|
||||
|
Hello, Today I have got a call containing couple of questions on streams replication in a standby environment especially when the streams is on downstream capture database. Here are the questions & my answers to it. Environment:- Primary or Source: -10GR2 RAC with 2 node Standby: Physical Standby Streams: Downstreams capture database in different server Behavior of streams at the time of shifting from Primary to Standby and vice versa : a ) In case if Primary is shifted to Secondary(stand by) DB, the streams DB is to be replicated fully (not from point where it stopped) This is called switchover/Failover or the role transitions. In your streams environment as the changes captured in downstream database (different database) with minimal changes or the pre-requisite this transitions can be performed seamlessly and the streams continue to work. Procedure:- Pre-requisities:- Continue reading Replication: does Streams works after role transition i.e switchover or failover
This is about to understand the startup sequence of Grid Infrastructure daemons and its resources in 11gR2 RAC.
In 11g RAC aka Grid Infrastructure we all know there are additional background daemons and agents, and the Oracle documentation is not so clear nor the other blog.
For example:- I have found below diagram from metalink which is very confusing. Continue reading 11g Grid Infrastructure (RAC): CRS Startup Sequence Dear All, Prior to 11g, in order to purge the audit trails we have to write a custom script and run in a cron or control M scheduler job or a DBMS_SCHEDULER, where in From 11g 11.1.0.7 onwards Oracle provides a package DBMS_AUDIT_MGMT to manage the audit trails. Additionally, This package can also be deployed in 10.2.0.3 databases via patch as mentioned in note 731908.1. Example:- Automated Audit trail Purging Continue reading 11g Feature: Audit Trail Purging, No more custom scripts Q: is it my possible to make my query to change from "select 'what is my name' from dual" to "select 'you'r Geek DBA' from dual" during execution. A: this feature is called "query equivalence".
A typical day starts like this. 1) Application team complained about slowness in their job 2) DBA looking into this No clues or details from App team saying this particular sql is that we are running but the response time of the database server is bit slow, so obvious that app team reported slowness. This time I have chosen event based troubleshooting approach from AWR whether to see am I able to drill down the issue. What I started first is, lets take a closer look at top classes in the database that is at the moment.
Hello, Another issue came up today!!! Issue:- ORA-15036: disk 'string' is truncated The size of the disk, as reported by the operating system, was smaller than the size of the disk as recorded in the disk header block on the disk. Apparently the concerned disk group is not mounting, unfortunately this contains our OCR Disks (okay, bigger problem) Sequence of actions or the issues encountered:- 1) DBA found that disk partitions are not visible, passed to unix to fix the issue 2) Unix tried many alternatives and involved Novell (Suse Linux) as well , and Novell wisely rewritten the disk headers and they are visible now 3) Passed to DBA, now the DBA turn to mount the diskgroups 4) Got hit with ORA-15036, and CRSD failing to come up , parallely its resources as well. 5) Raised SR, Oracle suggested to recreate and restore the diskgroups data 6) Novell, said they can't do anything. Strucked ....... and Corner end..... what else? Continue reading ORA-15036: disk ‘string’ is truncated, ASM disks group DATA is not mounting Hello, A Simple readable format about "What is RAID?" RAID (Redundant Array of Independent Disks). A collection of disk drives that offers increased performance and fault tolerance. There are a number of different RAID levels. The three most commonly used are 0, 1, and 5:
Hope this helps!!!! This time, impdp failing to create a job for import and failing with following error:- ORA-06512: at "SYS.KUPV$FT", In many cases you sometimes stop data pump job or in case of an abnormal end of the Data Pump job (we call it the orphaned job) or using undocumented parameter KEEP_MASTER=Y, the master table remain in the database. So lets start digging out for orphaned jobs Script to check Orphaned Pump Jobs
By running above script if any rows returned in “not running “ mode that means you will be having orphaned jobs. Typically orphaned jobs state will be “Not Running” state and but in my case some are even in Executing mode which they shouldn’t As I got the following jobs running at my nose.
Verify that any data pump sessions are running in the database
We got a known issue with ASM not coming up in second and subsequently failed to start crs and other resources. Review grid alert log & os Logs
From 11g R2 (I believe 11.2.0.2 onwards) there is a cluster resource called HAIP which used to manage the cluster interconnects high availability. Prior to 11gr2 if cluster interconnect goes down there will be hang/node evictions depends on the situation. Where in from 11gr2 onwards we can specify up to 3 (as I known) cluster interconnects for a cluster which internally manages with this non-routable IP’s, Essentially, even if one of the physical interface is offline, private interconnect traffic can be routed through the other available physical interface. This leads to highly available architecture for private interconnect traffic.
Nice explanation from Riyaz’s Note:-
Now back to the issue:- As you can see the usb0 is attached to the the internal IP (169.254.X.X is an non routable IP’s range internal to OS) , clusterware will confused with this and unable to start the crs resources promptly. Continue reading PMON (ospid: nnnn): terminating the instance due to error 481 |
||||
Follow Me!!!