Amit

Amit

16p

12 comments posted · 0 followers · following 0

386 weeks ago @ AskDba.org Weblog - Upgrading Oracle RAC D... · 0 replies · +1 points

Sandeep,

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

387 weeks ago @ AskDba.org Weblog - 11gR2 Database Install... · 0 replies · +1 points

Have you checked the installation guide. Have you installed all the required packages (pdksh-5.2.14 ?? ) Refer to installation guide and verify all packages are installed

http://download.oracle.com/docs/cd/E11882_01/inst...

Cheers
Amit

389 weeks ago @ AskDba.org Weblog - Creating ASM devices o... · 0 replies · +1 points

John,

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

389 weeks ago @ AskDba.org Weblog - 11gR2 Database Install... · 0 replies · +1 points

Did you select \"Upgrade Grid Infrastructure\" option.

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...

389 weeks ago @ AskDba.org Weblog - dbms_stats.copy_table_... · 1 reply · +1 points

Bob,

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

390 weeks ago @ AskDba.org Weblog - Using Oracle Wallet to... · 0 replies · +1 points

Anyone who has read permission on files ewallet.p12 and cwallet.sso can connect to the database using connect string. So if you wish to stop a particular user, ensure that the user does not have read permission on it.

Regards
Amit

390 weeks ago @ AskDba.org Weblog - Using Oracle Wallet to... · 0 replies · +1 points

No, it is not mandatory for database and client server to be on same machine. This setup can be done on any client machine. Secondly this is different from OS authentication as you can grant read access to other user or copy the wallet files to other user's directory and change the permissions. In case client is using DB home , it would be helpful if you use TNS_ADMIN variable for the user to have separate sqlnet.ora file/tnsnames.ora file.

Do let me know if I have missed any point or you need further clarification.

393 weeks ago @ AskDba.org Weblog - Using Oracle Wallet to... · 0 replies · +1 points

Thanks Gokul..Yeah this is pretty useful feature and can be used in shell scripts, rman catalog connection and exp/imp for connecting to databases.

Regards
Amit

393 weeks ago @ AskDba.org Weblog - 11gR2 Database Install... · 1 reply · +1 points

I did not understand your question. Screenshot for configuring ASM 11gR2 can be found on http://askdba.org/technical/11gr2_database_instal...

Are you looking for some thing else???

394 weeks ago @ AskDba.org Weblog - 11gR2: Monitoring Real... · 0 replies · +1 points

Hi Doug,

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