|
||||
|
Its more than 3 years 11g has released, still looking or finding something new every day or other. Today its the Parallel Hint that I came across from the documentation. Many has already blogged about this, still I am writing the same for my readers and Until 10g, the parallel hint behaviour is like […] To Export cluster registry $srvconfig -exp file_name To Import Cluster registry $srvconfig -imp file_name To Upgrade the database cluster registry and database configuration $srvconfig -upgrade -dbname database_name -orahome oracle_homename To Downgrade the database cluster registry and database configuration (This is rarely used in case of any […] Few more collection of new features with in 12c database in continuation to my earlier post in this category RMAN Enhancements:- Recover or copy files from Standby databases Table level restoration i.e object level Incremental recovery more faster, many of the tasks removed RAC Enhancements:- TAF is extended to Transactions failover (insert/update/delete) Dataguard Enhancements:- Global […] If someone ask you that how to know about asm diskgroups without logging to asm, then answer this. ASM datafile system (ACFS?) rac2$ asmdf Filesystem SizeKB UsedKB AvailKB Use% Mounted on +DATA01 15687104 10959872 4727232 60.56% DATA01 This works really, but no documentation at all. If some one knows about this let me know. -Thanks […] We have a lost voting disks issue yesterday, this occurs due to incorrect aliases or the device mapper persistent names have been changed after storage upgradation/migration. CRS was not up and showing the error below Obviously the CSSD , cssd.log No voting disks founds So, we have lost the voting and OCR disks. […] Hello, I am bumped on the following to answer in a exact sequential way, hence want to note it here. While in a rac installation, when you run root.sh , what are the sequence of actions that take place? Node 1 Initial Setup Setup OLR for storing Oracle local registry data Setup GPnP wallet and […] If you have an asm instances with multiple databases using it, you may just need to watch out for processess parameter, yes you heard it right See below:- ORA-00312: online log 1 thread 1: ‘+ASMDISK1/testdb/redo01.log’ ORA-17503: ksfdopn:2 Failed to open file +ASMDISK1/testdb/redo01.log ORA-15055: unable to connect to ASM instance ORA-00020: maximum number of processes (100) […] Hello, After a failed crs installation, we have removed everything by using deconfigure and deinstall utility and freshly started the grid infrastruction installation, and we got this error Checking Temp space: must be greater than 120 MB. Actual 2395 MB Passed Checking swap space: must be greater than 150 MB. Actual 32767 MB Passed […] A quick troubleshooting reference for cluster interconnect performance in Oracle RAC to Identify network and contention issues. a) Check for "gc cr lost blocks" wait event in Automatic Workload Repository (AWR)/sysstats. If found, check for these errors on the NIC: Dropped packets/fragments Buffer overflows Packet reassembly failures or […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!