Amit
16p12 comments posted · 0 followers · following 0
14 years ago @ AskDba.org Weblog - Upgrading Oracle RAC D... · 0 replies · +1 points
I would recommend reading patch readme for details..generally for applying patchsets we do not have OS pre-requisites as these are taken care at time of base installation.
cheers
Amit
14 years ago @ AskDba.org Weblog - 11gR2 Database Install... · 0 replies · +1 points
http://download.oracle.com/docs/cd/E11882_01/inst...
Cheers
Amit
14 years ago @ AskDba.org Weblog - Creating ASM devices o... · 0 replies · +1 points
You can use soft links but oracle recommend's using mknod to create link. You can use following code to increment disk#
for i in 1960 20CD 20CE 20CF 21CD 21CE
do
j=`pcmpath query device|grep -p $i"$"|grep DEVICE|awk -F ":" '{print $3}'|awk '{print $1}`
k=`bootinfo -s $j`
a=`ls -la /dev/$j |awk '{print $5}'|awk -F "," '{print $1}'`
b=`ls -la /dev/$j |awk '{print $6}'`
b=`echo $b |awk '{x=$0+0; print x}'`
if [ b -le 1 ]
then
b=`ls -la /dev/$j |awk '{print $5}'|awk -F "," '{print $2}'`
fi
if [ m -le 8 ]
then
m=`expr $m + 1` ;echo "mknod /dev/asm_disk0"$m "c "$a $b
else
m=`expr $m + 1` ;echo "mknod /dev/asm_disk"$m "c "$a $b
fi
done
-Amit
14 years ago @ AskDba.org Weblog - 11gR2 Database Install... · 0 replies · +1 points
What are the contents of the error logfile. It should indicate why the installation failed. Meanwhile you can also follow steps for upgrading to 11gR2 here .. http://askdba.org/weblog/2009/09/get-upgrading-st...
14 years ago @ AskDba.org Weblog - dbms_stats.copy_table_... · 1 reply · +1 points
Thanks for your comments. Do you want to say that dbms_stats.copy_table_stats does not copy the histogram's ? I have not personally checked the same yet.
Regards
Amit
14 years ago @ AskDba.org Weblog - Using Oracle Wallet to... · 0 replies · +1 points
Regards
Amit
14 years ago @ AskDba.org Weblog - Using Oracle Wallet to... · 0 replies · +1 points
Do let me know if I have missed any point or you need further clarification.
14 years ago @ AskDba.org Weblog - Using Oracle Wallet to... · 0 replies · +1 points
Regards
Amit
14 years ago @ AskDba.org Weblog - 11gR2 Database Install... · 1 reply · +1 points
Are you looking for some thing else???
14 years ago @ AskDba.org Weblog - 11gR2: Monitoring Real... · 0 replies · +1 points
oops.. I had not checked 11.1.0.7 and was under impression that this option has come up as part of 11gR2. I think this will mean that I will have to check with New features guide to ensure that it is indeed a new feature :) Thanks for information. I will update the article with same
Regards
Amit