New Features for DBA’s

Subscribe to Posts by Email


 

Subscriber Count

    701

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

Quick Question: What happens when root.sh run in rac installation?

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 […]

May 22nd, 2013 | Tags: | Category: Quick Questions, RAC | One comment - (Comments are closed)

Just watch out for processess parameter in ASM instance

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) […]

May 22nd, 2013 | Tags: | Category: Automatic Storage Management | Comments are closed

v$sqlfn_metadata: interesting view to check the functions that introduced

Hello,

While reading some documentation on dynamic views , I came across the v$sqlfn_metadata view which shows the function (ex: min,max,avg,> etc) that introduced in which version. May be all knows it but those who does not know about it.

Here is the snippet (edited one) for your reference.

SQL> select name,version,disp_type, descr from v$sqlfn_metadata; […]

May 15th, 2013 | Tags: | Category: Administration | Comments are closed

Installer has detected that the diskgroup name provided already exists on the system.

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 […]

May 15th, 2013 | Tags: | Category: RAC | Comments are closed

RAC: Cluster Interconnect performance troubleshooting – Quick reference

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 […]

May 13th, 2013 | Tags: | Category: RAC | Comments are closed

Quick Question: What are the kernel parameters to tune cluster interconnect performance

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

May 13th, 2013 | Tags: | Category: Quick Questions, RAC | 3 comments - (Comments are closed)

Difference between object_id and data_object_id from dba_objects

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 […]

May 7th, 2013 | Tags: | Category: Uncategorized | Comments are closed