1) How to Install Oracle client 10.2.0.3.0 in windows 2003
The installation for 10.2.0.3.0 client first involves installing 10.2.0.1.0 downloading from oracle.com .Then next step contains downloading database patch set p5337014_10203_WINNT.zip and then proceeding .Here you need to select the previously installed client home or it might install the entire database .
2) Downloading the 11gr2
To download the 11gr2 software please follow the edelivery.oracle.com rather than oracle.com .This saes time and ensures the downloags get completed successfully.
Monday, July 26, 2010
Friday, July 23, 2010
ORA-1652 trace Analysis
Many times we dont have the sql traced whenever we hit the ORA-1652 and we send a mail to apps team no sql found and again application team come back again to us . To avoid we can do the following :
1)Set the trace to track ORA-1652 error in the memory :
ALTER SYSTEM SET EVENTS '1652 trace name ERRORSTACK level 3';
It doesnt show in the show parameter but somewhere stored in the database memory
2) To ensure the event is present even after the bounce do the following :
alter system set event=’1652 TRACE NAME ERRORSTACK LEVEL 3' scope=SPFILE;
We do this in two step as there is no magic pill to set trace in a single statement .
In any case if we need to revert back the changes ,please do the below :
1)To unset the trace event in the memory :
ALTER system SET EVENTS ’1652 TRACE NAME ERRORSTACK OFF’;
2)To unset the trace event from spfile also :
ALTER SYSTEM SET EVENT=' ' SCOPE=spfile;
Thanks to Amin Jaffer for the commands.
1)Set the trace to track ORA-1652 error in the memory :
ALTER SYSTEM SET EVENTS '1652 trace name ERRORSTACK level 3';
It doesnt show in the show parameter but somewhere stored in the database memory
2) To ensure the event is present even after the bounce do the following :
alter system set event=’1652 TRACE NAME ERRORSTACK LEVEL 3' scope=SPFILE;
We do this in two step as there is no magic pill to set trace in a single statement .
In any case if we need to revert back the changes ,please do the below :
1)To unset the trace event in the memory :
ALTER system SET EVENTS ’1652 TRACE NAME ERRORSTACK OFF’;
2)To unset the trace event from spfile also :
ALTER SYSTEM SET EVENT=' ' SCOPE=spfile;
Thanks to Amin Jaffer for the commands.
Monday, July 19, 2010
Inspirations for Daily Life
These are the inspirations I find in daily life. I like to share it with everyone and some might help you ..! ..
1) amazing thing is to observe oneself. Just give yourself 100% attention on what you do in the daily life .You can also practice this being an observer of you performing any activity. This gives an amazing peace and sweetness inside. It tells concentrate 100% of your thought on what you perform.
2)Sometimes I also like the healing meditation by Kelly Howell. That relaxes as well rejuvenates you.
3)There is an excellent yoga nidra audio by Tim Rowe ..It is really good to feel your body and relax when nothing else works to relax you.
1) amazing thing is to observe oneself. Just give yourself 100% attention on what you do in the daily life .You can also practice this being an observer of you performing any activity. This gives an amazing peace and sweetness inside. It tells concentrate 100% of your thought on what you perform.
2)Sometimes I also like the healing meditation by Kelly Howell. That relaxes as well rejuvenates you.
3)There is an excellent yoga nidra audio by Tim Rowe ..It is really good to feel your body and relax when nothing else works to relax you.
Subscribe to:
Posts (Atom)