Recent comments @weblog

Comment on Downloading Oracle Software directly to Server by Deepak

Thanks a lot Amit. Very useful doc. Please update something more like this.

Comment on Downloading Oracle Software directly to Server by Amit

Upload the cookies.txt file in same directory from where you are running the wget command.
Did you try downloading from OTN site ? Not sure if it works on the above site..

-Amit

Comment on Downloading Oracle Software directly to Server by inoideas

I tried but got the below error msg

wget .load-cookies=cookies.txt –user-agent Mozilla/4.0 http://oracle-updates-intl.oracle.com/ARUConnect/B53824-01_3of4.zip
–06:03:49– http://.load-cookies=cookies.txt/
=> `index.html’
Resolving .load-cookies=cookies.txt… failed: Name or service not known.
–06:03:49– http://oracle-updates-intl.oracle.com/ARUConnect/B53824-01_3of4.zip
=> `B53824-01_3of4.zip’
Resolving oracle-updates-intl.oracle.com… 203.77.185.23, 203.77.185.24
Connecting to oracle-updates-intl.oracle.com|203.77.185.23|:80… connected.
HTTP request sent, awaiting response… 400 Bad Request
06:03:49 ERROR 400: Bad Request.

where do i need to upload cookies.txt

Comment on Adding new ASM disk to RAC database fails by Richard

Hello,
Great this tip that you sent, you helped me so much.
but take care when to use dd command.

Regards,

Comment on Oracle Database 11G Installation on Solaris 10 by Ram

This is very straight forward and clear.It has become easy when compared to referring the looong docs.

Comment on Generating Datapump Export Dump with Dumpfile name Containing Current Date and Time by Amit

Lisa,

I think while specifying logfile parameter, u ended with double quote “. Actaully it is single quote and then `

-Amit

Comment on Upgrading Oracle RAC Database -10g by Amit

I did this upgrade long back. As far as I remember , root102.sh will automatically start the CRS and other resources.

-Amit

Comment on Upgrading Oracle RAC Database -10g by vijay

Any update on above doubt?

Comment on Generating Datapump Export Dump with Dumpfile name Containing Current Date and Time by Lisa

Saurabh,

I got an error, LRM-00112: multiple values not allowed for parameter ‘logfile’, while running the same script:

#!/bin/ksh

################################################################
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=hrdmo91
export PATH=$PATH:$ORACLE_HOME/bin
expdp sysadm/sysadm@hrdmo91 dumpfile=expdp-’date ‘+%d%m%Y_%H%M%S”.dmp directory=hrdmo91_dir logfile=expdp-’date ‘+%d%m%Y_%H%M%S”.log schemas=sysadm

Could you shed some lights how to fix it?
Thank you in advance,
Lisa

Comment on Upgrading Oracle RAC Database -10g by vijay

Hi,

In clusterware upgradation, for node1 you did shutdown and then performed upgradation. After upgradation do we need to start up the node1 before shutting down the node2 for upgradation? or we require minimal downtime here?

Comment on Upgrading Oracle RAC Database -10g by Amit

Inder,

I think I am also stopping the CRS only before running root102.sh (Step 6). Can you point the step where I have mentioned that we need to stop CRS on both nodes simultaneously.

Regards
Amit

Comment on AWE -What is It and How to use it? by Amit

Jargo,

Can you please unset SGA_MAX_SIZE parameter and try again.

Regards
Amit

Comment on Upgrading Oracle RAC Database -10g by Inder

Why we need to stop the CRS on Node 1 which is initiating CRS. As per my knowledge, you don;t need to stop anything and at the very end we only need to stop crs on node basis to execute root102.sh

Comment on AWE -What is It and How to use it? by Jargo

Hi Amit, your article was really a great help!! Though we are still trying to get some good working settings.
Our RMAN backup still fails whatever we try..
Maybe you have got some ideas:

Oracle 9.2i
CPU’s = 8
Total ram = 16GB

AWE is set at 536 870 192

DB_BLOCK_BUFFERS = 384216
sga_max_size = 1500M
shared_pool_size = 500M
PGA_AGGREGATE_TARGET = 700M

/3GB and /PAE are set in boot.ini.

We have tried several configs with all different sizes for SGA, PGA, block_buffers etc. but still we get:

MAN-03002: failure of backup command at 06/24/2010 14:26:10

ORA-04030: out of process memory when trying to allocate 1049100 bytes (pga heap,KSFQ Buffers)

with our RMAN..
Do you have any suggestions to get RMAN working again? Must be something with PGA i would suspect!

Thanks!!!
regards,
Jargo

Comment on DBMS_SCHEDULER jobs not running? by Amit

Thanks Aman. Yes above link is also very informative..

Regards
Amit

Comment on DBMS_SCHEDULER jobs not running? by Aman....

There is another thread by the same guy Ravi,
http://forums.oracle.com/forums/thread.jspa?messageID=2304463&#2304463

This is about external jobs. Very nice!

Aman….

Comment on Simplified Approach to Resolve ORA-4031 by Andy D.

Thanks so much. This helped me out a lot.

Andy.
http;//www.Franklinfaces.com

Comment on Issues with CLUSTER_DATABASE parameter by Orlando

Maybe it was inserted in the spfile a time ago and you didn’t notice.
I had similar issue this weekend,

*.cluster_database =false and also
sid.cluster_database =true

present in the spfile, inserted by another dba.

Comment on Issues with CLUSTER_DATABASE parameter by Amit

Thanks Arul. I am aware of the parameter precedence, but not sure why the parameter had instance specified to it. If we are using spfile and do not specify sid parameter it takes default value of “*” by default.

Regards
Amit

Comment on 11gR2 Database Installation with ASM on OEL5 by Amit

Thanks Gaurav. I have corrected the link now. Let me know in case you still face issues.

Regards
Amit