Subscriber Count

    459

Subscribe to Posts by Email

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

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

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

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

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

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