|
||||
|
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 […] To tune the cluster interconnect performance typically the messages buffers size that should transmit between the nodes, the following kernel parameters should set. 256K is fairly adequate. net.core.rmem_default = 262144 net.core.rmem_max = 262144 net.core.wmem_default = 262144 net.core.wmem_max = 262144 -Thanks Geek DBA Hello, I have got two questions from my friend. 1) What is the difference between object_id and data_object_id? 2) Will be there any performance impact if data_object_id changes? For the question #1, a) Object_id represents the primary_key or the unique identifier for the object b) data_object_id is the pointer […] Hello, As we all know, We have a profile setting called failed_login_attempts, where and which when a user inputs invalid password for a given threshold default is (unlimited) , then the user will be locked. Means the profile has to part with each and every user. Similarly, if you want to blockade/drop the connections for […] Thanks to Martin’s blog, which show us the data file recovery when it accidentally dropped. (apologies i lost the original link) ***** DO IT ON YOUR OWN RISK ***** Created tablespace and users and some tables. SQL> create tablespace test datafile ‘/oradata/TESTTest01.dbf’ size 100m; Tablespace created. SQL> create user test identified by test default […] Hello All, We have got an issue about time zone differences in alert logs , crs logs with system timestamp and with system timestamp. System date time [oracle@TESTRAC1]/ # date Tue Apr 24 04:10:11 CEST 2013 But database Alert log shows, Thread 1 advanced to log sequence 235 (LGWR switch) Current log# 11 […] Dear Readers, We have few good posts in Oracle community this week and here are they, and very interesting though Jonathan Lewis on Systimestamp puzzles:- systimestamp Oracle optimizer blog comes up with method_opt parameter significance in dbms_stats How does the METHOD_OPT parameter work- Randolf Geist on ASM AU Size And LMT AUTOALLOCATE Arup Nanda […] To identify the clustername in Oracle CRS use $CRS_HOME/bin/cemutlo –n or Use OCRDUMP which will create a text file called OCRDUMPFILE open that file and look for this entry #ocrdump -stdout -keyname SYSTEM | grep -A 1 clustername | grep ORATEXT | awk ‘{print $3}’ or In the script $ORA_CRS_HOME/install/rootconfig: ORA_CRS_HOME=/oracle/product/CRS CRS_ORACLE_OWNER = Oracle […] We have got a call from team asking about a high cpu usage, and here is our hunting down load averages: 97.5, 98.8, 100.0; up 11+22:24:01 01:14:52 410 processes: 276 sleeping, 118 running, 3 zombie, 13 on cpu CPU states: 0.0% idle, 89.6% user, 10.4% kernel, 0.0% iowait, 0.0% swap Memory: 32G phys mem, 17G […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!