Scenario:
when Installing Oracle 11g Rel2 Grid infrastructure we got the error message INS-32026

Solution:
CRS_HOME (CRS software installation folder) should not be part of the ORACLE_HOME

We got the following Error message when we install 11g Release 2 Grid Infrastructure
INS-40922
INS-40718

Solution:
The above error messages are related to Resolving the SCAN Name. Please make sure your /etc/hosts file have the IP address assigned to SCAN name and the same SCAN name is mentioned as the SCAN Name field during installation.

Dear DBAs,

I have attended Ask Tom Live seminar about 11g Rel2 at Tokyo, Japan. Do you believe it I have got an opportunity to take a snap with him. I am very happy to share with you.

Regards
Mudhalvan M.M

Dear DBAs
I have attended Ask Tom Live seminar at Tokyo, Japan about Top 10 of 11g Rel2. This is just only topics. I will update more based on everyday when practically do it one by one. It was an excellent one. Please don’t miss if you get such an oppertunity in your countries and cities.

1. Parallelism – By ourself using – DBMS_PARALLEL_EXECUTE
DBA View – DBA_PARALLEL_EXECUTE_CHUNKS
- Until now it is manually
-Split by rowid ranges – This is Best because it will allow us to split with non-overlapping chunk and least contention.
- split table into N equi-sized,non-overlapping chunks
- create a job passing in the low and high rowids for each range
- Job would process “where rowid between :lo and :hi”
- By primary key ranges using NTILE()
- DBMS_PARALLEL)EXECUTE automates both approaches and makes it easy
2. Analytics – Coolest thing
-LISTAGG – List Aggregate function
- 9iR2 First did STRAGG
- 10g used a trick “sys_connect_by_path”
- 11g Rel2 – it become Simple

select deptno,
ename,
row_number()
over (partition by deptno
order by ename) rn,
first_value(ename) – 1st
over (partition by deptno
order by ename) “1st ename”,
nth_value(ename,3) – nth
over (partition by deptno
order by ename) “3rd ename”,
lst_value(ename) – last
over (partition by deptno
order by ename
rows between current row
and unbounded following)) “last ename”
from emp
order by deptno,ename;

3. Execute on directory

4. Recursive Subquery Factoring

5. Improved Time Travel
- Flashback Data Archive

6. Watch File or Directory
- When files arrive to some directory
- An event can be generated
- Code can be invoked to deal
7. Deffered Segment Creation
- Deferred segement allows us to put off initial extent allocation until the first row created in a segment

8. Flash Cache
- Reduce I/O bandwidth requirement with Flash Cache

9. Parallel Improved
- Automated degree of parallelism
- Parallel statement queuing
- In-Memory Parallel execution

10. Edition based Redefination

Instance Caging
=> Enables administrators to limit cpu cores by instance
=> Can be adjusted dynamically while databases are online
=> Protect Service Levels by preventing runaway cpu consumption